public string Check_Book(BookModel rm) { LibraryEntities3 lb = new LibraryEntities3(); string msg = string.Empty; M_Book update = lb.M_Book.Where(c => c.BookID.Equals(rm.BookID)).SingleOrDefault(); if (update != null) { msg = update.BookID; } else { msg = ""; } return(msg); }
public string Book_Update(BookModel rm) { LibraryEntities3 lbe = new LibraryEntities3(); string msg = string.Empty; M_Book mb = lbe.M_Book.Where(c => c.BookID.Equals(rm.BookID)).SingleOrDefault(); mb.BookName = rm.BookName; mb.BookType = rm.BookType; mb.PDF = rm.PDF; try { lbe.SaveChanges(); msg = "OK"; } catch (Exception ex) { msg = ex.ToString(); } return(msg); }
//public DataTable BookDelete() //{ // BaseDL bdl = new BaseDL(); // SqlParameter[] prms = new SqlParameter[0]; // return bdl.SelectData("M_Delete_Book", prms); //} public string Book_Save(BookModel bm) { LibraryEntities3 lbe = new LibraryEntities3(); string msg = string.Empty; M_Book mb = new M_Book(); mb.BookID = bm.BookID; mb.BookName = bm.BookName; mb.BookType = bm.BookType; mb.PDF = bm.PDF; try { lbe.M_Book.Add(mb); lbe.SaveChanges(); msg = "OK"; } catch (Exception ex) { msg = ex.ToString(); } return(msg); }