public List <SalesReportModel> GetSalesReportSummaryDetails(int?AgentId, DateTime?fromdate, DateTime?todate, int AirlinesTypeId, int?currencyId) { ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagementProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider(); List <Air_GetAgentBillingStatementDetails_Result> data = ent.Air_GetAgentBillingStatementDetails(AgentId, fromdate, todate, currencyId).ToList(); var ts = SessionStore.GetTravelSession(); var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(ts.AppUserId); var resultSummary = agentsByDistributor.SelectMany(b => data.Where(x => x.AgentId == b.AgentId)); List <SalesReportModel> model = new List <SalesReportModel>(); foreach (var item in resultSummary) { 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; SalesReportModel.AgentCode = new ATLTravelPortal.Areas.Airline.Repository.BookedTicketReportProvider().GetAgentCodeById(item.AgentId); model.Add(SalesReportModel); } return(model); }
public List <SalesReportModel> GetDistributorSalesReportSummary(int?AgentId, DateTime?fromdate, DateTime?todate, int AirlinesTypeId, int?currencyId) { ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagementProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider(); ATLTravelPortal.Areas.Administrator.Repository.BranchOfficeManagementProvider branchOfficeManagementProvider = new ATLTravelPortal.Areas.Administrator.Repository.BranchOfficeManagementProvider(); List <Air_GetAgentBillingStatement_Result> data = ent.Air_GetAgentBillingStatement(null, fromdate, todate, currencyId).ToList(); var ts = SessionStore.GetTravelSession(); var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId); List <Air_GetAgentBillingStatement_Result> result = new List <Air_GetAgentBillingStatement_Result>(); if (AgentId != null) { int appUserId = branchOfficeManagementProvider.GetAppUserIdByDistributorId(AgentId.Value); var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(appUserId); result = agentsByDistributor.SelectMany(b => data.Where(x => x.Agentid == b.AgentId)).ToList(); } else { result = agentsByBranchOffice.SelectMany(b => data.Where(x => x.Agentid == b.AgentId)).ToList(); } List <SalesReportModel> model = new List <SalesReportModel>(); foreach (var item in result) { var SalesReportModel = new SalesReportModel(); SalesReportModel.AirlineId = item.AirlineId; SalesReportModel.AirlineCode = item.Code; SalesReportModel.AirlineName = item.Name; SalesReportModel.Cash = item.Cash; TotalAgentBillingStatement_Cash = TotalAgentBillingStatement_Cash + (Decimal)item.Cash; SalesReportModel.SumAgentBillingStatement_Cash = TotalAgentBillingStatement_Cash; SalesReportModel.Tax = (decimal)item.Tax; TotalAgentBillingStatement_Tax = TotalAgentBillingStatement_Tax + (decimal)item.Tax; SalesReportModel.SumAgentBillingStatement_Tax = TotalAgentBillingStatement_Tax; SalesReportModel.Commission = (decimal)item.Commission; TotalAgentBillingStatement_Commission = TotalAgentBillingStatement_Commission + (decimal)item.Commission; SalesReportModel.SumAgentBillingStatement_Commission = TotalAgentBillingStatement_Commission; SalesReportModel.Payable = (decimal)item.Payable; TotalAgentBillingStatement_Payable = TotalAgentBillingStatement_Payable + (decimal)item.Payable; SalesReportModel.SumAgentBillingStatement_Payable = TotalAgentBillingStatement_Payable; SalesReportModel.AgentId = item.Agentid; model.Add(SalesReportModel); } return(model); }