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