public ActionResult Index()
{
var ts = SessionStore.GetTravelSession();
// var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.AgentId);
ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName");
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
CancelledVoidTicketModel model = new CancelledVoidTicketModel();
model.FromDate = DateTime.Now.AddDays(-15);
model.ToDate = DateTime.Now;
//var details = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, 1);
//var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.CancelledVoidTicketList = result;
var details = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, 1);
var result = details.Where(x => x.BranchOfficeId == ts.LoginTypeId);
model.CancelledVoidTicketList = result;
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, CancelledVoidTicketModel model, FormCollection frm, int?pageNo, int?flag)
{
if (model.FromDate != null)
{
model.FromDate = model.FromDate.Value.Date;
}
if (model.ToDate != null)
{
model.ToDate = model.ToDate.Value.Date.AddHours(23).AddMinutes(59);
}
model.CancelledVoidTicketList = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, 1);
//export
bktctrl.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.CancelledVoidTicketList.Select(m => new
{
Brach_Office = m.BranchOfficeName,
Distributor = m.DistributorName,
Agent_Name = m.AgentName,
GDS_PNR = m.GDSReferenceNumber,
Passenger_Name = m.PassengerName,
Sector = m.Sector,
Flight_Date = m.FlightDate,
Cancelled_On = m.CancelledOn
});
App_Class.AppCollection.Export(Expmodel, exportData, "CancelledVoid_Report");
}
catch
{
}
}
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, CancelledVoidTicketModel model, FormCollection frm, int?pageNo, int?flag)
{
var ts = SessionStore.GetTravelSession();
//var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(ts.AppUserId);
//var details = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId);
//var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
var details = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId);
var result = details.Where(x => x.DistributorId == ts.LoginTypeId);
model.CancelledVoidTicketList = result;
//export
bktctrl.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.CancelledVoidTicketList.Select(m => new
{
Agent_Name = m.AgentName,
GDS_PNR = m.GDSReferenceNumber,
Passenger_Name = m.PassengerName,
Sector = m.Sector,
Flight_Date = m.FlightDate,
Cancelled_On = m.CancelledOn
});
App_Class.AppCollection.Export(Expmodel, exportData, "CancelledVoid_Report");
}
catch
{
}
}
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
//var agents = defaultProvider.GetAgentList().Where(x => x.CreatedBy == ts.AppUserId);
var agents = defaultProvider.GetAgentList().Where(x => x.DistributorId == ts.LoginTypeId);
ViewData["AgentList"] = new SelectList(agents, "AgentId", "AgentName");
return(View(model));
}
public ActionResult Index()
{
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
CancelledVoidTicketModel model = new CancelledVoidTicketModel();
model.FromDate = DateTime.Now.AddDays(-15);
model.ToDate = DateTime.Now;
model.CancelledVoidTicketList = ser.ListCancelledVoidTicketReport(model.AgentId, model.FromDate, model.ToDate, 1);
return(View(model));
}
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());
}
