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