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