Example #1
0
 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;
     }
 }
Example #2
0
 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;
     }
 }
Example #3
0
        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;
            }
        }