public void FinalSave(List <SP_GetDataToBindRoleMaster_Result> sessionList, mRole objmRole, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
if (objmRole.ID == 0)
{
db.AddTomRoles(objmRole); db.SaveChanges();
}
else
{
db.mRoles.Attach(objmRole);
db.ObjectStateManager.ChangeObjectState(objmRole, EntityState.Modified); db.SaveChanges();
}
if (sessionList.Count > 0)
{
XElement xmlEle = new XElement("RoleMasterList", from rec in sessionList.AsEnumerable()
select new XElement("RoleMaster",
new XElement("ObjectName", rec.ObjectName),
new XElement("Add", rec.Add),
new XElement("Edit", rec.Edit),
new XElement("View", rec.View),
new XElement("Delete", rec.Delete),
new XElement("Approval", rec.Approval),
new XElement("AssignTask", rec.AssignTask)
));
ObjectParameter _paraXmlData = new ObjectParameter("xmlData", typeof(string));
_paraXmlData.Value = xmlEle.ToString();
ObjectParameter _paraRoleID = new ObjectParameter("paraRoleID", typeof(long));
_paraRoleID.Value = objmRole.ID;
ObjectParameter _paraCompanyID = new ObjectParameter("paraCompanyID", typeof(long));
_paraCompanyID.Value = objmRole.CompanyID;
ObjectParameter[] obj = new ObjectParameter[] { _paraXmlData, _paraRoleID, _paraCompanyID };
db.ExecuteFunction("SP_InsertIntoRoleMasterDetail", obj);
db.SaveChanges();
}
}
