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