public ActionResult AuditorStat()
{
DateTime StartDate = DateTime.Parse("1/12/2016");
DateTime EndDate = DateTime.Parse("31/12/2016");
AuditorStatistics statistics = new AuditorStatistics(repository);
var auditorStatisticsResult = statistics.Get(StartDate, EndDate);
ViewBag.StartDate = StartDate.ToShortDateString();
ViewBag.EndDate = EndDate.ToShortDateString();
return(View(auditorStatisticsResult));
}
public JsonResult GetStatistics()
{
try
{
if (isAuditor)
{
var userName = _authService.LoggedInUserInfo().Result.LoggedInFullName;
DateTime startDateofYear = new DateTime(DateTime.Now.Year, 1, 1);
DateTime todayDate = DateTime.Now;
DateTime monthStartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
var yearToDateAuditCount = _auditToolContext.AuditMain.Where(x => x.AuditorName == userName && x.SubmitDt >= startDateofYear && x.SubmitDt <= todayDate && x.AuditorQuit != "Quit").Count();
var yearToDateDisputeCount = _auditToolContext.AuditDispute.Where(x => x.CreatedBy == userName && x.CreatedDate >= startDateofYear && x.CreatedDate <= todayDate).Count();
var monthToDateAuditCount = _auditToolContext.AuditMain.Where(x => x.AuditorName == userName && x.SubmitDt >= monthStartDate && x.SubmitDt <= todayDate && x.AuditorQuit != "Quit").Count();
var monthToDateDisputeCount = _auditToolContext.AuditDispute.Where(x => x.CreatedBy == userName && x.CreatedDate >= monthStartDate && x.CreatedDate <= todayDate).Count();
AuditorStatistics stats = new AuditorStatistics
{
YearToDate = string.Format("{0} / {1}", yearToDateAuditCount, yearToDateDisputeCount),
MonthToDate = string.Format("{0} / {1}", monthToDateAuditCount, monthToDateDisputeCount)
};
var auditList = _auditToolContext.AuditMain.Where(x => x.AuditorName == userName && x.AuditorQuit != "Quit").OrderByDescending(ord => ord.CreatedDate).Take(10).ToList();
List <RecentTicket> myTicketList = new List <RecentTicket>();
foreach (AuditMain item in auditList)
{
RecentTicket recentTicket = new RecentTicket
{
TicketCode = item.TicketId,
Agent34Id = item.Agent34Id,
AuditDate = item.SubmitDt.Value.ToString("yyyy-MM-dd HH:mm tt"),
Dispute = (bool)item.IsDisputed.Equals(true) ? "Yes" : "No"
};
var auditCompliantResponse = _auditToolContext.AuditMainResponse.Where(x => x.AuditMainId == item.Id && x.IsCompliant == true).Any();
var auditNonCompliantResponse = _auditToolContext.AuditMainResponse.Where(x => x.AuditMainId == item.Id && x.IsNonCompliant == true).Any();
if (auditNonCompliantResponse || auditCompliantResponse)
{
recentTicket.CompliantNonCompliant = auditNonCompliantResponse ? "Non Compliant" : "Compliant";
}
else
{
recentTicket.CompliantNonCompliant = "Not Applicable";
}
myTicketList.Add(recentTicket);
}
stats.RecentTicketLists = myTicketList;
return(Json(stats));
}
}
catch (Exception ex)
{
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "SearchController_GetStatistics", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
return(Json(new { Success = "False", responseText = "Authorization Error" }));
}
