public List <SP_GetCartProductDetail_Result> GetAddToCartListBySequence(string PrdID, long Sequence, string paraSessionID, string paraUserID, string paraCurrentObjectName, string paraObjectConvertFrom, long paraReferenceID, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); List <SP_GetCartProductDetail_Result> CartProductDetails = new List <SP_GetCartProductDetail_Result>(); /*Begin : Fetch AddToCartList from tAddToCartProductDetail by ReferenceID & ObjectName*/ CartProductDetails = (from cart in db.SP_GetCartProductDetail(PrdID, Sequence, paraSessionID, paraCurrentObjectName, paraReferenceID, paraObjectConvertFrom) orderby cart.Sequence select cart).ToList(); /*End*/ ///*Begin : Serialize & Save AddToCartList*/ SaveTempDataToDB(CartProductDetails, paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ return(CartProductDetails); }
/// <summary> /// 1. CreateAddToCartTempDataList /// a. Call : GetExistingAddToCartListBySessionIDObjectName /// b. Getproduct Details for paraProductIDs /// c. Merge with existing records. /// d. Merged Data Serialize /// e. Call : SaveTempDataToDB /// f. Return Merged List /// </summary> /// <param name="paraProductIDs"></param> /// <param name="paraSessionID"></param> /// <param name="paraUserID"></param> /// <param name="paraCurrentObjectName"></param> /// <returns></returns> public List <SP_GetCartProductDetail_Result> CreateAddToCartTempDataList(string paraProductIDs, string paraSessionID, string paraUserID, string paraCurrentObjectName, string paraObjectConvertFrom, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Get Existing Records from TempData*/ List <SP_GetCartProductDetail_Result> existingAddToCartList = new List <SP_GetCartProductDetail_Result>(); existingAddToCartList = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ long MaxSequenceNo = 0; if (existingAddToCartList.Count > 0) { MaxSequenceNo = Convert.ToInt64((from lst in existingAddToCartList select lst.Sequence).Max().Value); } /*Get Product Details*/ List <SP_GetCartProductDetail_Result> getnewRec = new List <SP_GetCartProductDetail_Result>(); getnewRec = (from view in db.SP_GetCartProductDetail(paraProductIDs, MaxSequenceNo, paraSessionID, paraCurrentObjectName, 0, paraObjectConvertFrom) orderby view.Sequence select view).ToList(); /*End*/ /*Begin : Merge (Existing + Newly Added) Products to Create TempData of AddToCart*/ List <SP_GetCartProductDetail_Result> mergedAddToCartList = new List <SP_GetCartProductDetail_Result>(); mergedAddToCartList.AddRange(existingAddToCartList); mergedAddToCartList.AddRange(getnewRec); /*End*/ /*Begin : Serialize & Save MergedAddToCartList*/ SaveTempDataToDB(mergedAddToCartList, paraSessionID, paraUserID, paraCurrentObjectName, conn); /*End*/ return(mergedAddToCartList); }