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