update table set fieldName = 'append string'+ fieldName where conditions
Example:
select *from AM_Invoice where DocumentTypeId = 3 and SalesInvoiceType = 2
update AM_Invoice set InvoiceNumber = 'B/'+InvoiceNumber where DocumentTypeId = 3 and SalesInvoiceType = 2
select *from AM_Invoice where DocumentTypeId = 3 and SalesInvoiceType = 2
result:
public class MailResult : ActionResult {
string _content;
string _viewName;
string _contentType = "message/rfc822";
dynamic _model;
string _fromMailAddress;
string _toMailAddress;
public MailResult(string AViewName,dynamic AModel,string AFromMail,string AToMail) {
_viewName = AViewName;
_model = AModel;
_fromMailAddress = AFromMail;
_toMailAddress=AToMail;
}
public override void ExecuteResult(ControllerContext context)
{ var view = ViewEngines.Engines.FindView(context, _viewName, null);
var ViewData = new ViewDataDictionary();
var TempData = new TempDataDictionary();
ViewData.Model = _model;
using (var writer = new StringWriter())
{
var ccontext = new ViewContext(context, view.View, ViewData, TempData, writer); ViewData.Model = _model;
view.View.Render(ccontext, writer);
writer.Flush();
_content = writer.ToString();
}
System.Net.Mail.MailMessage msg = new MailMessage();
msg.From = new MailAddress(_fromMailAddress);
msg.To.Add(new MailAddress(_toMailAddress));
msg.IsBodyHtml = true;
msg.Body = _content;
SmtpClient smtp = new SmtpClient();
smtp.PickupDirectoryLocation
= context.HttpContext.Request.ServerVariables["APPL_PHYSICAL_PATH"];
smtp.PickupDirectoryLocation = smtp.PickupDirectoryLocation + @"\Content\Mail\"; Guid newGuId = Guid.NewGuid();
string fname = smtp.PickupDirectoryLocation + newGuId + ".eml";
//Save is an Extension method, using this we can specify the guid in to that ie; for deleting msg.Save(fname);
context.HttpContext.Response.Clear();
context.HttpContext.Response.AddHeader("Content-Disposition",string.Format("attachmen t; filename={0}", "mail.eml"));
context.HttpContext.Response.Charset = "";
context.HttpContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
context.HttpContext.Response.ContentType = _contentType
context.HttpContext.Response.TransmitFile(fname);
context.HttpContext.Response.End();
System.IO.File.Delete(fname);
}
}
public static class MailMessageExt
{
public static void Save(this MailMessage Message, string FileName)
{
Assembly assembly = typeof(SmtpClient).Assembly;
Type _mailWriterType = assembly.GetType("System.Net.Mail.MailWriter");
using (FileStream _fileStream = new FileStream(FileName, FileMode.Create))
{
// Get reflection info for MailWriter contructor
ConstructorInfo _mailWriterContructor = _mailWriterType.GetConstructor( BindingFlags.Instance | BindingFlags.NonPublic,null,new Type[] { typeof(Stream) }, null);
// Construct MailWriter object with our FileStream
object _mailWriter = _mailWriterContructor.Invoke(new object[] { _fileStream }); // Get reflection info for Send() method on MailMessage
MethodInfo _sendMethod
= typeof(MailMessage).GetMethod("Send",BindingFlags.Instance | BindingFlags.NonPublic); // Call method passing in MailWriter
_sendMethod.Invoke(Message,BindingFlags.Instance | BindingFlags.NonPublic, null,new object[] { _mailWriter, true },null);
// Finally get reflection info for Close() method on our MailWriter
MethodInfo _closeMethod = _mailWriter.GetType().GetMethod("Close", BindingFlags.Instance | BindingFlags.NonPublic);
// Call close method
_closeMethod.Invoke(_mailWriter,BindingFlags.Instance | BindingFlags.NonPublic, null,new object[] { },null);
}
}
}
Android’s new version (4.0) released few days ago. lets check what are the new features are introduced by Google in ice cream sandwich to compete Apples ios 5.
Android 4.0, Ice Cream Sandwich brings an entirely new look and feel to Android. The lock screen, widgets, notifications, multi-tasking and everything in between has been rethought and refined to make Android simple, beautiful, and beyond smart.
Galaxy Nexus – Video
New features at a glance
With Face Unlock on ice cream sandwich you can now unlock your phone with a smile. No complicated passwords to remember, just switch on your phone and look into the camera to quickly unlock your phone.
Using this android feature you can easily share your contacts,websites,apps,maps,youtube videos etc by touching two android phones each other.
Use your voice to type Emails,SMS or any where you want to type texts
more to read:
few days ago I’ve written a blog post in SQL server using CTE to find Sundays. Lets dig some more deep in to this SQL server feature.
What is CTE
The common table expression is a temporary named result set that can refer in a SELECT,INSERT, UPDATE or DELETE statement.
simply a CTE is similar to a derived table but it is not stored as an object and lasts only for the duration of the query.
Unlike a derived table, a CTE can be self referencing and can be referenced multiple times in the same query
we can use a CTE in View create statement also we can add CTE in to the new MERGE statement (In sql server 2008)
SQL Server support two types of CTEs
Syntax
A Common Table Expression contains three main parts:
With CTE_Name (Column_Name_1, Column_Name_2 … Column_Name_n )
As
(
cte_Query_Definition
)
--TSQL which uses the CTE
Some Examples
WITH Table1(Name,Designation,DateofJoin)
As
(
select CN.Name,D.Name,E.DateOfJoin from ContactName CN
Inner join AM_Employee E on E.ContactId = CN.ContactId
Inner join AM_Designation D on E.DesignationId = D.Id
)
select Name,Designation,DateofJoin from Table1
