/// <summary> /// This method is use to get port storage vehicle summery report from database /// </summary> /// <param name="ReportType"></param> /// <param name="StartDate"></param> /// <param name="EndDate"></param> /// <returns></returns> public IList <VehicleListingReportProp> GetPortStorageVehicleSummeryReport(int ReportType, Nullable <DateTime> StartDate, Nullable <DateTime> EndDate) { // creating the object of PortStorageEntities Database using (PortStorageEntities psEntities = new PortStorageEntities()) { List <VehicleListingReportProp> listVehicleListingReportProp = new List <VehicleListingReportProp>(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { if (StartDate != null && EndDate != null) { var result = psEntities.spGetPortStorageVehicleSummeryReportDetail(ReportType, StartDate, EndDate).ToList(); if (result != null) { foreach (var val in result) { VehicleListingReportProp obj = new VehicleListingReportProp(); obj.CustomerID = (int)val.CustomerID; obj.CustomerName = val.CustomerName; obj.Count = (int)val.Count; listVehicleListingReportProp.Add(obj); obj = null; } } } } 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)); } return(listVehicleListingReportProp); } }
/// <summary> /// This method is used to get vehicle listing repot from database /// </summary> /// <param name="ReprintType"></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) { // creating the object of PortStorageEntities Database using (PortStorageEntities psEntities = new PortStorageEntities()) { List <VehicleListingReportProp> listVehicleListingReportProp = new List <VehicleListingReportProp>(); List <VehicleListingReportProp> lstVechiles = new List <VehicleListingReportProp>(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { // if (StartDate != null && EndDate != null) { var result = psEntities.spGetVehicleListingReportDetails(ReportType, StartDate, EndDate).ToList(); if (result != null) { foreach (var val in result) { VehicleListingReportProp obj = new VehicleListingReportProp(); obj.CustomerID = (int)val.CustomerID; obj.CustomerName = (GroupByDealerInd ? val.CustomerName : ""); //For grouping on Dealer obj.CustomerName1 = val.CustomerName; //To display obj.VIN = val.VIN; obj.Make = val.Make; obj.Model = val.Model; obj.Color = val.Color; obj.BayLocation = val.BayLocation; obj.DateIn = val.DateIn; obj.DateRequested = val.DateRequested; obj.DateOut = val.DateOut; obj.Count = result.Count; listVehicleListingReportProp.Add(obj); obj = null; } } } //if (GroupByDealerInd) //{ var group = listVehicleListingReportProp.GroupBy(x => x.CustomerName1); foreach (var innerGroup in group) { List <VehicleListingReportProp> lstVech = innerGroup.ToList(); var index = 1; lstVech[0].TempIndex = index; lstVech.Skip(1).ToList().ForEach(x => { index += 1; x.TempIndex = index; x.CustomerName1 = ""; }); lstVechiles.AddRange(lstVech); } //return lstVechiles; //} } 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)); } //return listVehicleListingReportProp; return(lstVechiles); } }