public static List <RetunReportInfo> GetReturnReport(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, ReturnReportBasicInfo returnReportObj) { try { List <RetunReportInfo> lstRtnReport = AspxUserDashProvider.GetReturnReport(offset, limit, aspxCommonObj, returnReportObj); return(lstRtnReport); } catch (Exception e) { throw e; } }
public static List <RetunReportInfo> GetReturnReport(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, ReturnReportBasicInfo returnReportObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("limit", limit)); parameter.Add(new KeyValuePair <string, object>("ReturnStatus", returnReportObj.ReturnStatus)); OracleHandler sqlh = new OracleHandler(); if (returnReportObj.Monthly == true) { return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReport", parameter)); } if (returnReportObj.Weekly == true) { return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReportByCurrentMonth", parameter)); } if (returnReportObj.Hourly == true) { return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReportBy24hours", parameter)); } else { return(new List <RetunReportInfo>()); } } catch (Exception e) { throw e; } }
public List<RetunReportInfo> GetReturnReport(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, ReturnReportBasicInfo returnReportObj) { try { List<RetunReportInfo> lstRtnReport = AspxUserDashController.GetReturnReport(offset, limit, aspxCommonObj, returnReportObj); return lstRtnReport; } catch (Exception ex) { throw ex; } }
public static List<RetunReportInfo> GetReturnReport(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, ReturnReportBasicInfo returnReportObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@offset", offset)); parameter.Add(new KeyValuePair<string, object>("@limit", limit)); parameter.Add(new KeyValuePair<string, object>("@ReturnStatus", returnReportObj.ReturnStatus)); SQLHandler sqlh = new SQLHandler(); if (returnReportObj.Monthly == true) { return sqlh.ExecuteAsList<RetunReportInfo>("usp_Aspx_GetReturnReport", parameter); } if (returnReportObj.Weekly == true) { return sqlh.ExecuteAsList<RetunReportInfo>("usp_Aspx_GetReturnReportByCurrentMonth", parameter); } if (returnReportObj.Hourly == true) { return sqlh.ExecuteAsList<RetunReportInfo>("usp_Aspx_GetReturnReportBy24hours", parameter); } else return new List<RetunReportInfo>(); } catch (Exception e) { throw e; } }