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;
}
}
