public Dictionary<ProjectActionType, bool> GetDefaultProjectPermissions(EmployeeRole employeeRole) { switch (employeeRole) { case EmployeeRole.ProjectManager: return new Dictionary<ProjectActionType, bool> { { ProjectActionType.ViewProject, true}, { ProjectActionType.ViewTasks, true}, { ProjectActionType.ModifyTasks, true}, { ProjectActionType.ViewEmployees, true}, { ProjectActionType.ModifyEmployees, true}, { ProjectActionType.ViewTimeReports, true}, { ProjectActionType.ViewBilling, true}, { ProjectActionType.ViewStatistics, true}, { ProjectActionType.Export, true} }; case EmployeeRole.Leader: return new Dictionary<ProjectActionType, bool> { { ProjectActionType.ViewProject, true}, { ProjectActionType.ViewTasks, true}, { ProjectActionType.ModifyTasks, true}, { ProjectActionType.ViewEmployees, true}, { ProjectActionType.ModifyEmployees, true}, { ProjectActionType.ViewTimeReports, true}, { ProjectActionType.ViewBilling, true}, { ProjectActionType.ViewStatistics, true}, { ProjectActionType.Export, true} }; case EmployeeRole.Developer: return new Dictionary<ProjectActionType, bool> { { ProjectActionType.ViewProject, true}, { ProjectActionType.ViewTasks, true}, { ProjectActionType.ModifyTasks, true}, { ProjectActionType.ViewEmployees, true}, { ProjectActionType.ModifyEmployees, true}, { ProjectActionType.ViewBilling, true}, { ProjectActionType.ViewTimeReports, true}, { ProjectActionType.ViewStatistics, true}, { ProjectActionType.Export, true} }; case EmployeeRole.Tester: return new Dictionary<ProjectActionType, bool> { { ProjectActionType.ViewProject, true}, { ProjectActionType.ViewTasks, true}, { ProjectActionType.ModifyTasks, true}, { ProjectActionType.ViewEmployees, true}, { ProjectActionType.ModifyEmployees, true}, { ProjectActionType.ViewBilling, true}, { ProjectActionType.ViewTimeReports, true}, { ProjectActionType.ViewStatistics, true}, { ProjectActionType.Export, true} }; default: return new Dictionary<ProjectActionType, bool>(); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EmployeeRole model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into employeerole("); strSql.Append("ID,EMPLOYEEID,ROLEID)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEEID,@ROLEID)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@ROLEID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEEID; parameters[2].Value = model.ROLEID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName.ToLower()) { case "remove": { EmployeeRole.DeleteEmployeeRoleByEmployeeRoleId(Convert.ToInt32(e.CommandArgument)); BindEmployeeRoleList(); BindEmployeeRole(); break; } } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } }
public void Add(EmployeeCreateModel employeeModel, string email) { EmployeeRole role = _context.EmployeeRole.FirstOrDefault(r => r.Owner == email && r.Id == employeeModel.RoleId); if (role == null) { throw new Exception("No permission!!!"); } Employee checkId = _context.Employee.FirstOrDefault(e => e.EmployeeCompanyId == employeeModel.EmployeeCompanyId && e.Owner == email); if (checkId != null) { throw new Exception("Id Exist!!!"); } Employee employee = new Employee() { EmployeeCompanyId = employeeModel.EmployeeCompanyId, FullName = employeeModel.FullName, RoleId = employeeModel.RoleId, Owner = email, Manpower = employeeModel.Manpower, Active = true }; _context.Add(employee); _context.SaveChanges(); }
private void Submit(object sender, RoutedEventArgs e) { #region string fName = tbxFirstName.Text; string lName = tbxLastName.Text; string uName = tbxUsername.Text; string password = tbxPassword.Text; string phone = tbxPhoneNumber.Text; string address = tbxAddress.Text; string email = tbxEmailAddress.Text; EmployeeRole role = CheckRole(); #endregion if (ViewModel.ValidateInput(fName, lName, uName, password, phone, address, email)) { if (ViewModel.CreateNewEmployee(fName, lName, uName, password, phone, address, email, role)) { MessageBox.Show("User Created"); GoToPreviousWindow(); } else { MessageBox.Show("Could not add employee successfully, try with diffreren username"); } } ShowErrorMessages(); }
private void BindEmployeeRole() { DropDownListEmployeeRole.Items.Clear(); string[] roleList = Roles.GetAllRoles(); foreach (string role in roleList) { DropDownListEmployeeRole.Items.Add(new ListItem(role, role)); } ListItem listItem = new ListItem("", "0"); DropDownListEmployeeRole.Items.Add(listItem); List <EmployeeRole> employeeRole = EmployeeRole.GetEmployeeRoleListByEmployeeId(this.employeeId); foreach (EmployeeRole employeeRoleItem in employeeRole) { DropDownListEmployeeRole.Items.Remove(DropDownListEmployeeRole.Items.FindByValue(employeeRoleItem.Description)); } if (DropDownListEmployeeRole.Items.FindByValue("Representative") != null) { DropDownListEmployeeRole.Items.FindByValue("Representative").Selected = true; } else { DropDownListEmployeeRole.Items.FindByValue("0").Selected = true; } DropDownListEmployeeRole.Items.Remove("Administrator"); }
public async Task <IActionResult> Edit(int id, [Bind("EmployeeId,PatientTypeId")] EmployeeRole employeeRole) { if (id != employeeRole.EmployeeId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(employeeRole); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmployeeRoleExists(employeeRole.EmployeeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["EmployeeId"] = new SelectList(_context.Employees, "EmployeeId", "EmployeeId", employeeRole.EmployeeId); ViewData["PatientTypeId"] = new SelectList(_context.PatientTypes, "PatientTypeId", "PatientTypeId", employeeRole.PatientTypeId); return(View(employeeRole)); }
/// <summary> /// /// </summary> /// <param name="fromDate"></param> /// <param name="toDate"></param> /// <returns></returns> public ActionResult AddEmployee() { IQueryable <Location> Loc = this.db.Locations; List <SelectListItem> Location = new List <SelectListItem>(); Location = (from dropdownfill in Loc.AsEnumerable().OrderBy(x => x.Name) select new SelectListItem // data() { Value = dropdownfill.Id.ToString(), Text = dropdownfill.Name }).ToList(); ViewBag.LocationList = Location; IQueryable <Role> roles = this.db.Roles; List <SelectListItem> emprole = new List <SelectListItem>(); emprole = (from dropdownfill in roles.AsEnumerable().OrderBy(x => x.Name) select new SelectListItem // data() { Value = dropdownfill.Id.ToString(), Text = dropdownfill.Name }).ToList(); ViewBag.RoleList = emprole; Employee AddEmp = new Employee(); EmployeeRole emproles = new EmployeeRole(); return(PartialView("_PVAddEmployee", AddEmp)); }
private bool RoleHasCorrectPermissions(EmployeeRole role, ApiAuthRequirement requirements) { if (requirements.AdministerCompany && !role.CanAdministerCompany) { return false; } if (requirements.AdministerVenue && !role.CanAdministerVenue) { return false; } if (requirements.WorkWithCompany && !role.CanWorkWithCompany) { return false; } if (requirements.WorkWithVenue && !role.CanWorkWithVenue) { return false; } if (requirements.AdministerSystem && !role.CanAdministerSystem) { return false; } return true; }
public IHttpActionResult PutEmployeeRole(int id, EmployeeRole employeeRole) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employeeRole.RoldeId) { return(BadRequest()); } db.Entry(employeeRole).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeRoleExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// 新增員工身分資料 /// </summary> public bool InsertEmployeeRoleData(RoleParams param) { InsertResult insResult = new InsertResult() { IsSuccess = false }; using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess()) { EmployeeRole entity = new EmployeeRole() { RoleName = param.RoleName, RoleDisplayName = param.RoleDisplayName, SortNo = param.SortNo, PostAccount = param.PostAccount, PostDate = DateTime.Now }; insResult = empAuthDao.InsertEmployeeRoleData(entity, param.CopyPrivilegeFromRoleName); dbErrMsg = empAuthDao.GetErrMsg(); if (insResult.IsSuccess) { param.RoleId = entity.RoleId; } else if (empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2) { param.HasRoleBeenUsed = true; } } return(insResult.IsSuccess); }
public void DeleteEmployeeRole(int EmpID, int RoleID) { try { EmployeeRole employeerole = new EmployeeRole() { EmpID=EmpID, RoleID= RoleID}; context.EmployeeRoles.DeleteObject(employeerole); context.SaveChanges(); } catch (Exception ex) { //Include catch blocks for specific exceptions first, //and handle or log the error as appropriate in each. //Include a generic catch block like this one last. throw ex; } }
public Dictionary<ProjectActionType, bool> GetDefaultProjectPermissions(EmployeeRole employeeRole) { return new Dictionary<ProjectActionType, bool> { {ProjectActionType.ViewProject, true}, {ProjectActionType.ViewTasks, true}, {ProjectActionType.ModifyTasks, true}, {ProjectActionType.ViewEmployees, true}, {ProjectActionType.ModifyEmployees, true}, {ProjectActionType.ViewBilling, true}, {ProjectActionType.ViewStatistics, true}, {ProjectActionType.Export, true}, {ProjectActionType.ViewTimeReports, true}, }; }
/// <summary> /// Constructor /// </summary> /// <param name="employeesTabViewModel">Employess tab view model</param> /// <param name="employeeEditWindow">Employee edit window</param> /// <param name="employee">Employee</param> public EmployeeEditWindowViewModel(EmployeesTabViewModel employeesTabViewModel, EmployeeEditWindow employeeEditWindow, Employee employee) : base(employeesTabViewModel, employeeEditWindow, employee) { if (Update) { EditUser = false; if (employee is Administrator) { Employee = new Administrator { OwnerID = employee.OwnerID, Name = employee.Name, Surname = employee.Surname, PESEL = employee.PESEL, Telephone = employee.Telephone, City = employee.City, Street = employee.Street, HouseNumber = employee.HouseNumber, LocalNumber = employee.LocalNumber, BankAccountNumber = employee.BankAccountNumber, Salary = employee.Salary, Username = employee.Username }; EmployeeRole = EmployeeRole.Administrator; _orginalRole = EmployeeRole.Administrator; } else if (employee is Menager) { Employee = new Menager { OwnerID = employee.OwnerID, Name = employee.Name, Surname = employee.Surname, PESEL = employee.PESEL, Telephone = employee.Telephone, City = employee.City, Street = employee.Street, HouseNumber = employee.HouseNumber, LocalNumber = employee.LocalNumber, BankAccountNumber = employee.BankAccountNumber, Salary = employee.Salary, Username = employee.Username }; EmployeeRole = EmployeeRole.Menager; _orginalRole = EmployeeRole.Menager; } else if (employee is Dispatcher) { Employee = new Dispatcher { OwnerID = employee.OwnerID, Name = employee.Name, Surname = employee.Surname, PESEL = employee.PESEL, Telephone = employee.Telephone, City = employee.City, Street = employee.Street, HouseNumber = employee.HouseNumber, LocalNumber = employee.LocalNumber, BankAccountNumber = employee.BankAccountNumber, Salary = employee.Salary, Username = employee.Username }; EmployeeRole = EmployeeRole.Dispatcher; _orginalRole = EmployeeRole.Dispatcher; } else { Employee = new Employee { OwnerID = employee.OwnerID, Name = employee.Name, Surname = employee.Surname, PESEL = employee.PESEL, Telephone = employee.Telephone, City = employee.City, Street = employee.Street, HouseNumber = employee.HouseNumber, LocalNumber = employee.LocalNumber, BankAccountNumber = employee.BankAccountNumber, Salary = employee.Salary, Username = employee.Username }; EmployeeRole = EmployeeRole.Other; _orginalRole = EmployeeRole.Other; } } else { EditUser = true; Employee = new Employee(); } using (var con = new BaudiDbContext()) { _currentUserNames = Update ? con.Employees.Where(e => e.OwnerID != employee.OwnerID).Select(e => e.Username).ToList() : con.Employees.Select(e => e.Username).ToList(); } }
public void InsertEmployeeRole(EmployeeRole employeerole) { try { context.EmployeeRoles.AddObject(employeerole); context.SaveChanges(); } catch (Exception ex) { //Include catch blocks for specific exceptions first, //and handle or log the error as appropriate in each. //Include a generic catch block like this one last. throw ex; } }