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)); }