public ActionResult AddIssuedbook(Issued_Books v) { try { IssuedBooksVM m = new IssuedBooksVM(); m.Number = v.Number; m.Email = v.Email; m.Issue_date = v.Issue_date; m.Return_date = v.Return_date; m.Due_date = v.Due_date; v.Fine = Fine(v.Return_date, v.Due_date); m.Fine = v.Fine; m.Status = v.Status; LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); db.Issued_Books.Add(v); db.SaveChanges(); return(RedirectToAction("IssuedBooks")); } catch { return(View()); } }
public ActionResult AddTeacher(tbl_teacher t, Email e) { try { LibraryManagementSystemEntities DB = new LibraryManagementSystemEntities(); Teacher teacher = new Teacher(); teacher.Name = t.Name; teacher.Email = t.Email; e.Email1 = t.Email; teacher.Designation = t.Designation; DB.tbl_teacher.Add(t); DB.Emails.Add(e); DB.SaveChanges(); return(RedirectToAction("Teacher")); } catch { return(View()); } }
public ActionResult IssuedBooks() { using (LibraryManagementSystemEntities db = new LibraryManagementSystemEntities()) { return(View(db.Issued_Books.ToList())); } }
public ActionResult Editst(int id, Student t) { LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); db.tbl_student.Find(id).Name = t.Name; db.tbl_student.Find(id).Email = t.Email; db.tbl_student.Find(id).Registration_Number = t.Registration_Number; db.SaveChanges(); return(RedirectToAction("Student")); }
public ActionResult Student(string searchby, string search) { using (LibraryManagementSystemEntities db = new LibraryManagementSystemEntities()) { if (searchby == "Name") { return(View(db.tbl_student.Where(x => x.Name.Contains(search) || search == null).ToList())); } else { return(View(db.tbl_student.Where(x => x.Registration_Number.Contains(search) || search == null).ToList())); } } }
public ActionResult Teacher(string searchby, string search) { using (LibraryManagementSystemEntities db = new LibraryManagementSystemEntities()) { if (searchby == "Name") { return(View(db.tbl_teacher.Where(x => x.Name.Contains(search) || search == null).ToList())); } else { return(View(db.tbl_teacher.Where(x => x.Designation.Contains(search) || search == null).ToList())); } } }
// GET: Admin/Delete/5 public ActionResult Delete(int id) { LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); foreach (tbl_teacher t1 in db.tbl_teacher) { if (t1.ID == id) { db.tbl_teacher.Remove(t1); } } db.SaveChanges(); return(View("Teacher")); }
public ActionResult Editst(int id) { Student st = new Student(); LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); foreach (tbl_student ST in db.tbl_student) { if (ST.ID == id) { st.Name = ST.Name; st.Email = ST.Email; st.Registration_Number = ST.Registration_Number; break; } } return(View()); }
// GET: Admin/Edit/5 public ActionResult Edit(int id) { Teacher t = new Teacher(); LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); foreach (tbl_teacher T in db.tbl_teacher) { if (T.ID == id) { t.Name = T.Name; t.Email = T.Email; t.Designation = T.Designation; break; } } return(View()); }
public ActionResult Edit(int id, Teacher t) { { LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); db.tbl_teacher.Find(id).Name = t.Name; db.tbl_teacher.Find(id).Email = t.Email; db.tbl_teacher.Find(id).Designation = t.Designation; db.SaveChanges(); return(RedirectToAction("Teacher")); } /*catch * { * return View(); * }*/ }
public ActionResult AddStudent(tbl_student s, Email e) { try { Student st = new Student(); st.Email = s.Email; e.Email1 = s.Email; st.Name = s.Name; st.Registration_Number = s.Registration_Number; LibraryManagementSystemEntities db = new LibraryManagementSystemEntities(); db.tbl_student.Add(s); db.Emails.Add(e); db.SaveChanges(); return(RedirectToAction("Student")); } catch { return(View()); } }