public BookDetails(SACH sach, List <TAC_GIA> tg, List <THE_LOAI> tl, NHA_XUAT_BAN nxb) { this.sach = sach; this.tg = tg; this.tl = tl; this.nxb = nxb; }
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 async Task <IHttpActionResult> PutNHA_XUAT_BAN(long id, NHA_XUAT_BAN nHA_XUAT_BAN) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != nHA_XUAT_BAN.MA_NXB) { return(BadRequest()); } db.Entry(nHA_XUAT_BAN).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!NHA_XUAT_BANExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// PUT api/NhaXuatBan/5 public IHttpActionResult PutNHA_XUAT_BAN(long id, NHA_XUAT_BAN nha_xuat_ban) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != nha_xuat_ban.MA_NXB) { return(BadRequest()); } db.Entry(nha_xuat_ban).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!NHA_XUAT_BANExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(long id) { NHA_XUAT_BAN nha_xuat_ban = db.NHA_XUAT_BAN.Find(id); db.NHA_XUAT_BAN.Remove(nha_xuat_ban); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MA_NXB,TEN_NXB")] NHA_XUAT_BAN nha_xuat_ban) { if (ModelState.IsValid) { db.Entry(nha_xuat_ban).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(nha_xuat_ban)); }
public ActionResult Create([Bind(Include = "MA_NXB,TEN_NXB")] NHA_XUAT_BAN nha_xuat_ban) { if (ModelState.IsValid) { db.NHA_XUAT_BAN.Add(nha_xuat_ban); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(nha_xuat_ban)); }
public async Task <IHttpActionResult> GetNHA_XUAT_BAN(long id) { NHA_XUAT_BAN nHA_XUAT_BAN = await db.NHA_XUAT_BAN.FindAsync(id); if (nHA_XUAT_BAN == null) { return(NotFound()); } return(Ok(nHA_XUAT_BAN)); }
public RedirectToRouteResult AddPublisher(NHA_XUAT_BAN nxb) { var check = db.NHA_XUAT_BAN.Find(nxb.ID_NXB); if (check == null) { db.NHA_XUAT_BAN.Add(nxb); db.SaveChanges(); } return(RedirectToRoute(new { controller = "Publisher", action = "Index" })); }
public IHttpActionResult GetNHA_XUAT_BAN(long id) { NHA_XUAT_BAN nha_xuat_ban = db.NHA_XUAT_BAN.Find(id); if (nha_xuat_ban == null) { return(NotFound()); } return(Ok(nha_xuat_ban)); }
public RedirectToRouteResult EditPublisher(NHA_XUAT_BAN ncc) { var load = db.NHA_XUAT_BAN.Where(e => e.ID_NXB == ncc.ID_NXB).SingleOrDefault(); load.Ten_NXB = ncc.Ten_NXB; load.Email = ncc.Email; load.DiaChi = ncc.DiaChi; load.SDT = ncc.SDT; db.SaveChanges(); return(RedirectToRoute(new { controller = "Publisher", action = "Index" })); }
public IHttpActionResult PostNHA_XUAT_BAN(NHA_XUAT_BAN nha_xuat_ban) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.NHA_XUAT_BAN.Add(nha_xuat_ban); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = nha_xuat_ban.MA_NXB }, nha_xuat_ban)); }
public async Task <IHttpActionResult> PostNHA_XUAT_BAN(NHA_XUAT_BAN nHA_XUAT_BAN) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.NHA_XUAT_BAN.Add(nHA_XUAT_BAN); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = nHA_XUAT_BAN.MA_NXB }, nHA_XUAT_BAN)); }
// GET: /NhaXuatBan/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NHA_XUAT_BAN nha_xuat_ban = db.NHA_XUAT_BAN.Find(id); if (nha_xuat_ban == null) { return(HttpNotFound()); } return(View(nha_xuat_ban)); }
public async Task <IHttpActionResult> DeleteNHA_XUAT_BAN(long id) { NHA_XUAT_BAN nHA_XUAT_BAN = await db.NHA_XUAT_BAN.FindAsync(id); if (nHA_XUAT_BAN == null) { return(NotFound()); } db.NHA_XUAT_BAN.Remove(nHA_XUAT_BAN); await db.SaveChangesAsync(); return(Ok(nHA_XUAT_BAN)); }
public IHttpActionResult DeleteNHA_XUAT_BAN(long id) { NHA_XUAT_BAN nha_xuat_ban = db.NHA_XUAT_BAN.Find(id); if (nha_xuat_ban == null) { return(NotFound()); } db.NHA_XUAT_BAN.Remove(nha_xuat_ban); db.SaveChanges(); return(Ok(nha_xuat_ban)); }
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 ActionResult SaveUpdateBook(SACH sach, List <THE_LOAI> tl, List <TAC_GIA> tg, NHA_XUAT_BAN nxb, string TACGIA, string THELOAI) { if ("" != THELOAI) { if (tl == null) { tl = new List <THE_LOAI>(); } THE_LOAI cate = new THE_LOAI(); cate.MA_THE_LOAI = THELOAI; tl.Add(cate); } if ("" != TACGIA) { if (tg == null) { tg = new List <TAC_GIA>(); } TAC_GIA author = new TAC_GIA(); author.TEN_TAC_GIA = TACGIA; tg.Add(author); } try { if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/img/Books"), fileName); file.SaveAs(path); sach.ANH = "/img/Books/" + fileName; } } BookDetails book = new BookDetails(sach, tg, tl, nxb); BookContext.UpdateBook(book); } catch (Exception ex) { return(Content("<script>alert(" + ex.Message + ");</script>")); } return(RedirectToAction("Index")); }
public void Bll_AddNXB(NHA_XUAT_BAN nxb) { db.NHA_XUAT_BAN.Add(nxb); db.SaveChanges(); }