/// <summary>
/// ClearTempDataFromDB is the method to clear Records From TempData Table
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraUserID"></param>
/// <param name="paraObjectName"></param>
public void ClearTempDataFromDB(string paraSessionID, string paraUserID, string currentformid, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
TempData tempdata = new TempData();
tempdata = (from rec in ce.TempDatas
where rec.SessionID == paraSessionID &&
rec.UserID == paraUserID &&
rec.ObjectName == currentformid
select rec).FirstOrDefault();
if (tempdata != null)
{
ce.DeleteObject(tempdata); ce.SaveChanges();
}
}
/// <summary>
/// 5. ClearTempDataFromDB
/// a. Fetch TempData by SessionID & ObjectName from DB [TempData] By ObjectName & ReferenceID
/// b. Delete from DB [ TempData ]where Data = fetcheddata
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraUserID"></param>
/// <param name="paraObjectName"></param>
public void ClearTempDataFromDB(string paraSessionID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
TempData tempdata = new TempData();
tempdata = (from rec in db.TempDatas
where rec.SessionID == paraSessionID &&
rec.UserID == paraUserID &&
rec.ObjectName == "Discount"
select rec).FirstOrDefault();
if (tempdata != null)
{
db.DeleteObject(tempdata); db.SaveChanges();
}
}
