/// <summary> /// This method is used to get port storage request report from database /// </summary> /// <param name="ReportType"></param> /// <param name="CustomerId"></param> /// <param name="VIN"></param> /// <param name="RequestDateFrom"></param> /// <param name="RequestDateTo"></param> /// <param name="BatchId"></param> /// <returns></returns> public IList <PortStorageRequestsReportProp> GetPortStorageRequestReport(int ReportType, int CustomerId, string VIN, Nullable <DateTime> RequestDateFrom, Nullable <DateTime> RequestDateTo, int BatchId) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); PortStorageReportDAL portStorageReportDAL = new PortStorageReportDAL(); return(portStorageReportDAL.GetPortStorageRequestReport(ReportType, CustomerId, VIN, RequestDateFrom, RequestDateTo, BatchId)); } catch (Exception ex) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// This method is used to get vehicle listing repot from database /// </summary> /// <param name="ReportType"></param> /// <param name="StartDate"></param> /// <param name="EndDate"></param> /// <param name="GroupByDealerInd"></param> /// <returns></returns> public IList <VehicleListingReportProp> GetVehicleListingReport(int ReportType, Nullable <DateTime> StartDate, Nullable <DateTime> EndDate, bool GroupByDealerInd) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); PortStorageReportDAL portStorageReportDAL = new PortStorageReportDAL(); return(portStorageReportDAL.GetVehicleListingReport(ReportType, StartDate, EndDate, GroupByDealerInd)); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// This method is used to Load Batch list from database/ /// </summary> /// <returns></returns> public List <PortStorageRequestsReportProp> LoadBatchList() { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); PortStorageReportDAL portStorageReportDAL = new PortStorageReportDAL(); return(portStorageReportDAL.LoadBatchList()); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// This function is used to get Port Storage InBound List from database /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> public async Task <List <PortStorageInventoryList> > GetPortStorageInBoundList(DateTime?startDate, DateTime?endDate) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); PortStorageReportDAL portStorageReportDAL = new PortStorageReportDAL(); return(await portStorageReportDAL.GetPortStorageInBoundList(startDate, endDate)); } catch (Exception ex) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }