public void CrudNotification(Notification objNotification)
{
//create XML Document Class objct
xmlDoc = new XmlDocument();
//creating header tag
xmlDoc = XMLdoc.CreateXmlHeading(xmlDoc);
//--------------creating elements with data in header roor------------
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "notificationid", objNotification.NotificationId.ToString());
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "code", objNotification.Code);
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "notificationtext", objNotification.NotificationText);
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "createdby", objNotification.CreatedBy.ToString());
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "modifiedby", objNotification.ModifiedBy.ToString());
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "feeamount", objNotification.FeeAmount.ToString());
xmlDoc = XMLdoc.AddXmlElement(xmlDoc, "isactive", objNotification.IsActive.ToString());
//-----------creating elements with data in header roo-----------------------------------
SqlParameter param = new SqlParameter("@err_msg", SqlDbType.VarChar, 500);
param.Direction = ParameterDirection.Output;
lobj1.Database.ExecuteSqlCommand("proc_Notifications @xml,@type,@err_msg out",
new SqlParameter("@xml", xmlDoc.InnerXml),
new SqlParameter("@type", objNotification.Type),
param
);
}
public void CrudNotification(Notification objNotification)
{
obj.CrudNotification(objNotification);
}