public async Task <ActionResult> Create(CourseAssignModel model) { try { var courses = new List <Course>(); var teachId = model.TeacherId; courses = model.Courses; for (int i = 0; i < courses.Count(); i++) { if (courses[i].CheckboxAnswer == true) { var csa = new CourseAssignement(); csa.CourseId = courses[i].Id; csa.TeacherId = teachId; crsa.Add(csa); } } await crsa.SaveChangesAsync(); return(RedirectToAction("Details", new RouteValueDictionary( new { controller = "Teacher", action = "Details", Id = model.TeacherId }))); } catch (Exception) { throw; } }
public List <CourseAssignModel> GatAllViewCourseStaticGateway() { SqlConnection con = new SqlConnection(conectionStirng); string query = "select * from vAssignedCourse"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); List <CourseAssignModel> courseAssignModels = new List <CourseAssignModel>(); if (dataReader.HasRows) { while (dataReader.Read()) { CourseAssignModel courseAssignModel = new CourseAssignModel(); courseAssignModel.DepartmentId = Convert.ToInt32(dataReader["DepartmentID"]); courseAssignModel.CourseCode = dataReader["CourseCode"].ToString(); courseAssignModel.CourseName = dataReader["CourseName"].ToString(); courseAssignModel.SemesterName = dataReader["SemiName"].ToString(); courseAssignModel.TeacherName = dataReader["AssignedTo"].ToString(); courseAssignModels.Add(courseAssignModel); } dataReader.Close(); } con.Close(); return(courseAssignModels); }
//GET : public PartialViewResult Create(int id) { var model = new CourseAssignModel(); model.Teacher = th.GetById(id); model.Courses = crs.GetAll(); model.TeacherId = model.Teacher.Id; return(PartialView(model)); }
public int SaveCourseAssignGateway(CourseAssignModel courseAssignModel) { SqlConnection con = new SqlConnection(conectionStirng); string query = "insert into CourseAssign values ('" + courseAssignModel.DepartmentId + "','" + courseAssignModel.TeacherId + "', '" + courseAssignModel.CourseId + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int rowAffect = cmd.ExecuteNonQuery(); con.Close(); return(rowAffect); }
public string IsExistCourseGateway(CourseAssignModel courseAssignModel) { string message = null; SqlConnection con = new SqlConnection(conectionStirng); string query = "Select * from CourseAssign where CourseID='" + courseAssignModel.CourseId + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { message = "This Course Already Assign Another Teacher"; } con.Close(); return(message); }
public PartialViewResult Edit(int id) { var model = new CourseAssignModel(); model.Teacher = th.GetById(id); model.Courses = crs.GetAll(); model.TeacherId = model.Teacher.Id; foreach (var item in model.Courses) { if (crsa.IfExists(item.Id, model.TeacherId)) { item.CheckboxAnswer = true; } } return(PartialView(model)); }
public string SaveCourseAssignManager(CourseAssignModel courseAssignModel) { if (courseAssignGateway.IsExistCourseGateway(courseAssignModel) == null) { if (courseAssignGateway.SaveCourseAssignGateway(courseAssignModel) > 0) { return("Save Successfull"); } else { return("Save Fail"); } } else { return(courseAssignGateway.IsExistCourseGateway(courseAssignModel)); } }
public async Task <ActionResult> Edit(CourseAssignModel model) { try { var courses = new List <Course>(); var teacherId = model.TeacherId; courses = model.Courses; for (int i = 0; i < courses.Count(); i++) { if (courses[i].CheckboxAnswer == true) { if (!crsa.IfExists(courses[i].Id, teacherId)) { var csa = new CourseAssignement(); csa.CourseId = courses[i].Id; csa.TeacherId = teacherId; crsa.Add(csa); } } else { if (crsa.IfExists(courses[i].Id, teacherId)) { var csa = await crsa.GetByIdAsync(courses[i].Id, teacherId); if (csa == null) { return(NotFound()); } crsa.Remove(csa); } } } await crsa.SaveChangesAsync(); return(RedirectToAction("Details", new RouteValueDictionary( new { controller = "Teacher", action = "Details", Id = model.TeacherId }))); } catch (Exception) { throw; } }
public CourseAssignModel GateCourseCredit(int?courseId) { SqlConnection con = new SqlConnection(conectionStirng); string query = "Select * from Course where CourseID='" + courseId + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); CourseAssignModel courseAssignModel = new CourseAssignModel(); if (dataReader.HasRows) { dataReader.Read(); courseAssignModel.CourseId = Convert.ToInt32(dataReader["CourseID"]); courseAssignModel.CourseName = dataReader["CourseName"].ToString(); courseAssignModel.CourseCredit = Convert.ToDecimal(dataReader["CourseCredit"]); dataReader.Close(); } con.Close(); return(courseAssignModel); }
public CourseAssignModel GatTeacherCreditGateway(int?teacherId) { SqlConnection con = new SqlConnection(connectionString); string query = "Select * from vTeacherCourse where TeacherID='" + teacherId + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); CourseAssignModel courseAssignModel = new CourseAssignModel(); SqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { dataReader.Read(); courseAssignModel.CourseId = Convert.ToInt32(dataReader["TeacherID"]); courseAssignModel.TeacherCreditToTaken = Convert.ToDecimal(dataReader["CreditTaken"]); courseAssignModel.TeacherRemainingCredit = Convert.ToDecimal(dataReader["RemCredit"]); dataReader.Close(); } con.Close(); return(courseAssignModel); }
public JsonResult CreditTakenByCourseId(int?passCourse) { CourseAssignModel courseCredit = courseManager.GateCourseCredit(passCourse); return(Json(courseCredit, JsonRequestBehavior.AllowGet)); }
public JsonResult CreditTakenByTeacher(int?teacherId) { CourseAssignModel courseTeacher = teacherManager.GatTeacherCreditManger(teacherId); return(Json(courseTeacher, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveCourseAssign(CourseAssignModel courseAssignModel) { ViewBag.message = courseManager.SaveCourseAssignManager(courseAssignModel); ViewBag.DepartmentList = departmentManager.GateAllDepertmentManager(); return(View()); }