public ActionResult Index(BusPNRModel model, int?page, ExportModel Expmodel, FormCollection frm)
{
Session["FromDate"] = model.FromDate;
Session["ToDate"] = model.ToDate;
BusPNRModel _model = new BusPNRModel();
UnIssuedTicketRepository _rep = new UnIssuedTicketRepository();
BusGeneralRepository.SetRequestPageRow();
try
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorAgentList(ts.LoginTypeId), "AgentId", "AgentName");
_model.TabularList = _rep.GetDistributorPagedIssueList(page, model.FromDate, model.ToDate, model.AgentId, ts.LoginTypeId);
}
catch (Exception ex)
{
_model.Message = BusGeneralRepository.CatchException(ex);
}
//export
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = _model.TabularList.Select(m => new
{
Passenger_Name = m.FullName,
Operator_Name = m.BusMasterName,
DepartureDate = TimeFormat.DateFormat(m.DepartureDate.ToString()),
DepartureTime = TimeFormat.GetAMPMTimeFormat(m.DepartureTime.ToString()),
Category = m.BusCategoryName,
Type = m.Type
});
App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket");
}
catch
{
}
}
_model.Message = _res;
return(View(_model));
}
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag, int?page)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
int currentPageIndex = page.HasValue ? page.Value : 1;
int defaultPageSize = 50;
//export
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
model.AgentCLApprovedListExport = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId);
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.AgentCLApprovedListExport.Select(m => new
{
BranchOffice_Name = m.BranchOfficeName,
Distributor_Name = m.DistributorName,
Agent_Name = m.AgentName,
Agent_Code = m.AgentCode,
Currency = m.Currency,
Amount = m.Amount,
Narration = m.Comments,
VoucherNo = m.VoucherNo,
CreatedBy = m.CheckedBy,
CreatedDate = m.CheckerDate
});
App_Class.AppCollection.Export(Expmodel, exportData, "Agent Receipts");
}
catch
{
}
}
model.AgentReceiptList = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId).ToPagedList(currentPageIndex, defaultPageSize);
model.UsersOption = new SelectList(defaultProvider.GetUserList(), "AppUserId", "FullName");
model.BranchOfficeOption = new SelectList(branchOfficeManagementProvider.GetAll(), "BranchOfficeId", "BranchOfficeName", model.BranchOfficeId);
model.DistributorOption = new SelectList(agentclaapprovedprovider.GetAllDistributorsByBranchOfficeId(model.BranchOfficeId ?? 0), "DistributorId", "DistributorName");
model.AgentOption = new SelectList(agentclaapprovedprovider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId);
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
if (ts.UserTypeId == 6)
{
model.DistributorID = ts.LoginTypeId;
}
model.AgentCLApprovedListExport = agentCLApprovedProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId);
//export
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.AgentCLApprovedListExport.Select(m => new
{
Brach_Office = m.BranchOfficeName,
Distributor = m.DistributorName,
Agent_Name = m.AgentName,
Agent_Code = m.AgentCode,
Currency = m.Currency,
Amount = m.Amount,
Type = m.Type,
Requestion = m.Requestion,
Checker_Date = m.CheckerDate,
CheckerBy = m.CheckedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket");
}
catch
{
}
}
model.UsersOption = new SelectList(agentCLApprovedProvider.GetDistributorUsers(model.DistributorID), "AppUserId", "FullName");
model.AgentOption = new SelectList(agentCLApprovedProvider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId);
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
model.AgentCLApprovedListExport = agentCLApprovedProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId);
//export
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.AgentCLApprovedListExport.Select(m => new
{
Brach_Office = m.BranchOfficeName,
Distributor = m.DistributorName,
Agent_Name = m.AgentName,
Agent_Code = m.AgentCode,
Currency = m.Currency,
Amount = m.Amount,
Type = m.Type,
Requestion = m.Requestion,
Checker_Date = m.CheckerDate,
CheckerBy = m.CheckedBy,
Comments = m.Comments,
Effective_From = m.EffectiveFrom,
ExpireOn = m.ExpireOn
});
App_Class.AppCollection.Export(Expmodel, exportData, "Agent Credit Limit");
}
catch
{
}
}
model.UsersOption = new SelectList(defaultProvider.GetUserList(), "AppUserId", "FullName");
model.BranchOfficeOption = new SelectList(branchOfficeManagementProvider.GetAll(), "BranchOfficeId", "BranchOfficeName", model.BranchOfficeId);
model.DistributorOption = new SelectList(agentCLApprovedProvider.GetAllDistributorsByBranchOfficeId(model.BranchOfficeId ?? 0), "DistributorId", "DistributorName");
model.AgentOption = new SelectList(agentCLApprovedProvider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId);
return(View(model));
}
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, LedgerTransactionSummaryModel model, FormCollection frm)
{
model.LedgerTransactionList = ledgerTransactionSummaryProvider.GetSummeryOfLedgerTransactionList(model.ProductId, model.CurrencyId, model.LedgerOf, model.DateFrom, model.DateTo, model.FilterType, model.FilterValue);
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
int counter = 1;
var exportData = model.LedgerTransactionList.Select(m => new
{
SN = counter++,
Ledger_Id = m.LedgerId,
Ledger_Name = m.LedgerName,
Opening_Balance = m.OpeningBalance,
Dr = m.Dr,
Cr = m.Cr,
Closing_Balance = m.ClosingBalance
});
App_Class.AppCollection.Export(Expmodel, exportData, "Ledger Transaction");
}
catch
{
}
}
model.ProductsOption = ledgerTransactionSummaryProvider.GetProductOption();
model.CurrencyOption = ledgerTransactionSummaryProvider.GetCurrencyOption();
model.LedgerOfOption = ledgerTransactionSummaryProvider.GetLedgerOfOption();
model.FilterTypeOption = ledgerTransactionSummaryProvider.GerFilterTypeoption();
return(View(model));
}
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, SalesReportModel model, FormCollection frm)
{
model.InformationList = salesReportProvider.GetInformation(model.ReportOf, model.CurrencyId, model.FromDate, model.ToDate);
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.InformationList.Select(m => new
{
Name = m.Name,
Airline = m.Airline,
Hotel = m.Hotel,
Mobile = m.Mobile,
Bus = m.Bus,
Train = m.Train,
Total = m.Total
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
catch
{
}
}
model.ReportsOfOption = salesReportProvider.GetReportof();
model.CurrencyOption = salesReportProvider.Getcurrencylist();
return(View(model));
}
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, DateTime FromDate, DateTime ToDate, FormCollection frm)
{
TicketStatusHistoryModel model = new TicketStatusHistoryModel();
BookedTicketReportController crtBKT = new BookedTicketReportController();
model.TicketStatusHistoryList = TicketStatusHistoryRepository.GetTicketStatusHistory(FromDate, ToDate);
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.TicketStatusHistoryList.Select(m => new
{
Branch = m.Branch,
Distributor = m.Distributor,
Agent = m.Agent,
Airline = m.Airline,
Sector = m.Sector,
Status = m.Status,
ServiceProvider = m.ServiceProviderName
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
catch
{
}
}
return(View(model));
}
public ActionResult Details(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, SalesReportModel model, FormCollection frm)
{
model.ReportHeading = model.Name;
model.InformationList = salesReportProvider.GetLedgerInformation(model.LedgerId, model.ReportOf, model.CurrencyId, model.FromDate, model.ToDate, model.ReportType);
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
int counter = 0;
if (model.ReportType == 1)
{
var exportData = model.InformationList.Select(m => new
{
SN = ++counter,
Airline = m.AirlineName,
MPNRID = m.MpnrId,
ServiceProvider_Name = m.ServiceProviderName,
Sector = m.Sector,
Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()),
Issued_From = m.IssuedFrom,
Ticket_Number = m.TicketNumber,
Amount = m.Amount
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
if (model.ReportType == 2)
{
var exportData = model.InformationList.Select(m => new
{
SN = ++counter,
Hotel_Name = m.HotelName,
Country_Name = m.CountryName,
City_Name = m.CityName,
ServiceProvider_Name = m.ServiceProviderName,
Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()),
No_Of_Night = m.NOofNight,
No_Of_Room = m.NoofRoom,
Amount = m.Amount
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
if (model.ReportType == 3)
{
var exportData = model.InformationList.Select(m => new
{
SN = ++counter,
SalesTranId = m.SalesTranId,
ServiceType = m.ServiceType,
Customer_MobileNo = m.CustomerMobileNo,
ServiceProvider_Name = m.ServiceProviderName,
Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()),
Created_Date = m.CreatedDate,
Amount = m.Amount
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
if (model.ReportType == 4)
{
var exportData = model.InformationList.Select(m => new
{
SN = ++counter,
BusMasterName = m.BusMasterName,
BusPNRId = m.BusPNRId,
ServiceProvider_Name = m.ServiceProviderName,
Passenger_Name = m.PassengerName,
Sector = m.Sector,
Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()),
Amount = m.Amount
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
if (model.ReportType == 5)
{
var exportData = model.InformationList.Select(m => new
{
SN = ++counter,
Passenger_Name = m.PassengerName,
TrainNo = m.TrainNo,
Sector = m.Sector,
Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()),
TrainPNRId = m.TrainPNRId,
Amount = m.Amount
});
App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report");
}
}
catch
{
}
}
return(View(model));
}
