public List <POR_SP_GetPartDetails_OfGRN_HQ_Result> GetReceiptPartDetailByIssueID(long IssueID, long SiteID, string sessionID, string userID, string CurrentObject, string IssuedQtySameAs, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); List <POR_SP_GetPartDetails_OfGRN_HQ_Result> PartDetail = new List <POR_SP_GetPartDetails_OfGRN_HQ_Result>(); PartDetail = db.POR_SP_GetPartDetails_OfGRN_HQ("0", 0, IssueID, SiteID, 0).ToList(); SaveTempDataToDB(PartDetail, sessionID, userID, CurrentObject, conn); return(PartDetail); }
public List <POR_SP_GetPartDetails_OfGRN_HQ_Result> AddPartIntoReceipt_TempData(string PartIDs, long SiteID, string paraSessionID, string paraUserID, string paraCurrentObjectName, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Get Existing Records from TempData*/ List <POR_SP_GetPartDetails_OfGRN_HQ_Result> existingList = new List <POR_SP_GetPartDetails_OfGRN_HQ_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_OfGRN_HQ_Result> getnewRec = new List <POR_SP_GetPartDetails_OfGRN_HQ_Result>(); getnewRec = (from view in db.POR_SP_GetPartDetails_OfGRN_HQ(PartIDs, 0, 0, SiteID, MaxSequenceNo) orderby view.Sequence select view).ToList(); /*End*/ /*Begin : Merge (Existing + Newly Added) Products to Create TempData of AddToCart*/ List <POR_SP_GetPartDetails_OfGRN_HQ_Result> mergedList = new List <POR_SP_GetPartDetails_OfGRN_HQ_Result>(); mergedList.AddRange(existingList); mergedList.AddRange(getnewRec); /*End*/ /*Begin : Serialize & Save MergedAddToCartList*/ SaveTempDataToDB(mergedList, paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ return(mergedList); }