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