public static void addBook(SACH book, List <string> matheloai, List <string> TACGIA, string maNXB) { book.NGAY_BAN = System.DateTime.Now; using (var db = new booksEntities()) { foreach (string mtl in matheloai) { THE_LOAI tl = db.THE_LOAI.Where(theloai => theloai.MA_THE_LOAI == mtl).Select(theloai => theloai).FirstOrDefault(); tl.SACH.Add(book); } NHA_XUAT_BAN nxb = db.NHA_XUAT_BAN.Where(nxban => nxban.MA_NXB == maNXB).Select(nxban => nxban).FirstOrDefault(); nxb.SACH.Add(book); foreach (string tacgia in TACGIA) { TAC_GIA tg = db.TAC_GIA.Where(au => au.TEN_TAC_GIA.Contains(tacgia.Trim())).Select(tgia => tgia).FirstOrDefault(); if (tg == null) { addAuthor(tacgia.Trim()); tg = db.TAC_GIA.Where(au => au.TEN_TAC_GIA.Contains(tacgia.Trim())).Select(tgia => tgia).FirstOrDefault(); } tg.SACH.Add(book); } book.DANH_GIA_TOT = book.TONG_DANH_GIA = 0; db.SACH.Add(book); db.SaveChanges(); } }
public static List <Y_KIEN> getNegativeComments(int maSach) { using (var db = new booksEntities()) { var query = db.Y_KIEN.Where(cmt => cmt.MA_SACH == maSach && cmt.DANH_GIA == "tiêu cực").Select(cmts => cmts); return(query.OrderByDescending(x => x.NGAY).ToList()); } }
public static List <SACH> getAllBooks() { using (var db = new booksEntities()) { var query = from sach in db.SACH select sach; return(query.OrderByDescending(x => x.NGAY_BAN).ToList <SACH>()); } }
public static List <NHA_XUAT_BAN> getAllNXB() { using (var db = new booksEntities()) { List <NHA_XUAT_BAN> nxbs = (from nxb in db.NHA_XUAT_BAN select nxb).ToList(); return(nxbs); } }
public static List <TAC_GIA> getAllAuthors() { using (var db = new booksEntities()) { List <TAC_GIA> tacGias = (from tg in db.TAC_GIA select tg).ToList(); return(tacGias); } }
public static List <THE_LOAI> getAllCatagories() { using (var db = new booksEntities()) { List <THE_LOAI> theloais = (from tl in db.THE_LOAI select tl).ToList(); return(theloais); } }
public static List <Y_KIEN> getComments(int maSach) { using (var db = new booksEntities()) { var query = db.Y_KIEN.Where(cmt => cmt.MA_SACH == maSach); return(query.ToList()); } }
public static void addAuthor(string tenTacGia) { TAC_GIA tacgia = new TAC_GIA(); tacgia.TEN_TAC_GIA = tenTacGia; using (var db = new booksEntities()) { db.TAC_GIA.Add(tacgia); db.SaveChanges(); } }
public static List <ProductView> getTopBooksIncAuthorByName(String tensach) { using (var db = new booksEntities()) { var query = from s in db.SACH select s; var BookAuthor = db.SACH.Include("TAC_GIA"); var listB = BookAuthor.Where(s => s.TEN_SACH.Contains(tensach)).Select(s => new { book = s, percent = s.TONG_DANH_GIA == 0 ? -1 : Math.Round((double)(s.DANH_GIA_TOT * 100.0 / s.TONG_DANH_GIA), 2) }); List <ProductView> final = new List <ProductView>(); foreach (var pv in listB) { final.Add(new ProductView(pv.book, pv.percent)); } return(final.OrderByDescending(x => x.percent).ToList()); } }
public static BookDetails getBookDetails(int maSach) { using (var db = new booksEntities()) { var theloai = db.SACH.Where(s => s.MA_SACH == maSach).SelectMany(s => s.THE_LOAI); List <THE_LOAI> Catagory = theloai.ToList(); var tgs = db.SACH.Where(s => s.MA_SACH == maSach).SelectMany(s => s.TAC_GIA); List <TAC_GIA> Authors = tgs.ToList(); var nxban = db.SACH.Where(s => s.MA_SACH == maSach).SelectMany(s => s.NHA_XUAT_BAN); NHA_XUAT_BAN publisher = nxban.FirstOrDefault(); var sachdetail = db.SACH.Where(s => s.MA_SACH == maSach); SACH book = sachdetail.FirstOrDefault(); return(new BookDetails(book, Authors, Catagory, publisher)); } }
public static List <ProductView> getAllBooksIncAuthor() { using (var db = new booksEntities()) { var query = from sach in db.SACH select sach; var BookAuthor = db.SACH.Include("TAC_GIA"); var b = query.Select(s => new { book = s, percent = s.TONG_DANH_GIA == 0 ? -1 : Math.Round((double)(s.DANH_GIA_TOT * 100.0 / s.TONG_DANH_GIA), 2) }); List <ProductView> final = new List <ProductView>(); foreach (var pv in b) { final.Add(new ProductView(pv.book, pv.percent)); } return(final.OrderByDescending(x => x.book.NGAY_BAN).ToList()); } }
public static void update(SACH book) { int MS = Convert.ToInt32(book.MA_SACH); using (var db = new booksEntities()) { SACH sach = db.SACH.Where(x => x.MA_SACH == MS).Select(x => x).FirstOrDefault(); if (sach != null) { sach.TEN_SACH = book.TEN_SACH; sach.NOI_DUNG = book.NOI_DUNG; sach.GIA = book.GIA; } } }
public static SACH getBookbyMS(int MS) { using (var db = new booksEntities()) { var sach = db.SACH.Where(x => x.MA_SACH == MS).Select(x => x).FirstOrDefault(); var sachtacgia = db.SACH.Include("TAC_GIA"); var sachtheloai = db.SACH.Include("THE_LOAI"); var sachnxb = db.SACH.Include("NHA_XUAT_BAN"); if (sach != null) { return(sach); } return(null); } }
public static void addComment(int maSach, string Noidung) { using (var db = new booksEntities()) { Y_KIEN cmt = new Y_KIEN(); cmt.NOI_DUNG = Noidung; cmt.MA_SACH = maSach; cmt.NGAY = System.DateTime.Now; XtractModule xtract = new XtractModule(); cmt.DANH_GIA = xtract.getEvaluate(Noidung); var book = db.SACH.Where(s => s.MA_SACH == maSach).FirstOrDefault(); book.TONG_DANH_GIA += 1; book.DANH_GIA_TOT += cmt.DANH_GIA.Equals("tích cực") ? 1 : 0; db.Y_KIEN.Add(cmt); db.SaveChanges(); } }
public static List <ProductView> getTopBooksIncAuthorByCategory(String tentheloai) { using (var db = new booksEntities()) { List <ProductView> final = new List <ProductView>(); var query = from s in db.SACH select s; var BookAuthor = db.SACH.Include("TAC_GIA"); var tl = db.THE_LOAI.Where(t => t.TEN_THE_LOAI == tentheloai).Select(t => t.SACH).ToList(); if (tl.Count != 0) { var listMS = tl[0].Select(s => s.MA_SACH).ToArray(); var listB = BookAuthor.Where(s => listMS.Contains(s.MA_SACH)).Select(s => new { book = s, percent = s.TONG_DANH_GIA == 0 ? -1 : Math.Round((double)(s.DANH_GIA_TOT * 100.0 / s.TONG_DANH_GIA), 2) }); final = new List <ProductView>(); foreach (var pv in listB) { final.Add(new ProductView(pv.book, pv.percent)); } } return(final.OrderByDescending(x => x.percent).ToList()); } }
private int findTerm(string Term) { int result = 0; using (var db = new Emo_DictionaryEntities()) { result = db.SP_TimKiem(Term).FirstOrDefault().Value; if (result == 0) { using (var db1 = new booksEntities()) { var query = db1.TAC_GIA.Where(tg => tg.TEN_TAC_GIA == Term).ToList(); if (query.Count != 0) { result = 3; } } } } return(result); }
public static void UpdateBook(BookDetails bookdetails) { if (bookdetails == null) { return; } using (var db = new booksEntities()) { for (int index = 0; index < bookdetails.tg.Count; index++) { TAC_GIA tacgia = bookdetails.tg[index]; bookdetails.tg[index] = db.TAC_GIA.Where(x => x.TEN_TAC_GIA == tacgia.TEN_TAC_GIA).FirstOrDefault(); if (bookdetails.tg[index] == null) { addAuthor(tacgia.TEN_TAC_GIA.Trim()); bookdetails.tg[index] = db.TAC_GIA.Where(au => au.TEN_TAC_GIA.Contains(tacgia.TEN_TAC_GIA.Trim())).Select(tgia => tgia).FirstOrDefault(); } } for (int index = 0; index < bookdetails.tl.Count; index++) { THE_LOAI theloai = bookdetails.tl[index]; theloai = db.THE_LOAI.Where(x => x.MA_THE_LOAI == theloai.MA_THE_LOAI).FirstOrDefault(); bookdetails.tl[index] = theloai; } string manxb = bookdetails.nxb.MA_NXB; bookdetails.nxb = db.NHA_XUAT_BAN.Where(x => x.MA_NXB == manxb).FirstOrDefault(); var query = db.SACH.Where(x => x.MA_SACH == bookdetails.sach.MA_SACH).Select(x => x).FirstOrDefault(); var bookAuthor = db.SACH.Include("TAC_GIA"); var bookCate = db.SACH.Include("THE_LOAI"); if (query != null) { query.TEN_SACH = bookdetails.sach.TEN_SACH; query.NOI_DUNG = bookdetails.sach.NOI_DUNG; query.GIA = bookdetails.sach.GIA; if (bookdetails.sach.ANH != null) { query.ANH = bookdetails.sach.ANH; } if (query.TAC_GIA != bookdetails.tg) { foreach (TAC_GIA au in query.TAC_GIA) { au.SACH.Remove(query); } foreach (TAC_GIA au in bookdetails.tg) { au.SACH.Add(query); } } if (query.THE_LOAI != bookdetails.tl) { foreach (THE_LOAI cate in query.THE_LOAI) { cate.SACH.Remove(query); } foreach (THE_LOAI cate in bookdetails.tl) { cate.SACH.Add(query); } } db.SaveChanges(); } } }