/// <summary> /// Find and by BkID/BkName/TypeID Find /// </summary> /// <param name="bkFilter">Model_BookIngo_View</param> /// <returns>List</returns> public static List <BookInfo_View> Find(BookInfo_View bkFilter) { try { using (BookDB_Model BkDB = new BookDB_Model()) { var list = from data in BkDB.BookInfo_View select data; if (bkFilter.BkId > 0) { list = list.Where(data => data.BkId == bkFilter.BkId).Select(data => data); } if (!string.IsNullOrEmpty(bkFilter.BkName)) { list = list.Where(data => data.BkName.Contains(bkFilter.BkName)).Select(data => data); } if (bkFilter.TypeId > 0) { list = list.Where(data => data.TypeId == bkFilter.TypeId).Select(data => data); } return(list.ToList()); } } catch (Exception error) { throw error; } }
/// <summary> /// Add /// </summary> /// <param name="bk">Class</param> /// <returns>int</returns> public static int Add(BookInfo bk) { try { using (BookDB_Model BkDB = new BookDB_Model()) { BkDB.BookInfo.Add(bk); return(BkDB.SaveChanges()); } } catch (Exception error) { throw error; } }
/// <summary> /// Edit /// </summary> /// <param name="bk">Class</param> /// <returns>int</returns> public static int Edit(BookInfo bk) { try { using (BookDB_Model BkDB = new BookDB_Model()) { BkDB.Entry(bk).State = System.Data.Entity.EntityState.Modified; return(BkDB.SaveChanges()); } } catch (Exception error) { throw error; } }
/// <summary> /// Delete /// </summary> /// <param name="id">ID</param> /// <returns>int</returns> public static int Del(int id) { try { using (BookDB_Model BkDB = new BookDB_Model()) { BkDB.BookInfo.Remove(BkDB.BookInfo.Find(id)); return(BkDB.SaveChanges()); } } catch (Exception error) { throw error; } }
/// <summary> /// Find /// </summary> /// <returns>list</returns> public static List <BookType> Find() { try { using (BookDB_Model BkDB = new BookDB_Model()) { var list = from data in BkDB.BookType select data; return(list.ToList()); } } catch (Exception error) { throw error; } }