public List <EmployeeDepartmentViewModel> GetEmployeeDepartment() { SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("sPGetEmployeeDepartments", connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <EmployeeDepartmentViewModel> employeeDepartmentList = new List <EmployeeDepartmentViewModel>(); while (reader.Read()) { int employeeId = Convert.ToInt32(reader["EmployeeId"]); string employeeName = reader["EmployeeName"].ToString(); string Designation = reader["Designation"].ToString(); string NID = reader["NID"].ToString(); string BloodGroup = reader["BloodGroup"].ToString(); DateTime JoiningDate = Convert.ToDateTime(reader["JoiningDate"]); int DepartmentId = Convert.ToInt32(reader["Departmentid"]); string code = reader["Code"].ToString(); string departmentName = reader["DepartmentName"].ToString(); EmployeeDepartmentViewModel em = new EmployeeDepartmentViewModel(employeeId, employeeName, Designation, NID, JoiningDate, BloodGroup, DepartmentId, code, departmentName); employeeDepartmentList.Add(em); } reader.Close(); connection.Close(); return(employeeDepartmentList); }
public List <EmployeeDepartmentViewModel> GetEmployeeDepartmentViewModels() { List <EmployeeDepartmentViewModel> employeeDepartmentViewModelList = new List <EmployeeDepartmentViewModel>(); SqlConnection connection = new SqlConnection(conString); SqlCommand command = new SqlCommand("sPGetEmployeesWithDepartment", connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int employeeId = Convert.ToInt32(reader["EmployeeId"]); string name = reader["EmployeeName"].ToString(); string designation = reader["Designation"].ToString(); string nid = reader["NID"].ToString(); DateTime joiningDate = Convert.ToDateTime(reader["JoiningDate"]); string bloodGroup = reader["BloodGroup"].ToString(); int deptId = Convert.ToInt32(reader["DepartmentId"]); string deptName = reader["DepartmentName"].ToString(); string code = reader["Code"].ToString(); EmployeeDepartmentViewModel viewModel = new EmployeeDepartmentViewModel(employeeId, name, designation, nid, joiningDate, bloodGroup, deptId, deptName, code); employeeDepartmentViewModelList.Add(viewModel); } reader.Close(); connection.Close(); return(employeeDepartmentViewModelList); }
public async Task <IActionResult> AssignEmployeeDepartments([FromBody] EmployeeDepartmentViewModel vm) { var response = new ResposeViewModel(); try { foreach (var deptId in vm.DepartmentIds) { var ed = new DepartmentEmployeeModel() { DepartmentId = deptId, EmployeeId = vm.EmployeeId, AssignedDate = DateTime.UtcNow, IsActive = true }; _departmentContext.Add(ed); await _departmentContext.SaveChangesAsync(); } response.IsSuccess = true; } catch (Exception ex) { response.Message = ex.ToString(); } return(Ok(response)); }
public ActionResult Create(EmployeeDepartmentViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"INSERT INTO Employee ( FirstName, LastName, DepartmentId ) VALUES ( @firstName, @lastName, @departmentId )"; cmd.Parameters.Add(new SqlParameter("@firstName", viewModel.employee.FirstName)); cmd.Parameters.Add(new SqlParameter("@lastName", viewModel.employee.LastName)); cmd.Parameters.Add(new SqlParameter("@departmentId", viewModel.employee.DepartmentId)); cmd.ExecuteNonQuery(); return(RedirectToAction(nameof(Index))); } } } catch { return(View()); } }
public async Task <IActionResult> AddNewEmployee([FromBody] EmployeeViewModel emp) { if (emp == null) { return(BadRequest("EMployee cann't be null")); } if (emp.Departments == null || !emp.Departments.Any()) { return(BadRequest("Employee must assigned to at least one department")); } var newEmp = new EmployeeModel() { Email = emp.Email, FirstName = emp.FirstName, IsActive = emp.IsActive, LastName = emp.LastName }; newEmp = await _employeeService.CreateEmployee(newEmp); var empDeptVm = new EmployeeDepartmentViewModel() { EmployeeId = newEmp.Id, DepartmentIds = emp.Departments.Select(d => d.Id).ToList() }; var response = await _departmentService.AssignEmployeeDepartments(empDeptVm); emp.Id = newEmp.Id; return(Ok(emp)); }
public async Task <IActionResult> Details(int id) { var returnUrl = Request.Headers["Referer"].ToString(); var employeeDepartment = await _employeeDeparment.GetEmployeeDepartment(id); EmployeeDepartmentViewModel department = EmployeeDepartmentViewModelFactory.Details(employeeDepartment, returnUrl); return(View("Edit", department)); }
public async Task <IActionResult> Delete(EmployeeDepartmentViewModel employeeDepartmentVM) { await _employeeDeparment.DeleteEmployeeDepartment(employeeDepartmentVM.EmployeeDepartment); TempData["message"] = "Your data has been deleted successfully."; TempData["toasterType"] = ToasterType.success; //return RedirectToAction(nameof(Index)); return(Redirect(employeeDepartmentVM.ReturnUrl)); }
public async Task <ResposeViewModel> AssignEmployeeDepartments(EmployeeDepartmentViewModel vm) { var empoyeeeDepartment = new StringContent(JsonConvert.SerializeObject(vm), System.Text.Encoding.UTF8, "application/json"); var response = await _httpClient.PostAsync(_urls.Department + UrlsConfig.DepartmentOperations.AssignEmployeeDepartments(), empoyeeeDepartment); response.EnsureSuccessStatusCode(); var responseString = await response.Content.ReadAsStringAsync(); return(JsonConvert.DeserializeObject <ResposeViewModel>(responseString)); }
public async Task <IActionResult> Edit(int id, string returnUrl = null) { if (String.IsNullOrEmpty(returnUrl)) { returnUrl = Request.Headers["Referer"].ToString(); } var employeeDepartment = await _employeeDeparment.GetEmployeeDepartment(id); EmployeeDepartmentViewModel deparment = EmployeeDepartmentViewModelFactory.Edit(employeeDepartment, returnUrl); return(View("Edit", deparment)); }
// GET: Employees/Create public ActionResult Create() { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { // Select all the cohorts cmd.CommandText = @"SELECT Department.Id, Department.Name FROM Department"; SqlDataReader reader = cmd.ExecuteReader(); // Create a new instance of our view model EmployeeDepartmentViewModel viewModel = new EmployeeDepartmentViewModel(); while (reader.Read()) { // Map the raw data to our cohort model Department department = new Department { Id = reader.GetInt32(reader.GetOrdinal("Id")), Name = reader.GetString(reader.GetOrdinal("Name")) }; // Use the info to build our SelectListItem SelectListItem departmentOptionTag = new SelectListItem() { Text = department.Name, Value = department.Id.ToString() }; // Add the select list item to our list of dropdown options viewModel.departments.Add(departmentOptionTag); } reader.Close(); // send it all to the view return(View(viewModel)); } } }
public async Task <IActionResult> Edit([FromForm] EmployeeDepartmentViewModel employeeDepartmentVM) { if (ModelState.IsValid) { await _employeeDeparment.UpdateEmployeeDepartment(employeeDepartmentVM.EmployeeDepartment); TempData["message"] = "Your data has been updated successfully."; TempData["toasterType"] = ToasterType.success; return(RedirectToAction(nameof(Edit), new { id = employeeDepartmentVM.EmployeeDepartment.Id, returnUrl = employeeDepartmentVM.ReturnUrl })); } else { TempData["message"] = "A problem has been ocurred while updating your data."; TempData["toasterType"] = ToasterType.info; } return(View("Edit", EmployeeDepartmentViewModelFactory.Edit(employeeDepartmentVM.EmployeeDepartment, employeeDepartmentVM.ReturnUrl))); }
public async Task <IActionResult> Create([FromForm] EmployeeDepartmentViewModel employeeDepartmentVM) { if (ModelState.IsValid) { var newEmployeeDepartment = await _employeeDeparment.AddEmployeeDepartment(employeeDepartmentVM.EmployeeDepartment); TempData["message"] = "Your data has been submitted successfully."; TempData["toasterType"] = ToasterType.success; //return RedirectToAction(nameof(Index)); return(RedirectToAction(nameof(Edit), new { id = newEmployeeDepartment.Id, returnUrl = employeeDepartmentVM.ReturnUrl })); } TempData["message"] = "A problem has been ocurred while submitting your data."; TempData["toasterType"] = ToasterType.info; return(View("Edit", EmployeeDepartmentViewModelFactory.Create(employeeDepartmentVM.EmployeeDepartment, employeeDepartmentVM.ReturnUrl))); }
public ActionResult Index() { var employees = _repository.GetEmployees(); List <EmployeeDepartmentViewModel> evm = new List <EmployeeDepartmentViewModel>(); foreach (var item in employees) { EmployeeDepartmentViewModel emp = new EmployeeDepartmentViewModel(); emp.Id = item.Id; emp.Name = $"{item.Fname} {item.Mname} {item.Lname}"; emp.Age = item.Age ?? 1; emp.DepartmentName = item.department.Name; evm.Add(emp); } return(View(evm)); //return Json(new { //Id=1, //Fname="Pushpinder", //Lname="Kaur" //}); }
public async Task <IActionResult> UpdateDepartment([FromRoute] int id, [FromBody] EmployeeDepartmentViewModel departments) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != departments.EmployeeId) { return(BadRequest()); } try { _employee.UpdateEmployeeDepartment(departments); return(Ok()); } catch (Exception ex) { throw ex; } }
public void UpdateEmployeeDepartment(EmployeeDepartmentViewModel empDep) { var selectEmployee = (from dept in _db.DepartmentEmployee where dept.EmployeeID == empDep.EmployeeId select dept).FirstOrDefault(); if (selectEmployee == null) { var assignDepartmentToEmployee = new DepartmentEmployee { EmployeeID = empDep.EmployeeId, DepartmentID = empDep.DepartmentID }; _db.DepartmentEmployee.Add(assignDepartmentToEmployee); } else { selectEmployee.DepartmentID = empDep.DepartmentID; _db.DepartmentEmployee.Update(selectEmployee); } _db.SaveChanges(); }