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