//---------------------Shipping Reports--------------------
public List<ShippedReportInfo> GetShippedDetails(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, ShippedReportBasicInfo ShippedReportObj)
{
try
{
List<ShippedReportInfo> lstShipReport = AspxShipMethodMgntController.GetShippedDetails(offset, limit, aspxCommonObj, ShippedReportObj);
return lstShipReport;
}
catch (Exception ex)
{
throw ex;
}
}
//---------------------Shipping Reports--------------------
public static List <ShippedReportInfo> GetShippedDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, ShippedReportBasicInfo ShippedReportObj)
{
try
{
List <ShippedReportInfo> lstShipReport = AspxShipMethodMgntProvider.GetShippedDetails(offset, limit, aspxCommonObj, ShippedReportObj);
return(lstShipReport);
}
catch (Exception e)
{
throw e;
}
}
//---------------------Shipping Reports--------------------
public static List<ShippedReportInfo> GetShippedDetails(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, ShippedReportBasicInfo ShippedReportObj)
{
try
{
List<ShippedReportInfo> shipInfo;
List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
paramCol.Add(new KeyValuePair<string, object>("@offset", offset));
paramCol.Add(new KeyValuePair<string, object>("@limit", limit));
paramCol.Add(new KeyValuePair<string, object>("@ShppingMethod", ShippedReportObj.ShippingMethodName));
SQLHandler sageSQL = new SQLHandler();
if (ShippedReportObj.Monthly == true)
{
shipInfo = sageSQL.ExecuteAsList<ShippedReportInfo>("[dbo].[usp_Aspx_ShippingReportDetails]", paramCol);
return shipInfo;
}
if (ShippedReportObj.Weekly == true)
{
shipInfo = sageSQL.ExecuteAsList<ShippedReportInfo>("[dbo].[usp_Aspx_GetShippingDetailsByCurrentMonth]", paramCol);
return shipInfo;
}
if (ShippedReportObj.Hourly == true)
{
shipInfo = sageSQL.ExecuteAsList<ShippedReportInfo>("[dbo].[usp_Aspx_GetShippingReportDetailsBy24hours]", paramCol);
return shipInfo;
}
else
return new List<ShippedReportInfo>();
}
catch (Exception e)
{
throw e;
}
}
//---------------------Shipping Reports--------------------
public static List <ShippedReportInfo> GetShippedDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, ShippedReportBasicInfo ShippedReportObj)
{
try
{
List <ShippedReportInfo> shipInfo;
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
paramCol.Add(new KeyValuePair <string, object>("offset", offset));
paramCol.Add(new KeyValuePair <string, object>("limit", limit));
paramCol.Add(new KeyValuePair <string, object>("ShppingMethod", ShippedReportObj.ShippingMethodName));
OracleHandler sageSQL = new OracleHandler();
if (ShippedReportObj.Monthly == true)
{
shipInfo = sageSQL.ExecuteAsList <ShippedReportInfo>("[dbo].[usp_Aspx_ShippingReportDetails]", paramCol);
return(shipInfo);
}
if (ShippedReportObj.Weekly == true)
{
shipInfo = sageSQL.ExecuteAsList <ShippedReportInfo>("[dbo].[usp_Aspx_GetShippingDetailsByCurrentMonth]", paramCol);
return(shipInfo);
}
if (ShippedReportObj.Hourly == true)
{
shipInfo = sageSQL.ExecuteAsList <ShippedReportInfo>("[dbo].[usp_Aspx_GetShippingReportDetailsBy24hours]", paramCol);
return(shipInfo);
}
else
{
return(new List <ShippedReportInfo>());
}
}
catch (Exception e)
{
throw e;
}
}
