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