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