Tuesday, January 24, 2012

How to Convert XML String to XML and Get Values With LINQ


XDocument XMLdoc = XDocument.Parse(XMLString);
try
{
string body;
string CcMailid = "";
string Path = Server.MapPath("~/Imgs/Logo.gif");
string rootUrl = Page.Request.ServerVariables["HTTP_HOST"].ToString() + RequestDetails;

var XMLVales = (from _Doc in XMLdoc.Descendants("Product")
select new
{
ProductName = _Doc.Element("ProductName").Value,
Quantity = _Doc.Element("ProductQuanity").Value,
Amount = _Doc.Element("ProductAmt").Value,
TotalAmount = _Doc.Element("ProductTotalAmt").Value
}).Last();

body = ObjHtmlBody.BodyContentNew(RequesterName, SubmitterName, ReqId, XMLVales.ProductName, XMLVales.Quantity, XMLVales.Amount, XMLVales.TotalAmount, rootUrl);
string[] _ReqCode = ddlRequestFrom.SelectedValue.Split('^');
if (Convert.ToString(Session["EmpCode"]) != Convert.ToString(_ReqCode[0]))
{
CcMailid = _ReqCode[1].Trim();
}
ObjSendMail.SendEmail(ToMailId, CcMailid, "New Requst", body, Path);
}
catch (Exception Ex)
{
ErrorLog.WriteError("FrmRequest() --> : buildAndSendEmail() : --> " + Ex);
}

No comments:

Post a Comment