public RegistrationViewDetailsModel GetAdminDetailsByRegistrationID(int?RegistrationID) { using (var _context = new DatabaseContext()) { string RoleCode = "Manager"; var queryResult = (from registration in _context.Registration join role in _context.Role on registration.RoleID equals role.RoleID where registration.RegistrationID == RegistrationID && role.RoleCode == RoleCode select registration).FirstOrDefault(); if (queryResult != null) { var objRegistrationViewDetailsModel = new RegistrationViewDetailsModel() { Birthdate = Convert.ToString(queryResult.Birthdate), DateofLeaving = Convert.ToString(queryResult.DateofLeaving), DateofJoining = Convert.ToString(queryResult.DateofLeaving), EmailID = queryResult.EmailID, EmployeeID = queryResult.EmployeeID, Gender = queryResult.Gender, IsActive = Convert.ToBoolean(queryResult.IsActive), Mobileno = queryResult.Mobileno, FullName = TimeSheetHelper.GetFullName(queryResult.FirstName, queryResult.MiddleName, queryResult.LastName), RegistrationID = queryResult.RegistrationID, RoleID = Convert.ToInt32(queryResult.RoleID), Username = queryResult.Username }; return(objRegistrationViewDetailsModel); } return(new RegistrationViewDetailsModel()); } }
public List <TimeSheetOverviewModel> GetTimeSheetModels() { try { var helper = new TimeSheetHelper(this); return(helper.BuildTimeSheetOverViewModel(this.GetUserId())); } catch (Exception ex) { _logger.LogError(ex.Message); return(null); } }
public string GetUsernamebyRegistrationID(int RegistrationID) { using (DatabaseContext _context = new DatabaseContext()) { var employee = (from registration in _context.Registration where registration.RegistrationID == RegistrationID select registration).FirstOrDefault(); if (employee != null) { return(TimeSheetHelper.GetFullName(employee.FirstName, employee.MiddleName, employee.LastName)); } else { return(""); } } }
public IActionResult ManageTimeSheet(string successMsg, string errorMsg) { var departmentService = this.GetService <DepartmentService>(); this.BuildHeaderMsg(successMsg, errorMsg); var userIds = departmentService.GetSubordinatesByUserId(this.GetUserId()); //去掉Admin var adminIds = this.GetService <UserService>().Get().Where(o => o.UserType == UserType.Admin).Select(o => o.Id).ToList(); userIds = userIds.Except(adminIds).ToList(); var helper = new TimeSheetHelper(this); ViewData["UserWeeks"] = helper.BuildUserTimeSheetOverViewModels(userIds); return(View()); }
public Dictionary <string, List <TimeSheetOverviewModel> > GetManageTimeSheetModel() { try { //var helper = new TimeSheetHelper(this); //return helper.BuildTimeSheetOverViewModel(this.GetUserId()); var userIds = this.GetService <DepartmentService>().GetSubordinatesByUserId(this.GetUserId()); var adminIds = this.GetService <UserService>().Get().Where(o => o.UserType == UserType.Admin).Select(o => o.Id).ToList(); var internalIds = this.GetService <UserService>().Get().Where(o => o.AccountType == AccountType.Internal).Select(o => o.Id).ToList(); userIds = userIds.Except(adminIds).Except(internalIds).ToList(); var helper = new TimeSheetHelper(this); return(helper.BuildUserTimeSheetOverViewModels(userIds)); } catch (Exception ex) { _logger.LogError(ex.Message); return(null); } }
// // GET: /Payroll/TimeSheet/ public ActionResult GetTimeSheets(string c, string co) { var model = TimeSheetHelper.Search(c, co); return(Json(model, JsonRequestBehavior.AllowGet)); }