public static void ReturnSaveComments(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { AspxUserDashProvider.ReturnSaveComments(returnDetailObj, aspxCommonObj); } catch (Exception e) { throw e; } }
public static List <ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <ReturnItemsInfo> info = AspxUserDashProvider.GetMyReturnsDetails(returnDetailObj, aspxCommonObj); return(info); } catch (Exception e) { throw e; } }
public static List <ReturnCommentsInfo> GetMyReturnsComment(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPCtC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("@OrderID", returnDetailObj.OrderID)); SQLHandler sqlh = new SQLHandler(); List <ReturnCommentsInfo> info = sqlh.ExecuteAsList <ReturnCommentsInfo>("usp_Aspx_GetMyReturnsComment", parameter); return(info); } 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 <ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); OracleHandler sqlh = new OracleHandler(); List <ReturnItemsInfo> info = sqlh.ExecuteAsList <ReturnItemsInfo>("usp_Aspx_GetMyReturnsDetails", parameter); return(info); } 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; } }
public static void ReturnUpdate(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamNoCID(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>("ReturnActionID", returnDetailObj.ReturnActionID)); parameter.Add(new KeyValuePair <string, object>("ReturnStatusID", returnDetailObj.ReturnStatusID)); parameter.Add(new KeyValuePair <string, object>("ShippingMethodID", returnDetailObj.shippingMethodID)); parameter.Add(new KeyValuePair <string, object>("ShippingCost", returnDetailObj.ShippingCost)); parameter.Add(new KeyValuePair <string, object>("OtherPostalCharges", returnDetailObj.OtherPostalCharges)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ReturnUpdate", parameter); } catch (Exception e) { throw e; } }
public List<ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj) { try { List<ReturnDetailsInfo> info = AspxUserDashController.GetReturnDetails(offset, limit, aspxCommonObj, returnDetailObj); return info; } catch (Exception ex) { throw ex; } }
public List<ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List<ReturnItemsInfo> info = AspxUserDashController.GetMyReturnsDetails(returnDetailObj, aspxCommonObj); return info; } catch (Exception ex) { throw ex; } }
public void ReturnSaveComments(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { AspxUserDashController.ReturnSaveComments(returnDetailObj, aspxCommonObj); } catch (Exception ex) { throw ex; } }
public static List <ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("limit", limit)); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); parameter.Add(new KeyValuePair <string, object>("UserName", returnDetailObj.CustomerName)); parameter.Add(new KeyValuePair <string, object>("StatusName", returnDetailObj.ReturnStatus)); parameter.Add(new KeyValuePair <string, object>("DateAdded", returnDetailObj.DateAdded)); parameter.Add(new KeyValuePair <string, object>("DateModified", returnDetailObj.DateModified)); OracleHandler sqlH = new OracleHandler(); List <ReturnDetailsInfo> info = sqlH.ExecuteAsList <ReturnDetailsInfo>("usp_Aspx_GetReturnDetails", parameter); return(info); } catch (Exception e) { throw e; } }
public static List<ReturnsShippingInfo> GetMyReturnsShippingMethod(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List<ReturnsShippingInfo> info; info = AspxUserDashProvider.GetMyReturnsShippingMethod(returnDetailObj, aspxCommonObj); return info; } catch (Exception e) { throw e; } }
public static void ReturnUpdate(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamNoCID(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>("@ReturnActionID", returnDetailObj.ReturnActionID)); parameter.Add(new KeyValuePair<string, object>("@ReturnStatusID", returnDetailObj.ReturnStatusID)); parameter.Add(new KeyValuePair<string, object>("@ShippingMethodID", returnDetailObj.shippingMethodID)); parameter.Add(new KeyValuePair<string, object>("@ShippingCost", returnDetailObj.ShippingCost)); parameter.Add(new KeyValuePair<string, object>("@OtherPostalCharges", returnDetailObj.OtherPostalCharges)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ReturnUpdate", parameter); } catch (Exception e) { throw e; } }
public static List<ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@offset", offset)); parameter.Add(new KeyValuePair<string, object>("@limit", limit)); parameter.Add(new KeyValuePair<string, object>("@ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair<string, object>("@OrderID", returnDetailObj.OrderID)); parameter.Add(new KeyValuePair<string, object>("@UserName", returnDetailObj.CustomerName)); parameter.Add(new KeyValuePair<string, object>("@StatusName", returnDetailObj.ReturnStatus)); parameter.Add(new KeyValuePair<string, object>("@DateAdded", returnDetailObj.DateAdded)); parameter.Add(new KeyValuePair<string, object>("@DateModified", returnDetailObj.DateModified)); SQLHandler sqlH = new SQLHandler(); List<ReturnDetailsInfo> info = sqlH.ExecuteAsList<ReturnDetailsInfo>("usp_Aspx_GetReturnDetails", parameter); return info; } catch (Exception e) { throw e; } }
public static List<ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair<string, object>("@OrderID", returnDetailObj.OrderID)); SQLHandler sqlh = new SQLHandler(); List<ReturnItemsInfo> info = sqlh.ExecuteAsList<ReturnItemsInfo>("usp_Aspx_GetMyReturnsDetails", parameter); return info; } 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)); SQLHandler sqlh = new SQLHandler(); List<ReturnsShippingInfo> info; info = sqlh.ExecuteAsList<ReturnsShippingInfo>("usp_Aspx_GetShippingMethodByTotalWeightForReturn", parameter); return info; } 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)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ReturnSaveComments", parameter); } catch (Exception e) { throw e; } }
public static List <ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj) { try { List <ReturnDetailsInfo> info = AspxUserDashProvider.GetReturnDetails(offset, limit, aspxCommonObj, returnDetailObj); return(info); } catch (Exception e) { throw e; } }