public static void Delect(WindowsAuthenticationWebApplication.Book book) { LibraryManagementBDEntities lms = new LibraryManagementBDEntities(); var deleteupd = lms.Books.Where(b => b.BookID == book.BookID).FirstOrDefault(); lms.Books.Remove(deleteupd); lms.SaveChanges(); }
public static void Insert(WindowsAuthenticationWebApplication.Book book) { LibraryManagementBDEntities lms = new LibraryManagementBDEntities(); string fileNameToInsert = HttpContext.Current.Session["ImagePath"].ToString(); if (fileNameToInsert != string.Empty) { book.ImageFile = fileNameToInsert; lms.Books.Add(book); lms.SaveChanges(); } }
public static void Update(WindowsAuthenticationWebApplication.Book book) { LibraryManagementBDEntities lms = new LibraryManagementBDEntities(); string fileNameToUpdate = HttpContext.Current.Session["ImagePath"].ToString(); if (fileNameToUpdate != string.Empty) { var upd = lms.Books.Where(b => b.BookID == book.BookID).FirstOrDefault(); upd.BookTitle = book.BookTitle; upd.AuthorName = book.AuthorName; upd.FacultyID = book.FacultyID; book.ImageFile = fileNameToUpdate; lms.Books.Add(book); lms.SaveChanges(); } }
public static List <WindowsAuthenticationWebApplication.Book> Select() { LibraryManagementBDEntities lms = new LibraryManagementBDEntities(); return(lms.Books.ToList()); }