Posts

Showing posts from 2013

Prevent external emails from Corporate account - Outlook 2010

Sometimes we unknowingly or by mistake we may send official/important emails to our personal email ids (or other external email ids). To prevent those instance(s), we can make use of VBA from MS-Outlook 2010 . Technically, below event triggers while we click on Send button (of course Alt + S :P) Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) If Item.Class <> olMail Then Exit Sub Dim sCompanyDomain As String: sCompanyDomain = "companydomain.com" Const PidTagSmtpAddress As String = "http://schemas.microsoft.com/mapi/proptag/0x39FE001E" On Error Resume Next Dim oMail As MailItem: Set oMail = Item Dim oRecipients As Recipients: Set oRecipients = oMail.Recipients Dim bDisplayMsgBox As Boolean: bDisplayMsgBox = False Dim sExternalAddresses As String Dim oRecipient As Recipient For Each oRecipient In oRecipients Dim oProperties As PropertyAccessor: Set oProperties = oRecipient.PropertyAccessor Dim smtpAddress As String

Sort Column data in GridView with Entity Framework

 Using db As New Model.ApplicationEntities()             Dim q = From tm In db.lk_xyzEnitty                            .... .... .. .....                     Select ..... ...... ..             ' Logic to sort the resultant list based on sort expression             If Not ResourceSortExpression Is Nothing AndAlso ResourceSortExpression <> String.Empty Then                 ' From grid, if click on sort link then below logic applied                 Dim param = Expression.Parameter(GetType(lk_xyzEnitty), CStr(ResourceSortExpression))                 Dim sortExpression = Expression.Lambda(Of Func(Of lk_xyzEnitty, Object))(Expression.Convert(Expression.Property(param, ResourceSortExpression), GetType(Object)), param)                 If ResourceSortDirection = "ASC" Then                     gridViewControl.DataSource = q.ToList().AsQueryable().OrderBy(sortExpression)                 Else                     gridViewControl.DataSource = q.ToList().AsQue

TSQL - Filter/Show All or specific records from Select query

-- Trick to filter/show all or specific records from select query DECLARE @AllRecords NCHAR(1) IF (@RoleID <= 0) SET @AllRecords = N'Y' ELSE SET @AllRecords = N'N' SELECT ROW_NUMBER() OVER (ORDER BY ar.RoleId) AS RowID , RoleName, .... FROM table1 ... .. . WHERE ar.RoleID = @RoleID OR @AllRecords = N'Y' ... .. .

Nenu naa pychayam :P

1. Beach nunchi sunrise and sunsent chooste fantastic ga vuntundi.. ade ammaitho chooste manchi Romantic ga vuntundi. ------------------------------------- 2. Samarayogulnni (freedom fighters) sanmanichukoleka pothunnam..Kanisam smarinchukundham. ------------------------------- 3. Eakathvam le ni naayakathvam.. --------------------------- 4. Raastram ragili potundhi.. kaastam ga kaali potundhi.. Veetini aape vare lera?? Avunu le.. kaastanni madhylo aarapakoodadhu ga.. andhukanenemo mari :p ---------------------------------------- 4. Thappu ga chese prabhutvam vundi.. Thappu ani cheppe prathi paksham vundi.. kani padhavi loki vachhi manchi chese valle karvu iyyaru... Eppudu topic Samakyndhra, telangana kaadhu.. Pavan kalyan politics loki vastada ani.. Media kooda super kada :) VAllaki TRP ratings ravali ga :p ---------------------------------------------- 5. Nirbandhamyna prema..Sunnitha veta anivi vundavu..  Ante balavanthamyna prema anedi vundadhu..swachhandham ga

How to take care of our eyes

1. After every 20 minutes of looking into the computer screen, turn your head and try to look at any object placed at least 20 feet away. This changes the focal length of your eyes, a must-do for the tired eyes. 2. Try and blink your eyes for 20 times in succession, to moisten them.  3. If time permits, one should walk 20 paces after every 20 minutes of sitting in one particular posture. Helps blood circulation for the entire body.  One say that your eyes are mirrors of your soul, so do take care of them, they are priceless. "Sarvendriyanam nayanam pradhanam"

August 15

I love my India I am proud to be an Indian. Independence day pillala ki choclates kosam, corporate employees ki best dressing men/women kosam, common people ki oka holiday ga mari poiena. Annam pette rythulu ki annam leka aathma hatyalu chesukuntunna...Madhya tharagathi jeevulu kareedhu ga marina kayagooralu konaleka pappu pacchadi tho saripettukunna.. I na I love my India I am proud to be an Indian. Dasabdhalu dhati sathabdhalu vypu parugulu teesina..Thara tharalu ga Prabuthvalu mari na Peadhala thala raathalu prabuthvapu kagithala geethala ki parimithamyna.. 66 yella soodhriga bharatha prasthanam lo purogathi chendhina parinethi chendhani maanava jeevana syli ki...Samajikam le ni e samajam lo praja swamyam koraky enka poradutunna... I na I love my India I am proud to be an Indian. Parai desalu manlni dhooshinichi bhadinchina enka sahanam ane chiru navvutho thalavanchina... Ikamathyam lo ikyatha lopinchi mana lo maname samaskarincha lekapotunna.. Thappu chesina vallaki siks

Your topic

Basically this topic is about Email etiquitte. nothing much to mention the words which they have given in the subject line.. Everyone knows about the topic, but try to throw a light again with etiquitte (or rules) First talk what to do and then and then say what not to do. 1. Greetings for receipient 2. Msg to be brief and to the point, if needed with proper example 3. Shouldnt send any vital or private infomation 4. Dont use emotional sings to convey our feelings 5. Subject should be simple and understandable 6. list out to whom the email/msg to be sent for, others put in CC (or optional) 7. formatting is also important, not multi-color or multi-fonts until it is required 8. major issues or discussons or lengthy email, would be ideal to summarize it properly 9. Recepient salutation and our signature is important 10. provide contact no. (office ext.) to communicate to u if they want to have a personal discussion on the email u sent. 11. IMP - Try to think