public ActionResult Index(int?page)
{
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
AgentActivitiesModel model = new AgentActivitiesModel();
int currentPageIndex = page.HasValue ? page.Value : 1;
int defaultPageSize = 30;
model.AgentActivitesList = ser.GetAgentActivitiesList(model.AgentId, model.FromDate, model.ToDate).ToPagedList(currentPageIndex, defaultPageSize);
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, AgentActivitiesModel model, FormCollection frm, int?page)
{
int currentPageIndex = page.HasValue ? page.Value : 1;
int defaultPageSize = 30;
model.AgentActivitesList = ser.GetAgentActivitiesList(model.AgentId, model.FromDate, model.ToDate).ToPagedList(currentPageIndex, defaultPageSize);
//export
bktController.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.AgentActivitesList.Select(m => new
{
Agent_Name = m.AgentName,
Booked = m.Booked,
Cancelled = m.Cancelled,
Issued = m.Issued,
Void = m.Void,
Total_Login = m.TotalLogin,
Last_Login = m.LastLogin
});
App_Class.AppCollection.Export(Expmodel, exportData, "Agent Activity");
}
catch
{
}
}
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
return(View(model));
}
public List <AgentActivitiesModel> GetAgentActivitiesList(int?agentid, DateTime?fromdate, DateTime?todate)
{
var data = ent.Air_AgentActivities(agentid, fromdate, todate);
List <AgentActivitiesModel> model = new List <AgentActivitiesModel>();
foreach (var item in data.Select(x => x))
{
var AgentActivitiesModel = new AgentActivitiesModel();
AgentActivitiesModel.AgentName = item.AgentName;
AgentActivitiesModel.Booked = item.Booked;
TotalBooked = TotalBooked + (decimal)item.Booked;
AgentActivitiesModel.SumBooked = TotalBooked;
AgentActivitiesModel.Cancelled = item.Cancelled;
TotalCancelled = TotalCancelled + (decimal)item.Cancelled;
AgentActivitiesModel.SumCancelled = TotalCancelled;
AgentActivitiesModel.Issued = item.Issued;
TotalIssued = TotalIssued + (decimal)item.Issued;
AgentActivitiesModel.SumIssued = TotalIssued;
AgentActivitiesModel.Void = item.Void;
TotalVoid = TotalVoid + (decimal)item.Void;
AgentActivitiesModel.SumVoid = TotalVoid;
AgentActivitiesModel.TotalLogin = item.TotalLogin;
TotalLogin = TotalLogin + item.TotalLogin;
AgentActivitiesModel.SumTotalLogin = TotalLogin;
AgentActivitiesModel.GDSHits = item.GDSHits;
TotalGDSHits = TotalGDSHits + (decimal)item.GDSHits;
AgentActivitiesModel.SumTotalGDSHits = TotalGDSHits;
AgentActivitiesModel.LastLogin = item.LastLogin;
model.Add(AgentActivitiesModel);
}
return(model.ToList());
}
