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