/// <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(); } }