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*/
}
