public ActionResult MonthlySummary(DateTime id, DateTime text, string value)
{
TicketReportViewModel vm = new TicketReportViewModel();
int TotalTicketsOpened = 0;
int TotalTicketsClosed = 0;
Report totalRecord = new Report();
string[] names = value.Split(',');
User user = _UsageRepos.GetUserIDByName(names[0], names[1]);
//int[] newList = _ReportRepository.GetTotalValue(id, text, user.UserId);
vm.MonthlyReports = _ReportRepository.GetMonthlyReport(id, text, user.UserId);
//To display the total of the report
foreach (var report in vm.MonthlyReports)
{
TotalTicketsOpened = TotalTicketsOpened + report.TicketsOpened;
TotalTicketsClosed = TotalTicketsClosed + report.TicketsClosed;
}
totalRecord.Month = "Total";
totalRecord.TicketsOpened = TotalTicketsOpened;
totalRecord.TicketsClosed = TotalTicketsClosed;
vm.TotalMonthlyReport = totalRecord;
return(PartialView(vm));
}
public ActionResult Index()
{
TicketReportViewModel tvm = new TicketReportViewModel();
var username = HttpContext.User.Identity.Name;
var user = _UserRepository.GetUserByUsername(username);
tvm.user = user;
tvm.Tickets = _ticketRepository.Tickets;
foreach (var ticket in tvm.Tickets)
{
if (ticket.Creator != 0)
{
ticket.CreaterBy = _UserRepository.GetUserById(ticket.Creator);
}
if (ticket.ClosedBy != 0)
{
ticket.ClosedByUser = _UserRepository.GetUserById(ticket.ClosedBy);
}
}
IEnumerable <User> SAUsers = new List <User>();
IEnumerable <User> CSRUsers = new List <User>();
IList <User> UsersResult = new List <User>();
SAUsers = _UserRepository.GetAllUsersByRole(3);
CSRUsers = _UserRepository.GetAllUsersByRole(5);
foreach (var usr in SAUsers)
{
UsersResult.Add(usr);
}
foreach (var usr in CSRUsers)
{
UsersResult.Add(usr);
}
tvm.UsersDropdown = UsersResult.Select(row => new SelectListItem()
{
Text = row.LastName + "," + row.FirstName,
Value = row.LastName + "," + row.FirstName
});
return(View(tvm));
}
