public ActionResult Index(ExportModel Expmodel, BookedTicketModels model, FormCollection frm, int?pageNo, int?flag)
{
var ts = SessionStore.GetTravelSession();
var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId);
ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagentProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider();
var details = ser.ListBookedReport(null, model.FromDate, model.ToDate);
if (model.AgentId != null)
{
//int appUserId = branchOfficeManagementProvider.GetAppUserIdByDistributorId(model.AgentId.Value);
//var agentsByDistributor = distributorManagentProvider.GetAllAgentsByDistributorId(appUserId);
//var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.BookedTicketList = result;
var result = details.Where(x => x.DistributorId == model.AgentId);
model.BookedTicketList = result;
}
else
{
//var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.BookedTicketList = result;
var result = details.Where(x => x.BranchOfficeId == ts.LoginTypeId);
model.BookedTicketList = result;
}
//export
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.BookedTicketList.Select(m => new
{
Agent_Name = m.AgentName,
GDSReferenceNumber = m.GDSRefrenceNumber,
PassengerName = m.PassengerName,
Sector = m.Sector,
Flight_Date = m.FlightDate,
BookedOn = m.BookedOn,
BookedBy = m.BookedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "Booked Ticket");
}
catch
{
}
}
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName");
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, PendingBookingModel model, FormCollection frm, int?page)
{
var ts = SessionStore.GetTravelSession();
int defaultPageSize = 30;
int currentPageIndex = page.HasValue ? page.Value : 1;
var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId);
ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagentProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider();
var details = ser.ListPendingBookintReport(null, model.FromDate, model.ToDate);
if (model.AgentId != null)
{
//int appUserId = branchOfficeManagementProvider.GetAppUserIdByDistributorId(model.AgentId.Value);
//var agentsByDistributor = distributorManagentProvider.GetAllAgentsByDistributorId(appUserId);
//var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize);
var result = details.Where(x => x.DistributorId == model.AgentId);
model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize);
}
else
{
//var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize);
var result = details.Where(x => x.BrachOfficeId == ts.LoginTypeId);
model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize);
}
//export
bkt.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.PendingBookingList.Select(m => new
{
Agent = m.AgentName,
Passenger_Name = m.PassegerName,
Sector = m.Sector,
GDS_PNR = m.GDSReferenceNumber,
Flight_Date = m.FlightDate,
Booked_On = TimeFormat.DateFormat(m.BookedOn.ToString()),
Booked_by = m.BookedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "PendingBooking ");
}
catch (Exception ex)
{
ATLTravelPortal.Utility.ErrorLogging.LogException(ex);
TempData["ActionResponse"] = ex.Message;
}
}
ViewData["Agents"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName");
return(View(model));
}
