public void Update(CourseAssign entity) { var CourseAssign = CourseAssignRepository.Find(entity.Id); CourseAssign.CourseId = entity.CourseId; CourseAssign.TeacherId = entity.TeacherId; CourseAssign.DepartmentId = entity.DepartmentId; CourseAssignRepository.Update(CourseAssign); unitOfWork.SaveChanges(); }
// // GET: /CourseAssign/Details/5 public ActionResult Details(int id = 0) { CourseAssign courseassign = db.CourseAssigns.Find(id); if (courseassign == null) { return(HttpNotFound()); } return(View(courseassign)); }
public int Save(CourseAssign courseAssign) { string query = "INSERT INTO CourseAssign VALUES('" + courseAssign.DepartmentId + "','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "','" + 1 + "')"; Command = new SqlCommand(query, Connection); Connection.Open(); int rowAffect = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffect); }
public string AssignSave(CourseAssign courseAssign) { if (TeacherGateway.AssignSave(courseAssign) > 0) { return("Saved"); } else { return("Not saved"); } }
public int AssignNewCourse(CourseAssign courseAssign) { string query = @"INSERT INTO TeacherAsign Values('Assign','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "')"; cmd = new SqlCommand(query, connection); connection.Open(); int rowAffect = cmd.ExecuteNonQuery(); connection.Close(); return(rowAffect); }
public ActionResult AssignCourse(CourseAssign courseAssign) { if (Session["username"] == null) { return(RedirectToAction("Login", "Account")); } ViewBag.response = aTeacherManager.AssignCourse(courseAssign); ViewBag.Departments = aDepartmentManager.GetAllDepartments(); return(View()); }
public int Save(CourseAssign aCourseAssign) { Query = "Insert into AssignCourse Values('" + aCourseAssign.Id + "','" + aCourseAssign.CourseId + "','" + aCourseAssign.RemainingCredit + "','Assign') "; Command = new SqlCommand(Query, Connection); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public string SaveAssignTeacher(CourseAssign course) { if (courseGateway.SaveAssignTeacher(course) > 0) { return("Save"); } else { return("Error"); } }
public int AssignNewCourse(CourseAssign courseAssign) { string query = "INSERT INTO AssignTeacherTable Values('Assign','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "')"; _command = new SqlCommand(query, _connection); _connection.Open(); int rowAffect = _command.ExecuteNonQuery(); _connection.Close(); return(rowAffect); }
public ActionResult AssignTeacher(CourseAssign courseAssign) { if (!ModelState.IsValid) { ViewBag.Departments = departmentBll.GetDepartments(); return(View("AssignTeacher")); } ViewBag.Message = courseBll.SaveAssignTeacher(courseAssign); ViewBag.Departments = departmentBll.GetDepartments(); return(View()); }
public bool IsSubjectExsists(CourseAssign courseAssign) { string query = "SELECT * FROM CourseAssign WHERE CourseCode='" + courseAssign.CourseCode + "' AND TeacherId='" + courseAssign.TeacherId + "'"; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool IsExsists = Reader.HasRows; Connection.Close(); return(IsExsists); }
//To unassign course// public bool UnassignCourse(CourseAssign courseAssign) { var CourseAssigns = dbContext.CourseAssigns.Where(x => x.Assign == true); foreach (var item in CourseAssigns) { item.Assign = false; } int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
public ActionResult Edit(CourseAssign courseassign) { if (ModelState.IsValid) { db.Entry(courseassign).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", courseassign.TeacherId); ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", courseassign.CourseId); return(View(courseassign)); }
// // GET: /CourseAssign/Edit/5 public ActionResult Edit(int id = 0) { CourseAssign courseassign = db.CourseAssigns.Find(id); if (courseassign == null) { return(HttpNotFound()); } ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", courseassign.TeacherId); ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", courseassign.CourseId); return(View(courseassign)); }
public ActionResult Edit([Bind(Include = "id,DepartmentId,TeacherId,CreditToBeTaken,RemainingCredit,CourseId,CourseName")] CourseAssign courseAssign) { if (ModelState.IsValid) { db.Entry(courseAssign).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "Id", "CourseCode", courseAssign.CourseId); ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentName", courseAssign.DepartmentId); ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "Name", courseAssign.TeacherId); return(View(courseAssign)); }
public string AssignCourse(CourseAssign courseAssign) { var rowAffected = courseGateway.AssignCourse(courseAssign); if (rowAffected[0] > 0 && rowAffected[1] > 0 && rowAffected[2] > 0) { return("Course Assigned."); } else { return("Course Assign failed."); } }
public bool Add(CourseAssign courseAssign) { bool IsSaved = _repository.Add(courseAssign); if (IsSaved) { return(true); } else { return(false); } }
internal string SaveCourseAssain(CourseAssign courseAssign) { if (courseAssign.CourseName == "") { throw new Exception("Enter Email ....!!!!!"); } //int aTest = _courseAssignGetway.GetValidation(courseAssign.CourseName); //if (aTest > 0) //{ // throw new Exception("this Code already Existed....!!!!!"); //} return(_courseAssignGetway.SaveCourseAssain(courseAssign)); }
public dynamic SaveAssignCourse(CourseAssign courseAssign) { int rowAffect = anCourseAssignGateway.SaveAssignCourse(courseAssign); if (rowAffect > 0) { return("Saved"); } else { return("Failed"); } }
//save public string Save(CourseAssign courseAssign) { if (unitofWork.CourseAssign.IsExists(x => x.TeacherId == courseAssign.TeacherId && x.CourseId == courseAssign.CourseId && x.IsDelete == 0)) { return(Message.Warning("Course" + courseAssign.Course.Name + "was already assign by" + courseAssign.Teacher.Name + "Teacher")); } else { unitofWork.CourseAssign.Add(courseAssign); int rowAffect = unitofWork.Completed(); return((rowAffect > 0) ? Message.Success("Save Successful") : Message.Failed("Save Failed")); } }
public string InsertNewCourse(CourseAssign courseAssign) { int rowAffected = aCourseAssignGateway.AssignNewCourse(courseAssign); if (rowAffected > 0) { return("Teacher Course Assign Successfully Done!!!"); } else { return("Course Assign Failed!!"); } }
// update public string Update(CourseAssign courseAssign) { if (unitofWork.CourseAssign.IsExists(x => x.TeacherId == courseAssign.TeacherId && x.CourseId == courseAssign.CourseId && x.IsDelete == 0 && x.Id == courseAssign.Id)) { return(Message.Warning("Course Already Exists")); } else { unitofWork.CourseAssign.Update(courseAssign); int updated = unitofWork.Completed(); return((updated > 0) ? "1" : Message.Failed("Update Failed")); } }
public ActionResult Edit([Bind(Include = "CourseAssignID,DepartmentID,CourseID,TeacherID")] CourseAssign courseassign) { if (ModelState.IsValid) { db.Entry(courseassign).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.CoursesDbset, "CourseID", "CourseCredit", courseassign.CourseID); ViewBag.DepartmentID = new SelectList(db.DepartmentsDbset, "DepartmentID", "DepartmentCode", courseassign.DepartmentID); ViewBag.TeacherID = new SelectList(db.TeachersDcset, "TeacherID", "TeacherName", courseassign.TeacherID); return(View(courseassign)); }
public string AssignCourse(CourseAssign courseassign) { int assignCourse = courseAssignGateway.AssignCourse(courseassign.TeacherId, courseassign.CourseId); if (assignCourse > 0) { double remainingCredit = courseassign.ReaminingCredit - courseassign.Credit; int updateRemainingCredit = courseAssignGateway.UpdateRemainingCreditOfTeacher(remainingCredit, courseassign.TeacherId); } return("Course Assign Successfully."); }
public ActionResult Assigning(CourseAssign courseassignto) { if (ModelState.IsValid) { db.CourseAssigns.Add(courseassignto); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Departments = db.Departments.ToList(); ViewBag.CourseID = new SelectList(db.Courses, "Id", "CourseCode", courseassignto.CourseID); ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptCode", courseassignto.DepartmentId); ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "TeacherName", courseassignto.TeacherId); return(View(courseassignto)); }
public bool IsCourseAssigned(CourseAssign courseAssign) { string query = "SELECT * FROM CourseAssign WHERE Active = '" + 1 + "' AND DepartmentId = '" + courseAssign.DepartmentId + "' AND TeacherId = '" + courseAssign.TeacherId + "' AND CourseId = '" + courseAssign.CourseId + "' "; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool isExists = Reader.HasRows; Connection.Close(); return(isExists); }
// GET: /CourseAssign/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseAssign courseassign = db.CourseAssigns.Find(id); if (courseassign == null) { return(HttpNotFound()); } return(View(courseassign)); }
public ActionResult Create([Bind(Include = "Id,DepartmentId,TeacherId,CreditTaken,CreditLeft,CourseID,Name,Credit")] CourseAssign courseassign) { if (ModelState.IsValid) { db.CourseAssigns.Add(courseassign); db.SaveChanges(); // return RedirectToAction("Index"); } ViewBag.CourseID = new SelectList(db.Courses, "Id", "CourseCode", courseassign.CourseID); ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptCode", courseassign.DepartmentId); ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "TeacherName", courseassign.TeacherId); return(View(courseassign)); }
public JsonResult CourseAssign(CourseAssign courseAssign) { courseAssign.ReaminingCredit = courseAssign.ReaminingCredit - courseAssign.Credit; string log = anCourseAssignManager.SaveAssignCourse(courseAssign); anCourseAssignManager.UpdateReaminingCredit(courseAssign.ReaminingCredit, courseAssign.TeacherId); ViewBag.Department = aSaveTeacherManager.TakeAllDeparment(); return(Json(log)); }
public bool IsCourseNotAssigned(CourseAssign aCourseAssign) { Command = new SqlCommand(); Command.CommandText = "SELECT * FROM t_course WHERE course_id = '" + aCourseAssign.CourseId + "' AND course_status = 'Not Assigned Yet' "; Command.Connection = Connection; Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { return(true); } Reader.Close(); Connection.Close(); return(false); }