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()); }
public ActionResult Create(AgentModel model, List <AgentBankModel> AgentBankModel, int[] ChkSettingId, FormCollection fc) { TravelSession obj = SessionStore.GetTravelSession(); model.BranchOfficeId = distributorManagementProvider.GetDistributorByDistributorId(obj.LoginTypeId).BranchOfficeId; model.DistributorId = obj.LoginTypeId; model.CreatedbyUser = obj.AppUserId; model.CreatedBy = LogedUserId; model.CreatedDate = CurrentDate; model.AgentStatusid = 1; model.EmailId = model.EmailId.Trim(';'); if (!_rep.CheckDuplicateEmail(model.Email)) { TempData["ErrorMessage"] = "Registration failed! Email already exists, please re-enter and try again"; AgentModel viewmodel = new AgentModel { ProductBaseRoleList = _rep.GetProductList(), }; ViewData["Countrylist"] = new SelectList(_rep.GetCountry(), "CountryId", "CountryName", 0); ViewData["Status"] = new SelectList(_rep.GetStatus(), "id", "Name", 1); ViewData["AirlineGroup"] = new SelectList(_rep.GetAirlineGroup(), "AirlineGroupId", "AirlineGroupName"); ViewData["RoleAssign"] = new SelectList("", "RoleName", "RoleName", ""); ViewData["AgentTypes"] = new SelectList(_rep.GetAgentType(), "AgentTypeId", "AgentTypeName"); ViewData["AgentZone"] = new SelectList(_rep.GetZoneList(), "ZoneId", "ZoneName"); ViewData["AgentDistrict"] = new SelectList(_rep.GetDistrictListbyZoneId(1), "DistrictId", "DistrictName"); ViewData["Banks"] = new SelectList(_rep.GetbankInformation(), "BankId", "BankName"); ViewData["BankBranches"] = new SelectList(_rep.GetbankBranchInformation(), "BankBranchId", "BranchName"); ViewData["BankAccountTypes"] = new SelectList(_rep.GetbankAccountType(), "BankAccountTypeId", "AccountTypeName"); ViewData["TimeZones"] = new SelectList(_rep.GetTimeZoneList(), "RecordID", "StandardName", 66); return(View("Create", viewmodel)); } else { if (!string.IsNullOrEmpty(model.MobileNo) && !_rep.CheckDuplicateMobileNumber(model.MobileNo)) { TempData["ErrorMessage"] = "Registration failed! Mobile Number already exists, please re-enter and try again"; AgentModel viewmodel = new AgentModel { ProductBaseRoleList = _rep.GetProductList(), }; ViewData["Countrylist"] = new SelectList(_rep.GetCountry(), "CountryId", "CountryName", 0); ViewData["Status"] = new SelectList(_rep.GetStatus(), "id", "Name", 1); ViewData["AirlineGroup"] = new SelectList(_rep.GetAirlineGroup(), "AirlineGroupId", "AirlineGroupName"); ViewData["RoleAssign"] = new SelectList("", "RoleName", "RoleName", ""); ViewData["AgentTypes"] = new SelectList(_rep.GetAgentType(), "AgentTypeId", "AgentTypeName"); ViewData["AgentZone"] = new SelectList(_rep.GetZoneList(), "ZoneId", "ZoneName"); ViewData["AgentDistrict"] = new SelectList(_rep.GetDistrictListbyZoneId(1), "DistrictId", "DistrictName"); ViewData["Banks"] = new SelectList(_rep.GetbankInformation(), "BankId", "BankName"); ViewData["BankBranches"] = new SelectList(_rep.GetbankBranchInformation(), "BankBranchId", "BranchName"); ViewData["BankAccountTypes"] = new SelectList(_rep.GetbankAccountType(), "BankAccountTypeId", "AccountTypeName"); ViewData["TimeZones"] = new SelectList(_rep.GetTimeZoneList(), "RecordID", "StandardName", 66); return(View("Create", viewmodel)); } else { int[] ChkProductId = new int[1] { 1 }; _res = _rep.Create(model, AgentBankModel, ChkProductId, fc); TempData["InfoMessage"] = _res.ActionMessage; if (_res.ErrNumber == 0) { return(RedirectToAction("Index")); } else { AgentModel viewmodel = new AgentModel { ProductBaseRoleList = _rep.GetProductList(), }; TempData["ErrorMessage"] = "Registration failed! Either Enter Username or Your passwords must match, please re-enter and try again"; ViewData["Countrylist"] = new SelectList(_rep.GetCountry(), "CountryId", "CountryName", 0); ViewData["Status"] = new SelectList(_rep.GetStatus(), "id", "Name", 1); ViewData["AirlineGroup"] = new SelectList(_rep.GetAirlineGroup(), "AirlineGroupId", "AirlineGroupName"); ViewData["RoleAssign"] = new SelectList("", "RoleName", "RoleName", ""); ViewData["AgentTypes"] = new SelectList(_rep.GetAgentType(), "AgentTypeId", "AgentTypeName"); ViewData["AgentZone"] = new SelectList(_rep.GetZoneList(), "ZoneId", "ZoneName"); ViewData["AgentDistrict"] = new SelectList(_rep.GetDistrictListbyZoneId(1), "DistrictId", "DistrictName"); ViewData["Banks"] = new SelectList(_rep.GetbankInformation(), "BankId", "BankName"); ViewData["BankBranches"] = new SelectList(_rep.GetbankBranchInformation(), "BankBranchId", "BranchName"); ViewData["BankAccountTypes"] = new SelectList(_rep.GetbankAccountType(), "BankAccountTypeId", "AccountTypeName"); ViewData["TimeZones"] = new SelectList(_rep.GetTimeZoneList(), "RecordID", "StandardName", 66); return(View("Create", viewmodel)); } } } }