public static List <MyOrderListForReturnInfo> GetMyOrderListForReturn(int orderID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPCtC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("OrderID", orderID)); OracleHandler sqlH = new OracleHandler(); List <MyOrderListForReturnInfo> lstMyOrder = sqlH.ExecuteAsList <MyOrderListForReturnInfo>("usp_Aspx_GetMyOrdersForReturn", parameter); return(lstMyOrder); } catch (Exception e) { throw e; } }
public static List <MyReturnListInfo> GetMyReturnsList(int offset, int limit, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPCtC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("limit", limit)); OracleHandler sqlH = new OracleHandler(); List <MyReturnListInfo> lstMyReturn = sqlH.ExecuteAsList <MyReturnListInfo>("usp_Aspx_GetMyReturnsList", parameter); return(lstMyReturn); } 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)); OracleHandler sqlh = new OracleHandler(); List <ReturnCommentsInfo> info = sqlh.ExecuteAsList <ReturnCommentsInfo>("usp_Aspx_GetMyReturnsComment", parameter); return(info); } catch (Exception e) { throw e; } }