public List <SalesReportModel> GetSalesReportDetails(int?AgentId, DateTime?fromdate, DateTime?todate, int AirlinesTypeId, int?currencyId) { var data = ent.Air_GetAgentBillingStatementDetails(AgentId, fromdate, todate, currencyId); List <SalesReportModel> model = new List <SalesReportModel>(); foreach (var item in data.Select(x => x)) { var SalesReportModel = new SalesReportModel(); SalesReportModel.AirlineCode = item.Code; SalesReportModel.AirlineName = item.Name; SalesReportModel.TicketNumber = item.TicketNumber; SalesReportModel.IssuedDate = item.IssueDate; SalesReportModel.Cash = item.Cash; TotalAgentBillingStatementDetails_Cash = TotalAgentBillingStatementDetails_Cash + (decimal)item.Cash; SalesReportModel.SumAgentBillingStatementDetails_Cash = TotalAgentBillingStatementDetails_Cash; SalesReportModel.Tax = (decimal)item.Tax; TotalAgentBillingStatementDetails_Tax = TotalAgentBillingStatementDetails_Tax + (decimal)item.Tax; SalesReportModel.SumAgentBillingStatementDetails_Tax = TotalAgentBillingStatementDetails_Tax; SalesReportModel.Commission = (decimal)item.Commission; TotalAgentBillingStatementDetails_Commission = TotalAgentBillingStatementDetails_Commission + (decimal)item.Commission; SalesReportModel.SumAgentBillingStatementDetails_Commission = TotalAgentBillingStatementDetails_Commission; SalesReportModel.Payable = (decimal)item.Payable; TotalAgentBillingStatementDetails_Payable = TotalAgentBillingStatementDetails_Payable + (decimal)item.Payable; SalesReportModel.SumAgentBillingStatementDetails_Payable = TotalAgentBillingStatementDetails_Payable; SalesReportModel.AgentName = item.Agent; SalesReportModel.serviceProviderName = item.ServiceProviderName; SalesReportModel.issueFrom = item.IssueFrom; SalesReportModel.AgentId = item.AgentId; var agentinfo = agencyProvider.GetAgentInfo(item.AgentId); SalesReportModel.AgentCode = agentinfo.AgentCode; var distributor = distributorManagementProvider.GetDistributorByDistributorId(agentinfo.DistributorId); if (distributor != null) { SalesReportModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(agentinfo.BranchOfficeId); if (branchOffice != null) { SalesReportModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(SalesReportModel); } return(model); }
public List <IssuedTicketModel> ListIssuedTicketReport(int?AgentId, DateTime fromdate, DateTime todate) { var data = ent.Air_GetIssuedTicket(AgentId, fromdate, todate); List <IssuedTicketModel> model = new List <IssuedTicketModel>(); foreach (var item in data.Select(x => x)) { var IssuedTicketModel = new IssuedTicketModel { PNRId = item.PNRId, PassengerName = item.PassengerName, Sector = item.Sector, TicketStatusName = item.ticketStatusName, GDSReferenceNumber = item.GDSRefrenceNumber, IssuedOn = item.IssuedOn, CreatedBy = item.IssuedBy, AgentName = item.AgentName, FlightDate = item.FlightDate, ServiceProviderName = item.ServiceProviderName, IssuedBy = item.IssuedBy, ServiceProviderETicketUrl = (item.ServiceProviderId == 5 || item.ServiceProviderId == 4) ? "/Airline/LccTicketManagement" : "/Airline/TicketManagement", //ServiceProviderETicketUrl = "/Airline/LccTicketManagement", isTicketUploaded = item.isTicketUploaded, AgentId = item.AgentId, BracnOfficeId = item.BranchOfficeId, DistributorId = item.DistributorId, AgentCode = new ATLTravelPortal.Areas.Airline.Repository.BookedTicketReportProvider().GetAgentCodeById(item.AgentId), NoOfPax = item.PaxCount, AirlineCode = item.OperatingAirline }; var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId); if (distributor != null) { IssuedTicketModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId); if (branchOffice != null) { IssuedTicketModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(IssuedTicketModel); } return(model.OrderByDescending(x => x.BookedOn).ToList()); }
public List <PendingBookingModel> ListPendingBookintReport(int?AgentId, DateTime?fromdate, DateTime?todate) { var data = ent.Air_GetPendingTicket(AgentId, fromdate, todate); List <PendingBookingModel> model = new List <PendingBookingModel>(); foreach (var item in data.Select(x => x)) { var PendingBookingModel = new PendingBookingModel { PNRId = item.PNRId, AgentName = item.AgentName, GDSReferenceNumber = item.GDSRefrenceNumber, PassegerName = item.PassengerName, Sector = item.Sector, BookedOn = (DateTime)item.BookedOn, BookedBy = item.BookedBy, ServiceProviderName = item.ServiceProviderName, FlightDate = item.FlightDate, // ServiceProviderReferenceNumber = item.ServiceProviderName == "TBO" ? "/IndianLCC/LccPNRDetail" : "/Airline/PNRDetail", AgentId = item.AgentId, BrachOfficeId = item.BranchOfficeId, DistributorId = item.DistributorId, AgentCode = new ATLTravelPortal.Areas.Airline.Repository.BookedTicketReportProvider().GetAgentCodeById(item.AgentId) }; var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId); if (distributor != null) { PendingBookingModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId); if (branchOffice != null) { PendingBookingModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(PendingBookingModel); } return(model.ToList()); }
public List <CancelledVoidTicketModel> ListCancelledVoidTicketReport(int?AgentId, DateTime?fromdate, DateTime?todate, int?AirlineTypeId) { var data = ent.Air_GetCancelledVoidTicket(AgentId, fromdate, todate, AirlineTypeId); List <CancelledVoidTicketModel> model = new List <CancelledVoidTicketModel>(); foreach (var item in data.Select(x => x)) { var CancelledVoidTicketModel = new CancelledVoidTicketModel(); CancelledVoidTicketModel.PNRId = item.PNRId; CancelledVoidTicketModel.AgentName = item.AgentName; CancelledVoidTicketModel.GDSReferenceNumber = item.GDSRefrenceNumber; CancelledVoidTicketModel.PassengerName = item.PassengerName; CancelledVoidTicketModel.Sector = item.Sector; CancelledVoidTicketModel.CancelledOn = item.CancelledOn; CancelledVoidTicketModel.ServiceProviderId = item.ServiceProviderId; CancelledVoidTicketModel.Info = item.Info; CancelledVoidTicketModel.FlightDate = item.FlightDate; CancelledVoidTicketModel.AgentId = item.AgentId; CancelledVoidTicketModel.BranchOfficeId = item.BranchOfficeId; CancelledVoidTicketModel.DistributorId = item.DistributorId; CancelledVoidTicketModel.AgentCode = new ATLTravelPortal.Areas.Airline.Repository.BookedTicketReportProvider().GetAgentCodeById(item.AgentId); var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId); if (distributor != null) { CancelledVoidTicketModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId); if (branchOffice != null) { CancelledVoidTicketModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(CancelledVoidTicketModel); } return(model.OrderByDescending(x => x.CancelledOn).ToList()); }
public List <BookedTicketModels> ListBookedReport(int?AgentId, DateTime?fromdate, DateTime?todate) { var data = ent.Air_GetBookedTicket(AgentId, fromdate, todate); List <BookedTicketModels> model = new List <BookedTicketModels>(); foreach (var item in data.Select(x => x)) { var BookedTicketModel = new BookedTicketModels { PNRId = item.PNRId, PassengerName = item.PassengerName, Sector = item.Sector, BookedOn = (DateTime)item.BookedOn, BookedBy = item.BookedBy, GDSRefrenceNumber = item.GDSRefrenceNumber, AgentName = item.AgentName, FlightDate = item.FlightDate, ServiceProviderId = item.ServiceProviderId, AgentId = item.AgentId, DistributorId = item.DistributorId, BranchOfficeId = item.BranchOfficeId, AgentCode = GetAgentCodeById(item.AgentId), }; var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId); if (distributor != null) { BookedTicketModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId); if (branchOffice != null) { BookedTicketModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(BookedTicketModel); } return(model.OrderByDescending(x => x.BookedOn).ToList()); }