public ActionResult TotalSummary(DateTime id, DateTime text, string value)
{
//Get the selected user information
string[] names = value.Split(',');
User user = _UsageRepos.GetUserIDByName(names[0], names[1]);
int[] newList = _ReportRepository.GetTotalValue(id, text, user.UserId);
SAPSReportViewModel vm = new SAPSReportViewModel();
vm.TotalAppointments = newList[0];
vm.TotalAccounts = newList[1];
vm.TotalCalls = newList[2];
vm.TotalCloses = newList[3];
vm.TotalGoodAppointments = newList[4];
//To check if denominator is not zero
if (vm.TotalAppointments != 0)
{
vm.AppointmentRatio = (((double)vm.TotalGoodAppointments / (double)vm.TotalAppointments) * (double)100);
}
else
{
vm.AppointmentRatio = 0;
}
//To check if denominator is not zero
if (vm.TotalGoodAppointments != 0)
{
vm.CloseRatio = ((double)vm.TotalCloses / (double)vm.TotalGoodAppointments) * (double)100;
}
return(PartialView(vm));
}
public ActionResult Index()
{
SAPSReportViewModel vm = new SAPSReportViewModel();
#region Appointments Summary:
IList <Data.Domain.AppointmentSheet> appointments = new List <Data.Domain.AppointmentSheet>();
// for getting username
var username = HttpContext.User.Identity.Name;
vm.user = _UserRepository.GetUserByUsername(username);
vm.i = 0;
// For SAusers drop down
var saUsersResult = _UserRepository.GetAllUsersByRole(3);
vm.SAUsersDropdown = saUsersResult.Select(row => new SelectListItem()
{
Text = row.LastName + "," + row.FirstName,
Value = row.LastName + "," + row.FirstName
});
// Get the number of appointments
var results = _AppointmentRepository.AppointmentSheets;
foreach (var result in results)
{
var assignedsaagentid = result.AssignedSalesAgent;
//to get the hidden appointment agent field in datatable
User newUser = _UserRepository.GetUserById(assignedsaagentid);
if (newUser == null)
{
result.AssignedUser.UserName = "******";
}
else
{
result.AssignedUser = newUser;
}
// To get the number of accounts for this person
result.Accounts = GetNumberOfAccounts(result.ParentLeadId);
if (result.Accounts == 0)
{
result.Closed = "No";
}
else
{
result.Closed = "Yes";
}
result.companyname = _LeadRepository.LeadByLeadID(result.ParentLeadId).CompanyName;
appointments.Add(result);
vm.Appointments = appointments;
}
#endregion
return(View(vm));
}
