public void SaveTempDataToDBLead(List <SP_GetContactPersonListToBindGridLead_Result> paraobjList, string paraSessionID, string paraUserID, string currentformid, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Remove Existing Records*/ ClearTempDataFromDB(paraSessionID, paraUserID, currentformid, conn); /*End*/ /*Begin : Serialize MergedAddToCartList*/ string xml = ""; xml = datahelper.SerializeEntity(paraobjList); /*End*/ /*Begin : Save Serialized List into TempData */ TempData tempdata = new TempData(); tempdata.Data = xml; tempdata.XmlData = ""; tempdata.LastUpdated = DateTime.Now; tempdata.SessionID = paraSessionID.ToString(); tempdata.UserID = paraUserID.ToString(); tempdata.ObjectName = currentformid.ToString(); tempdata.TableName = "-"; ce.AddToTempDatas(tempdata); ce.SaveChanges(); /*End*/ }
/// <summary> /// 2. SaveTempDataToDB /// a. paraobjList Save to DB [ TempData ] /// </summary> /// <param name="paraobjList"></param> /// <param name="paraSessionID"></param> /// <param name="paraUserID"></param> /// <param name="paraCurrentObjectName"></param> protected void SaveTempDataToDB(List <SP_GetCartProductDetail_Result> paraobjList, string paraSessionID, string paraUserID, string paraCurrentObjectName, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Remove Existing Records*/ ClearTempDataFromDB(paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ /*Begin : Serialize MergedAddToCartList*/ string xml = ""; xml = datahelper.SerializeEntity(paraobjList); /*End*/ /*Begin : Save Serialized List into TempData */ TempData tempdata = new TempData(); tempdata.Data = xml; tempdata.XmlData = ""; tempdata.LastUpdated = DateTime.Now; tempdata.SessionID = paraSessionID.ToString(); tempdata.UserID = paraUserID.ToString(); tempdata.ObjectName = paraCurrentObjectName.ToString(); tempdata.TableName = "table"; db.AddToTempDatas(tempdata); db.SaveChanges(); /*End*/ }
public void SaveTempData(List <SP_GetProductListForPartRequisition_Result> saveLst, string paraSessionID, string paraUserID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); TempData tempdata = new TempData(); TempData tempdata1 = new TempData(); tempdata = (ce.TempDatas.Where(a => a.ObjectName == "PartRequisitionProduct" && a.SessionID == paraSessionID)).FirstOrDefault(); tempdata1 = (ce.TempDatas.Where(a => a.ObjectName == "PartRequisitionProduct" && a.SessionID == paraSessionID)).FirstOrDefault(); string xml = ""; xml = datahelper.SerializeEntity(saveLst); if (tempdata == null) { tempdata = new TempData(); } tempdata.Data = xml; tempdata.XmlData = ""; tempdata.LastUpdated = DateTime.Now; tempdata.SessionID = paraSessionID.ToString(); tempdata.UserID = paraUserID.ToString(); tempdata.ObjectName = "PartRequisitionProduct"; tempdata.TableName = "table"; if (tempdata1 == null) { ce.AddToTempDatas(tempdata); } ce.SaveChanges(); }
/// <summary> /// This Is For Insert Temporory Data From TempData In to 'tAddress' table /// </summary> /// <param name="paraobjList"></param> /// <param name="paraSessionID"></param> /// <param name="paraUserID"></param> /// <param name="paraObjectName"></param> /// protected void SaveTempDataToDB(List <SP_GetAddressListToBindGrid_Result> paraobjList, string paraSessionID, string paraUserID, string TargetObjectName, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Remove Existing Records*/ ClearTempDataFromDB(paraSessionID, paraUserID, TargetObjectName, conn); /*End*/ string xml = ""; xml = datahelper.SerializeEntity(paraobjList); /*End*/ /*Begin : Save Serialized List into TempData */ TempData tempdata = new TempData(); tempdata.Data = xml; tempdata.XmlData = ""; tempdata.LastUpdated = DateTime.Now; tempdata.SessionID = paraSessionID.ToString(); tempdata.UserID = paraUserID.ToString(); tempdata.ObjectName = TargetObjectName.ToString(); tempdata.TableName = "-"; ce.AddToTempDatas(tempdata); ce.SaveChanges(); /*End*/ }
/// <summary> /// 3. SaveTempDataToDB /// a. paraobjList Save to DB [ TempData ] /// </summary> /// <param name="paraobjList"></param> /// <param name="paraSessionID"></param> /// <param name="paraUserID"></param> /// <param name="paraObjectName"></param> protected void SaveTempDataToDB(List <SP_GetTermConditionListForUCTermCondition_Result> paraobjList, string paraSessionID, string paraUserID, string paraObjectName_Old, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); TempData tempdata = new TempData(); TempData tempdata1 = new TempData(); tempdata = (db.TempDatas.Where(a => a.ObjectName == paraObjectName_Old && a.SessionID == paraSessionID)).FirstOrDefault(); tempdata1 = (db.TempDatas.Where(a => a.ObjectName == paraObjectName_Old && a.SessionID == paraSessionID)).FirstOrDefault(); /*Begin : Remove Existing Records*/ // ClearTempDataFromDB(paraSessionID, paraUserID); /*End*/ /*Begin : Serialize MergedAddToCartList*/ string xml = ""; xml = datahelper.SerializeEntity(paraobjList); /*End*/ /*Begin : Save Serialized List into TempData */ if (tempdata == null) { tempdata = new TempData(); } tempdata.Data = xml; tempdata.XmlData = ""; tempdata.LastUpdated = DateTime.Now; tempdata.SessionID = paraSessionID.ToString(); tempdata.UserID = paraUserID.ToString(); tempdata.ObjectName = paraObjectName_Old.ToString(); tempdata.TableName = "table"; if (tempdata1 == null) { db.AddToTempDatas(tempdata); } //db.AddToTempDatas(tempdata); db.SaveChanges(); /*End*/ }