public int SaveAssignCourse(AssignCourse assignCourse) { connection.ConnectionString = connectionString; string sqlQuery = "INSERT INTO assigned_course_tbl VALUES(@teachersId,@courseId,@departmentId,@credit,1)"; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters.Clear(); command.Parameters.Add("teachersId", SqlDbType.Int); command.Parameters["teachersId"].Value = assignCourse.TeachersId; command.Parameters.Add("courseId", SqlDbType.Int); command.Parameters["courseId"].Value = assignCourse.CourseId; command.Parameters.Add("departmentId", SqlDbType.Int); command.Parameters["departmentId"].Value = assignCourse.DepartmentId; command.Parameters.Add("credit", SqlDbType.Decimal); command.Parameters["credit"].Value = assignCourse.CourseCredit; connection.Open(); int isInserted = command.ExecuteNonQuery(); connection.Close(); return(isInserted); }
public ActionResult AssignCourseToTeachers(AssignCourse assignCourse) { ViewBag.Message = courseAssignManager.SaveAssignCourse(assignCourse); List <Department> departmentsList = departmentManager.GetDepartmentsList(); return(View(departmentsList)); }
public PartialViewResult TeacherInfoLoad(int?teacherId) { if (teacherId != null) { Teacher aTeacher = db.Teachers.FirstOrDefault(s => s.TeacherId == teacherId); ViewBag.Credit = aTeacher.CraditTaken; List <AssignCourse> assignTeachers = db.AssignCourses.Where(t => t.TeacherId == teacherId).ToList(); AssignCourse assign = null; if (assignTeachers.Count != 0) { assign = assignTeachers.Last(); } if (assign == null) { ViewBag.RemainingCredit = aTeacher.CraditTaken; } else { ViewBag.RemainingCredit = assign.RemaingCredit; } return(PartialView("~/Views/Shared/_TeachersCreditInfo.cshtml")); } else { return(PartialView("~/Views/Shared/_TeachersCreditInfo.cshtml")); } }
public ActionResult AssignConfirmed() { Teacher aTeacher = (Teacher)Session["Teacher"]; AssignCourse assigncourse = (AssignCourse)Session["AssignedCourse"]; AssignCourse assign = (AssignCourse)Session["AssigneddCourseCheck"]; Course aCourse = db.Courses.FirstOrDefault(c => c.CourseId == assigncourse.CourseId); assigncourse.CreditTaken = aTeacher.CraditTaken; if (assign == null) { assigncourse.RemaingCredit = aTeacher.CraditTaken - aCourse.CourseCradit; } else { assigncourse.RemaingCredit = assign.RemaingCredit - aCourse.CourseCradit; } aCourse.AssignTo = aTeacher.TeacherName; db.AssignCourses.Add(assigncourse); db.SaveChanges(); TempData["success"] = "Course Is Assigned"; return(View()); }
public bool IsCourseCodeExist(AssignCourse assignCourse) { SqlConnection connection = new SqlConnection(connectionString); string query = "Select * from CourseAssign where CourseCodeId =(@courseCodeId)"; connection.Open(); SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("courseCodeId", SqlDbType.Int); command.Parameters["courseCodeId"].Value = assignCourse.CourseCodeId; command.CommandText = query; command.Connection = connection; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { return(true); } else { return(false); } }
public ActionResult AskToAssign() { Teacher aTeacher = (Teacher)Session["Teacher"]; Course aCourse = (Course)Session["Course"]; AssignCourse assign = (AssignCourse)Session["AssigneddCourseCheck"]; double remainingCredite = 0.0; if (assign == null) { remainingCredite = aTeacher.CraditTaken; } else { remainingCredite = assign.RemaingCredit; } if (remainingCredite < 0) { ViewBag.Message = aTeacher.TeacherName + " Credit Limit Is Over. And The Course Credit : " + aCourse.CourseCode + " Is " + aCourse.CourseCradit + " ! Still You Want To Assign This Course To This Teacher ?"; } else { ViewBag.Message = aTeacher.TeacherName + " has only " + remainingCredite + " Credits Remaining . But, The Credit : " + aCourse.CourseCode + " Is " + aCourse.CourseCradit + " ! Still You Want To Assign This Course To This Teacher ?"; } return(View()); }
public string SaveAssignedCourse(AssignCourse assignCourse) { if (assignCourseGateway.IsCourseAssigned(assignCourse.Course_Id)) { int rowAfeected = assignCourseGateway.SaveAssignedCourse(assignCourse); if (rowAfeected > 0) { decimal tempCredit = assignCourse.Creditremain - assignCourse.Credit; int rowAfeectedbyUpdate = aTeacherGateway.UpdateCredittoremain(tempCredit, assignCourse.Teacher_Id); if (rowAfeectedbyUpdate > 0) { return("Course Assigend sucessfull"); } else { return("Credit no updated"); } //return "Course Assigend sucessfull"; } else { return("Course Assigend not sucessfull"); } } else { return("Course Already Assigned"); } }
public ActionResult AssignCourse(AssignCourse assignCourse) { bool isAssignedCourseExist = false; if (ModelState.IsValid) { string message; isAssignedCourseExist = assignCourseManager.IsAssignedCourseExist(assignCourse); if (isAssignedCourseExist) { message = "Course already assigned!"; ViewBag.Message = message; } else { message = assignCourseManager.Save(assignCourse); ViewBag.Message = message; } ModelState.Clear(); } else { ViewBag.Message = "Model state is invalid!"; } ViewBag.IsAssignedCourseExist = isAssignedCourseExist; ViewBag.Departments = departmentManager.GetAllDepartments(); return(View()); }
public int Save(AssignCourse assignCourse) { if (assignCourse.RemainingCredit - assignCourse.Credit < 0) { assignCourse.RemainingCredit = 0; } else { assignCourse.RemainingCredit = assignCourse.RemainingCredit - assignCourse.Credit; } string query = "Update Course set AssignTo = @teacher where Id = @courseId;Update Teacher set RemainingCredit = @remainUpdate where Id=@teacher"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("courseId", SqlDbType.Int); command.Parameters["courseId"].Value = assignCourse.CourseId; command.Parameters.Add("teacher", SqlDbType.Int); command.Parameters["teacher"].Value = assignCourse.TeacherId; command.Parameters.Add("remainUpdate", SqlDbType.Int); command.Parameters["remainUpdate"].Value = assignCourse.RemainingCredit; connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public int Save(AssignCourse aAssignCourse) { aAssignCourse.Type = 1; string query = "INSERT INTO AssignCourses(TeacherId,CourseId,AssignType) VALUES(@teacherId,@coureId,@type)"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@teacherId", aAssignCourse.TeacherId); command.Parameters.AddWithValue("@coureId", aAssignCourse.CourseId); command.Parameters.AddWithValue("@type", aAssignCourse.Type); connection.Open(); int rowAffect = command.ExecuteNonQuery(); connection.Close(); double a = aAssignCourse.CreditLeft - aAssignCourse.CourseCredit; string queryTwo = "UPDATE Teachers SET CreditLeft=@cLeft WHERE Id=@teacherId"; SqlCommand commandTwo = new SqlCommand(queryTwo, connection); commandTwo.Parameters.AddWithValue("@cLeft", a); commandTwo.Parameters.AddWithValue("@teacherId", aAssignCourse.TeacherId); connection.Open(); commandTwo.ExecuteNonQuery(); connection.Close(); string queryOne = "UPDATE Courses SET Type=1 WHERE Id=@courseId"; SqlCommand commandOne = new SqlCommand(queryOne, connection); commandOne.Parameters.AddWithValue("@courseId", aAssignCourse.CourseId); connection.Open(); commandOne.ExecuteNonQuery(); connection.Close(); return(rowAffect); }
public bool IsCourseAssignExists(AssignCourse assignCourse) { string query = "Select * from Course where Id = @id and AssignTo >0"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("id", SqlDbType.Int); command.Parameters["id"].Value = assignCourse.CourseId; connection.Open(); SqlDataReader reader = command.ExecuteReader(); bool hasRow = false; if (reader.HasRows) { hasRow = true; } reader.Close(); connection.Close(); return(hasRow); }
public async Task <ActionResult> Create([Bind(Include = "AssignCourseId,DepartmentId,TeacherId,CreditToBeTaken,RemainingCredit,CourseId")] AssignCourse assignCourse) { if (ModelState.IsValid) { if (IsAssigned(assignCourse)) { FlashMessage.Danger("This Course is Already Assigned!"); return(RedirectToAction("Create")); } //assignCourse.Course.IsAssigned = true; db.AssignCourses.Add(assignCourse); await db.SaveChangesAsync(); FlashMessage.Confirmation("Successfully Assigned"); return(RedirectToAction("Create")); } ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentCode", assignCourse.DepartmentId); //ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "TeacherName", assignCourse.TeacherId); //ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", assignCourse.CourseId); return(View(assignCourse)); }
public ActionResult CourseAssignToTeacher(AssignCourse assignCourse) { //CourseAssignToTeacher(); ViewBag.departments = aDepartmentManager.ViewAllDepartments(); ViewBag.message = aAssignCourseManager.Save(assignCourse); return(View()); }
private void btnAdd_Click(object sender, EventArgs e) { try { var teacher = cbSelectTeacher.SelectedItem as Teacher; var course = cbSelectCourse.SelectedItem as CourseOffering; var assignCourse = new AssignCourse { TeacherID = teacher.TeacherId, CourseID = course.CourseID }; var added = assignCourseCRUD.AddAssignCourse(assignCourse); if (added) { MessageBox.Show("Course assigned successfully"); } else { MessageBox.Show("Error while assigning the course!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List <AssignCourse> GetCoursesInformation(int departmentId) { List <AssignCourse> assignCourses = new List <AssignCourse>(); string query = "Select C.CourseId,C.CourseCode, C.CourseName,S.SemesterName From Course C " + "Inner Join Semester S On S.SemesterId = C.SemesterId " + "Where C.DepartmentId = @departmentId"; Gateway gateway = new Gateway(query); gateway.SqlCommand.Parameters.Clear(); gateway.SqlCommand.Parameters.AddWithValue("@departmentId", departmentId); SqlDataReader reader = gateway.SqlCommand.ExecuteReader(); while (reader.Read()) { AssignCourse assignCourse = new AssignCourse(); Course course = new Course(); course.CourseId = (int)reader["CourseId"]; course.CourseCode = reader["CourseCode"].ToString(); course.CourseName = reader["CourseName"].ToString(); assignCourse.Course = course; Semester semester = new Semester(); semester.SemesterName = reader["SemesterName"].ToString(); assignCourse.Semester = semester; assignCourses.Add(assignCourse); } reader.Close(); gateway.Connection.Close(); return(assignCourses); }
public ActionResult DeleteConfirmed(int id) { AssignCourse assignCourse = db.AssignCourses.Find(id); db.AssignCourses.Remove(assignCourse); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AssignCourse(AssignCourse assignCourse) { if (ModelState.IsValid) { ViewBag.Result = aTeacherManager.AssignCourse(assignCourse); } ViewBag.Departments = departmentManager.ViewDepartment(); return(View()); }
public async Task <ActionResult> DeleteConfirmed(int id) { AssignCourse assignCourse = await db.AssignCourses.FindAsync(id); db.AssignCourses.Remove(assignCourse); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public string AssignCourse(AssignCourse assignCourse) { if (aTeacherGatway.IsExitsCourse(assignCourse.Course)) { return("Course Already Assigned"); } aTeacherGatway.AssignCourse(assignCourse); return("Course Assigne Successful"); }
public ActionResult AssignCourse(AssignCourse assignCourse) { if (ModelState.IsValid) { ViewBag.message = courseManager.AssignToTeacher(assignCourse); } ViewBag.Departments = departmentManager.GetAllDepartmentForDropdown(); return(View()); }
// // GET: /AssignCourse/Details/5 public ActionResult Details(int id = 0) { AssignCourse assigncourse = db.AssignCourses.Find(id); if (assigncourse == null) { return(HttpNotFound()); } return(View(assigncourse)); }
public ActionResult Assign(AssignCourse assignCourse) { if (assignCourse.RemainingCredit - assignCourse.Credit < 0) { ViewBag.Messages = "Credit Over Load"; } DepartmentBind(); ViewBag.Message = assignCourseManager.Save(assignCourse); return(View()); }
public int SaveAssignedCourse(AssignCourse assignCourse) { Query = "INSERT INTO AssignedCourse(Department_Id,Teacher_Id,Course_Id,Status_Id) Values('" + assignCourse.Department_Id + "','" + assignCourse.Teacher_Id + "','" + assignCourse.Course_Id + "','1')"; Connection.Open(); Command = new SqlCommand(Query, Connection); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult CourseAssign(AssignCourse assignCourse) { ViewBag.listOfDepartments = assignCourseManager.GetAllDepartment(); ViewBag.listOfTeachers = assignCourseManager.GetAllTeacher(); ViewBag.listOfCourse = assignCourseManager.GetAllCourse(); string message = assignCourseManager.InsertAssignedCourse(assignCourse); ViewBag.Message = message; return(View()); }
public ActionResult Edit([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse) { if (ModelState.IsValid) { db.Entry(assignCourse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(assignCourse)); }
public bool IsAssigned(AssignCourse assign) { var assignedCourses = db.AssignCourses.ToList(); if (assignedCourses.Any(c => (c.CourseId == assign.CourseId))) { return(true); } return(false); }
public ActionResult Assign(AssignCourse assignCourse) { string msg = aTeacherManager.AssignCourseToTeacher(assignCourse); ModelState.Clear(); ViewBag.Message = msg; List <Department> departments = aDepartmentManager.GetAllDepartmentsInfo(); ViewBag.Departments = departments; return(View()); }
public ActionResult AssignCourse(AssignCourse assignCourse) { List <Department> aDepartments = aDepartmentManager.GetAllDepartment(); ViewBag.DepatmentList = aDepartments; string message = assignCourseManager.SaveAssignedCourse(assignCourse); ViewBag.message = message; return(View()); }
public ActionResult Create([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse) { if (ModelState.IsValid) { db.AssignCourses.Add(assignCourse); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(assignCourse)); }
public bool IsCourseAlreadyAssigned(AssignCourse assignCourse) { Query = "SELECT * FROM AssignCourse Where CourseId = '" + assignCourse.CourseId + "' AND Flag = '1'"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool result = Reader.HasRows; Reader.Close(); Connection.Close(); return(result); }