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;
            }
        }
Ejemplo n.º 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));
                SQLHandler sqlh = new SQLHandler();
                List <ReturnCommentsInfo> info = sqlh.ExecuteAsList <ReturnCommentsInfo>("usp_Aspx_GetMyReturnsComment", parameter);
                return(info);
            }

            catch (Exception e)
            {
                throw e;
            }
        }
Ejemplo n.º 4
0
 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;
     }
 }
Ejemplo n.º 5
0
        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;
            }
        }
Ejemplo n.º 6
0
        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;
            }
        }
Ejemplo n.º 7
0
 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;
            }

        }
Ejemplo n.º 11
0
 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;
     }
 }
        public static void ReturnSaveComments(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                AspxUserDashProvider.ReturnSaveComments(returnDetailObj, aspxCommonObj);
            }
            catch (Exception e)
            {
                throw e;
            }

        }