public async Task <ActionResult <TblBook> > PostTblBook(TblBook tblBook) { _context.TblBook.Add(tblBook); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblBook", new { id = tblBook.IdBook }, tblBook)); }
public async Task <IActionResult> PutTblBook(int id, TblBook tblBook) { if (id != tblBook.IdBook) { return(BadRequest()); } _context.Entry(tblBook).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblBookExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult BookAdd(TblBook p) { var ctg = db.TblCategory.Where(c => c.ID == p.TblCategory.ID).FirstOrDefault(); var wrt = db.TblWriter.Where(w => w.ID == p.TblWriter.ID).FirstOrDefault(); p.TblCategory = ctg; p.TblWriter = wrt; db.TblBook.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult BookUpdate(TblBook p) { var book = db.TblBook.Find(p.ID); book.Name = p.Name; book.PritingYear = p.PritingYear; book.PagesNumber = p.PagesNumber; book.Publisher = p.Publisher; var ctg = db.TblCategory.Where(c => c.ID == p.TblCategory.ID).FirstOrDefault(); var wrt = db.TblWriter.Where(w => w.ID == p.TblWriter.ID).FirstOrDefault(); book.Category = ctg.ID; book.Writer = wrt.ID; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed([Bind(Include = "BookId,Title,CategoryId,PublisherId,AuthorId,Summary,ImgUrl,Price,Quantity,CreatedDate,ModifieldDate,IsActive")] TblBook tblBook) { HttpClient cl = new HttpClient(); cl.BaseAddress = new Uri("http://localhost:5383/Api/Books/"); cl.DefaultRequestHeaders.Accept.Clear(); cl.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); var resp = cl.DeleteAsync("" + tblBook.BookId).Result; if (resp.IsSuccessStatusCode) { return(RedirectToAction("Index")); } else { return(View()); } }
public ActionResult Create([Bind(Include = "BookId,Title,CategoryId,PublisherId,AuthorId,Summary,ImgUrl,Price,Quantity,CreatedDate,ModifieldDate,IsActive")] TblBook tblBook, HttpPostedFileBase upload) { if (ModelState.IsValid) { if (upload != null && upload.ContentLength > 0) { string fn = System.IO.Path.GetFileName(upload.FileName); string SaveLocation = Server.MapPath("~/Content/Images/Products/") + fn; upload.SaveAs(SaveLocation); tblBook.ImgUrl = fn; } else { tblBook.ImgUrl = "noimage.gif"; } HttpClient cl = new HttpClient(); cl.BaseAddress = new Uri("http://localhost:5383/Api/Books/"); cl.DefaultRequestHeaders.Accept.Clear(); cl.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); string json = JsonConvert.SerializeObject(tblBook); StringContent content = new StringContent(json, Encoding.UTF8, "application/json"); var resp = cl.PostAsync("", content).Result; if (resp.IsSuccessStatusCode) { return(RedirectToAction("Index")); } else { return(View()); } } ViewBag.AuthorId = new SelectList(GetAut(), "AuthorId", "AuthorName"); ViewBag.CategoryId = new SelectList(GetTop(), "CategoryId", "CategoryName"); ViewBag.PublisherId = new SelectList(GetPub(), "PublisherId", "PublisherName"); return(View(tblBook)); }
public int Edit(TblBook book) { return(objBook.UpdateBook(book)); }
public int Create(TblBook book) { return(objBook.AddBook(book)); }