public static decimal GetCartItemsCount(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); OracleHandler sqlH = new OracleHandler(); return(sqlH.ExecuteAsScalar <decimal>("usp_Aspx_GetCartItemsCount", parameter)); } catch (Exception e) { throw e; } }
public HeaderItemsCount GetHeaderItemsCount(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteAsObject <HeaderItemsCount>("[usp_Aspx_GetHeaderItemsCount]", parameter)); } catch (Exception e) { throw e; } }
//----------------------Count my cart items-------------------- public static int GetCartItemsCount(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); int cartItemCount = sqlH.ExecuteAsScalar <int>("usp_Aspx_GetCartItemsCount", parameter); return(cartItemCount); } catch (Exception e) { throw e; } }
public static List<CartInfo> GetCartCheckOutDetails(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); List<CartInfo> lstCart= sqlH.ExecuteAsList<CartInfo>("usp_Aspx_GetCartOverView", parameter); return lstCart; } catch (Exception e) { throw e; } }
//Cart Item Qty Discount Calculations public static decimal GetDiscountQuantityAmount(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); decimal qtyDiscount= sqlH.ExecuteNonQueryAsGivenType<decimal>("usp_Aspx_GetItemQuantityDiscountAmount", parameter, "@QtyDiscount"); return qtyDiscount; } catch (Exception e) { throw e; } }
public static DataSet GetCartDetailsDataSet(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); DataSet lstCart = sqlH.ExecuteAsDataSet("usp_Aspx_GetCartDetails", parameter); return(lstCart); } catch (Exception e) { throw e; } }
public static List <ItemBasicDetailsInfo> GetYouMayAlsoLikeItems(string itemSKU, AspxCommonInfo aspxCommonObj, int count) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@itemSKU", itemSKU)); parameter.Add(new KeyValuePair <string, object>("@Count", count)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstYouMayLike = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetYouMayAlsoLikeItems", parameter); return(lstYouMayLike); } catch (Exception e) { throw e; } }
public static void ReturnSaveComments(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); parameter.Add(new KeyValuePair <string, object>("CommentText", returnDetailObj.CommentText)); parameter.Add(new KeyValuePair <string, object>("IsNotifiedByEmail", returnDetailObj.IsCustomerNotifiedByEmail)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ReturnSaveComments", parameter); } catch (Exception e) { throw e; } }
public static List <ReturnsShippingInfo> GetMyReturnsShippingMethod(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); OracleHandler sqlh = new OracleHandler(); List <ReturnsShippingInfo> info; info = sqlh.ExecuteAsList <ReturnsShippingInfo>("usp_Aspx_GetShippingMethodByTotalWeightForReturn", parameter); return(info); } catch (Exception e) { throw e; } }