public ActionResult AddDepartment(DepartmentViewModel departmentViewModel) { IEnumerable <Department> departments = departmentBL.GetDepartmentList(); List <SelectListItem> deptList = new List <SelectListItem>(); foreach (Department department in departments) { deptList.Add(new SelectListItem { Text = @department.DeptName, Value = @department.DeptId.ToString() }); } ViewBag.Dept = deptList; if (ModelState.IsValid) { CollegeDepartment collegeDepartment = AutoMapper.Mapper.Map <DepartmentViewModel, CollegeDepartment>(departmentViewModel); if (departmentBL.AddDepartmentByCollege(collegeDepartment)) { TempData["CollegeCode"] = collegeDepartment.CollegeCode; TempData["Message"] = Message.Added; return(RedirectToAction("DisplayDepartmentByCollege")); } ViewData["Message"] = Message.AlreadyAdded; } return(View()); }
public ActionResult DeleteDepartment(int id) { CollegeDepartment collegeDepartment = departmentBL.GetDepartment(id); DepartmentViewModel departmentViewModel = AutoMapper.Mapper.Map <CollegeDepartment, DepartmentViewModel>(collegeDepartment); return(View(departmentViewModel)); }
public ActionResult DeleteDepartment(DepartmentViewModel departmentViewModel) { CollegeDepartment collegeDepartment = Mapper.Map <DepartmentViewModel, CollegeDepartment>(departmentViewModel); TempData["CollegeCode"] = collegeDepartment.CollegeCode; departmentBL.DeleteDepartment(collegeDepartment.ID); TempData["Message"] = Message.Deleted; return(RedirectToAction("DisplayDepartmentByCollege")); }
// //Summary: // This Method Check the Department is Exists or not and the Add to the Databae. public bool AddDepartmentByCollege(CollegeDepartment collegeDepartment) { if (departmentRepository.CheckExistsDepartment(collegeDepartment.DeptId, collegeDepartment.CollegeCode) == null) { departmentRepository.AddDepartmentByCollege(collegeDepartment); return(true); } return(false); }
public ActionResult EditDepartment(DepartmentViewModel departmentViewModel) { if (ModelState.IsValid) { CollegeDepartment collegeDepartment = Mapper.Map <DepartmentViewModel, CollegeDepartment>(departmentViewModel); departmentBL.EditDepartment(collegeDepartment); TempData["CollegeCode"] = collegeDepartment.CollegeCode; return(RedirectToAction("DisplayDepartmentByCollege")); } return(View()); }
// //Summary: // This method is to Add Department to database public void AddDepartmentByCollege(CollegeDepartment collegeDepartment) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { //SqlParameter DeptId = new SqlParameter("@DeptId", collegeDepartment.DeptId); //SqlParameter collegeCode = new SqlParameter("@CollegeCode", collegeDepartment.CollegeCode); //SqlParameter AvailableSeats = new SqlParameter("@AvailableSeats", collegeDepartment.AvailableSeats); //collegeDBContext.Database.ExecuteSqlCommand("@DeptId, @CollegeCode, @AvailableSeats", DeptId, collegeCode, AvailableSeats); collegeDBContext.CollegeDepartments.Add(collegeDepartment); collegeDBContext.SaveChanges(); } }
// //Summary: // This method is to Update Department to database public void EditDepartment(CollegeDepartment collegeDepartment) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { //SqlParameter Id = new SqlParameter("@ID", collegeDepartment.ID); //SqlParameter DeptId = new SqlParameter("@DeptId", collegeDepartment.DeptId); //SqlParameter collegeCode = new SqlParameter("@CollegeCode", collegeDepartment.CollegeCode); //SqlParameter AvailableSeats = new SqlParameter("@AvailableSeats", collegeDepartment.AvailableSeats); //collegeDBContext.Database.ExecuteSqlCommand("CollegeDepartment_Update @ID, @DeptId, @CollegeCode, @AvailableSeats", Id, DeptId, collegeCode, AvailableSeats); collegeDBContext.Entry(collegeDepartment).State = EntityState.Modified; collegeDBContext.SaveChanges(); } }
public bool AddApplication(UserApplication application) { DepartmentRepository departmentRepository = new DepartmentRepository(); CollegeDepartment collegeDepartment = departmentRepository.CheckExistsDepartment(application.DeptID, application.CollegeCode); if (collegeDepartment.AvailableSeats > 0) { collegeDepartment.AvailableSeats = collegeDepartment.AvailableSeats - 1; departmentRepository.EditDepartment(collegeDepartment); applicationRepository.AddApplication(application); return(true); } return(false); }
public void EditDepartment(CollegeDepartment collegeDepartment) { departmentRepository.EditDepartment(collegeDepartment); }