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());
}
