public List <POR_SP_GetPartDetails_OfConsumption_Result> GetConsumptionPartDetailByConsumptionID(long ConsumptionID, long siteID, string sessionID, string userID, string CurrentObject, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); List <POR_SP_GetPartDetails_OfConsumption_Result> PartDetail = new List <POR_SP_GetPartDetails_OfConsumption_Result>(); PartDetail = (from sp in db.POR_SP_GetPartDetails_OfConsumption(0, ConsumptionID, siteID, "0", "0", 0) select sp).ToList(); SaveTempDataToDB(PartDetail, sessionID, userID, CurrentObject, conn); return(PartDetail); }
public List <POR_SP_GetPartDetails_OfConsumption_Result> AddPartIntoConsumption_TempDataByGrdIDs(string GrdIDs, string paraSessionID, string paraUserID, string paraCurrentObjectName, long SiteID, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Get Existing Records from TempData*/ List <POR_SP_GetPartDetails_OfConsumption_Result> existingList = new List <POR_SP_GetPartDetails_OfConsumption_Result>(); existingList = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ long MaxSequenceNo = 0; if (existingList.Count > 0) { MaxSequenceNo = Convert.ToInt64((from lst in existingList select lst.Sequence).Max().Value); } /*Get Product Details*/ List <POR_SP_GetPartDetails_OfConsumption_Result> getnewRec = new List <POR_SP_GetPartDetails_OfConsumption_Result>(); getnewRec = (from view in db.POR_SP_GetPartDetails_OfConsumption(0, 0, SiteID, GrdIDs, "0", MaxSequenceNo) orderby view.Sequence select view).ToList(); /*End*/ /*Begin : Merge (Existing + Newly Added) Products to Create TempData of AddToCart*/ List <POR_SP_GetPartDetails_OfConsumption_Result> mergedList = new List <POR_SP_GetPartDetails_OfConsumption_Result>(); mergedList.AddRange(existingList); mergedList.AddRange(getnewRec); /*End*/ /*Begin : Serialize & Save MergedAddToCartList*/ SaveTempDataToDB(mergedList, paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ return(mergedList); }