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());
}
}
