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