public bool Edit(Book book) { Boolean res = false; using (var db = new BookContext()) { db.Entry(book).State = System.Data.EntityState.Modified; db.SaveChanges(); res = true; } return res; }
public bool Add(Book book) { Boolean res = false; using (var db = new BookContext()) { db.Books.Add(book); db.SaveChanges(); res = true; } return res; }
public Book Add(Book book) { _bookContext.Books.Add(book); _bookContext.SaveChanges(); return(book); }
public void UpdateBook(Book book) { _bookContext.Update(book); _bookContext.SaveChanges(); }
public void Insert(Author author) { db.Authors.Add(author); db.SaveChanges(); }
public Publisher Add(Publisher addPublisher) { _bookContext.Publishers.Add(addPublisher); _bookContext.SaveChanges(); return(addPublisher); }
public void CreateBook([FromBody] Book book) { db.Books.Add(book); db.SaveChanges(); }
public Publisher Add(Publisher newPublisher) { BookContext.Publishers.Add(newPublisher); BookContext.SaveChanges(); return(newPublisher); }
public T Add <T>(T t) where T : class { mBookContext.Set <T>().Add(t); mBookContext.SaveChanges(); return(t); }
public void AddBook(Book book) { db.Books.Add(book); db.SaveChanges(); }
public ActionResult CreateInvoice() { Invoice invoice = new Invoice { AgencyID = Convert.ToInt32(Request.Form["agencyID"].ToString()), Total = 0, Date = DateTime.Now, Description = Request.Form["Description"].ToString(), Status = true }; db.Invoices.Add(invoice); db.SaveChanges(); Session["agencyID"] = invoice.AgencyID; Session["invoiceID"] = invoice.ID; return(RedirectToAction("CreateDetails")); }
public string Save_book(Book book) { db.Books.Add(book); db.SaveChanges(); return("Dzieki," + " " + book.Name + " " + book.Author + " " + book.Price + ", zostala stworzona"); }
public void Create(Book book) { db.Books.Add(book); db.SaveChanges(); }
public void Add(Book entity) { _bookContext.Books.Add(entity); _bookContext.SaveChanges(); }
private void RemoveBookFromCart(int id) { //shoppingCart.Remove(db.Books.Find(id)); for (int i = 0; i < shoppingCart.Count; ++i) { if (shoppingCart[i].ID == id) { shoppingCart.RemoveAt(i); break; } } //------> Remove from cart function <----- var cart = db.ShoppingCart.Where(x => x.UserEmail.Equals(User.Identity.Name)).FirstOrDefault(); if (cart != null) { var item = cart.ShoppingCartItems.Where(x => x.Book.ID == id).First(); if (item != null) { cart.TotalPrice -= item.Book.Price; cart.ShoppingCartItems.Remove(item); db.ShoppingCartItems.Remove(item); db.SaveChanges(); } } //------> Remove from cart function <----- updateCartIcon(); }
// POST api/values public void Post([FromBody] Book book) { db.Add(book); db.SaveChanges(); }
public ActionResult Add(string title, string author, string genre, string year, string amount) { if (title == String.Empty || author == String.Empty || genre == String.Empty || year == String.Empty || amount == String.Empty) { ViewBag.ResultMessage = Resourses.strings.AllFieldsRequired; return(View("Result")); } int amount1; int year1; try { year1 = Int32.Parse(year); } catch (Exception ex) { Logger.WriteLog("LibAdminLog.txt", ex.Message); ViewBag.ResultMessage = Resourses.strings.YearInvalid; return(View("Result")); } try { amount1 = Int32.Parse(amount); if (amount1 < 1) { ViewBag.ResultMessage = Resourses.strings.AmountMustBeGreaterThan0; return(View("Result")); } } catch (Exception ex) { Logger.WriteLog("LibAdminLog.txt", ex.Message); ViewBag.ResultMessage = Resourses.strings.AmountInvalid; return(View("Result")); } Book book = new Book() { Amount = amount1, Title = title, Genre = genre, Year = year1, Author = author }; BookContext db = new BookContext(); try { db.Books.Add(book); db.SaveChanges(); ViewBag.ResultMessage = Resourses.strings.BookAdded; } catch (Exception ex) { Logger.WriteLog("LibAdminLog.txt", ex.Message); ViewBag.ResultMessage = Resourses.strings.AddingError; } finally { db.Dispose(); } return(View("Result")); }
public ActionResult ThanhToan(string name, string diachi, string sdt) { sdt = sdt.Trim(); var db = new BookContext(); var kh = Session["KhachHang"] as KhachHang; var lstItem = Session["cart"] as List <Item>; // insert khach hang if (kh == null) { KhachHang khachHang = db.KhachHang.Where(item => item.TaiKhoan.Equals(sdt)).FirstOrDefault(); if (khachHang == null) { kh = new KhachHang(); kh.HoTen = name; kh.NgaySinh = DateTime.Now; kh.TaiKhoan = sdt.Trim(); kh.MatKhau = "123456"; kh.LoaiKH = "Khách Hàng"; kh.flag = false; db.KhachHang.Add(kh); db.SaveChanges(); } else { kh = khachHang; } } // insert hoa don HoaDon hd = new HoaDon(); hd.NgayTao = DateTime.Now; hd.DaThanhToan = false; hd.MaKH = kh.MaKH; hd.TongTien = lstItem.Sum(item => item.Quantity * item.sach.GiaBan); hd.SDT = sdt; hd.DiaChi = diachi; hd.flag = false; hd.DaGiaoHang = false; hd.TrangThai = 1; db.HoaDon.Add(hd); db.SaveChanges(); foreach (Item item in lstItem) { ChiTietHoaDon cthd = new ChiTietHoaDon(); cthd.MaDonHang = hd.MaDonHang; cthd.MaSach = item.sach.MaSach; cthd.SoLuong = item.Quantity; cthd.ThanhTien = item.sach.GiaBan * item.Quantity; cthd.flag = false; db.ChiTietHoaDon.Add(cthd); } // insert log Log log = new Log(); log.flag = false; log.ThoiGian = DateTime.Now; log.TaiKhoan = kh.TaiKhoan; log.TacVu = "Admin"; log.HanhDong = "Đã mua sách với hóa đơn có mã: " + hd.MaDonHang; db.Log.Add(log); db.SaveChanges(); //Get Config Info string vnp_Returnurl = ConfigurationManager.AppSettings["vnp_Returnurl"]; //URL nhan ket qua tra ve string vnp_Url = ConfigurationManager.AppSettings["vnp_Url"]; //URL thanh toan cua VNPAY string vnp_TmnCode = ConfigurationManager.AppSettings["vnp_TmnCode"]; //Ma website string vnp_HashSecret = ConfigurationManager.AppSettings["vnp_HashSecret"]; //Chuoi bi mat //Get payment input OrderInfo orderInfo = new OrderInfo(); //Save order to db orderInfo.OrderId = hd.MaDonHang; orderInfo.Amount = Convert.ToDecimal(hd.TongTien); orderInfo.OrderDescription = hd.DiaChi; orderInfo.CreatedDate = DateTime.Now; //Build URL for VNPAY VnPayLibrary vnpay = new VnPayLibrary(); vnpay.AddRequestData("vnp_Version", "2.0.0"); vnpay.AddRequestData("vnp_Command", "pay"); vnpay.AddRequestData("vnp_TmnCode", vnp_TmnCode); string locale = "vn"; if (!string.IsNullOrEmpty(locale)) { vnpay.AddRequestData("vnp_Locale", locale); } else { vnpay.AddRequestData("vnp_Locale", "vn"); } vnpay.AddRequestData("vnp_CurrCode", "VND"); vnpay.AddRequestData("vnp_TxnRef", orderInfo.OrderId.ToString()); vnpay.AddRequestData("vnp_OrderId", hd.MaDonHang.ToString()); vnpay.AddRequestData("vnp_OrderInfo", hd.MaDonHang.ToString()); vnpay.AddRequestData("vnp_OrderType", "other"); //default value: other vnpay.AddRequestData("vnp_Amount", Math.Round(orderInfo.Amount * 100).ToString()); vnpay.AddRequestData("vnp_ReturnUrl", vnp_Returnurl); vnpay.AddRequestData("vnp_IpAddr", Utils.GetIpAddress()); vnpay.AddRequestData("vnp_CreateDate", orderInfo.CreatedDate.ToString("yyyyMMddHHmmss")); //if (bank.SelectedItem != null && !string.IsNullOrEmpty(bank.SelectedItem.Value)) //{ vnpay.AddRequestData("vnp_BankCode", "NCB"); //} string paymentUrl = vnpay.CreateRequestUrl(vnp_Url, vnp_HashSecret); Debug.WriteLine("VNPAY URL: {0}", paymentUrl); Session["cart"] = new List <Item>(); return(Redirect(paymentUrl)); //return RedirectToAction("Success"); }
public ActionResult Edit(UserModel user) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Users")); }
public static void SeedDatabaseDummyBooks(this BookContext context, int numBooks = 10) { context.Books.AddRange(CreateDummyBooks(numBooks)); context.SaveChanges(); }
public IActionResult CreateReader(Reader reader) { _bookContext.Readers.Add(reader); _bookContext.SaveChanges(); return(RedirectToAction("Index")); }
public static void SeedDatabaseFourBooks(this BookContext context) { context.Books.AddRange(CreateFourBooks()); context.SaveChanges(); }
public void Save() { _context.SaveChanges(); }
public int CreateBook(Book book) { _db.Books.Add(book); return(_db.SaveChanges()); }
public ActionResult Edit(Book book) { db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public void Add(Book book) { _bookContext.Books.Add(book); _bookContext.SaveChanges(); }
static void Main(string[] args) { Console.WriteLine("CRUD operatios."); Console.WriteLine("Create."); using (var db = new BookContext()) { db.Books.Add(new Book { Name = "1984", Author = "Orwell", Price = 19.95M, Count = 15 }); db.Books.Add(new Book { Name = "Lolita", Author = "Nabokov", Price = 59.99M, Count = 47 }); db.Books.Add(new Book { Name = "Sherlock Holmes", Author = "Doyle", Price = 9.99M, Count = 1 }); db.SaveChanges(); } Console.WriteLine("Read."); int i = 1; Console.WriteLine($"#. Book\t\t\t\t\tCount\tPrice\tTotalvalue"); using (var db = new BookContext()) foreach (var b in db.Books) { Console.WriteLine($"{i++}. {b.Name} - {b.Author}\t\t\t{b.Count}\t{b.Price}\t{(b.Count * b.Price).ToString("#0.00")}"); } Console.WriteLine("Update."); using (var db = new BookContext()) { db.Books.FirstOrDefault(x => x.Author == "Orwell").Price = 22.45M; db.SaveChanges(); } Console.WriteLine("Update in other context #1"); Book book = null; using (var db = new BookContext()) book = db.Books.FirstOrDefault(x => x.Author == "Nabokov"); using (var db = new BookContext()) { book.Count--; db.Entry(book).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } Console.WriteLine("Update in other context #2"); using (var db = new BookContext()) book = db.Books.FirstOrDefault(x => x.Author == "Orwell"); using (var db = new BookContext()) { db.Books.Attach(book); book.Price = 19.45M; db.SaveChanges(); } Console.WriteLine("Delete (deleting from othet context also works)."); using (var db = new BookContext()) { var b = db.Books.FirstOrDefault(x => x.Author == "Doyle"); db.Books.Remove(b); db.SaveChanges(); } Console.WriteLine("Read again."); i = 1; Console.WriteLine($"#. Book\t\t\t\t\tCount\tPrice\tTotal value"); using (var db = new BookContext()) foreach (var b in db.Books) { Console.WriteLine($"{i++}. {b.Name} - {b.Author}\t\t\t{b.Count}\t{b.Price}\t{(b.Count * b.Price).ToString("#0.00")}"); } Console.ReadLine(); }
public IActionResult Order(int id) { var CurentUserId = User.FindFirstValue(ClaimTypes.NameIdentifier); var Order = _context.Orders.SingleOrDefault(o => o.UserId == CurentUserId && !o.IsFainaly); if (Order == null) { var details = new Order { CreateDate = DateTime.Now, Sum = 0, IsFainaly = false, UserId = CurentUserId, }; _context.Add(details); _context.SaveChanges(); _context.Add(new OrdeeDetails { OrderId = details.OrderId, Price = _context.BookStors.Find(id).Price, Count = 1, BookId = id }); _context.SaveChanges(); SumOrder(details.OrderId); } else { var Detail = _context.OrdeeDetails.SingleOrDefault(d => d.OrderId == Order.OrderId && d.BookId == id); if (Detail == null) { _context.Add(new OrdeeDetails { OrderId = Order.OrderId, Price = _context.BookStors.Find(id).Price, Count = 1, BookId = id }); } else { Detail.Count += 1; _context.Update(Detail); SumOrder(Detail.OrderId); } _context.SaveChanges(); } return(RedirectToAction("ShowOrder")); }
public Author Add(Author addAuthor) { _bookContext.Authors.Add(addAuthor); _bookContext.SaveChanges(); return(addAuthor); }
public void Add(Book entity) { var response = bookContext.Add(entity); bookContext.SaveChanges(); }
public async Task <IActionResult> CreateBorrowBook(BorrowBook borrow) { var date = DateTime.Today.Month; var timesBorrow = _context.BorrowBooks.Where(x => x.UserId == borrow.UserId && x.BorrowDate.Month == date); if (timesBorrow.Count() > 2) { return(BadRequest("Ban da het lan muon trong thang")); } var items = 0; foreach (var i in timesBorrow) { var val = _context.BorrowBookDetails.Where(x => x.BorrowBookId == i.BorrowBookId).Sum(x => x.Quantity); items += val; } if (items >= 5) { return(BadRequest("Bạn đã hết số lần mượn trong tháng")); } if (borrow.BorrowBookDetails != null && borrow.BorrowBookDetails.Any()) { var borrowed = borrow.BorrowBookDetails.Sum(x => x.Quantity); if (borrowed > 5) { return(BadRequest("Ban chi duoc muon it hon 5 quyen")); } if ((borrowed + items) > 5) { return(BadRequest("Ban chi dc muon it hon" + (5 - borrowed))); } var newborrow = new BorrowBook { BorrowDate = borrow.BorrowDate, Status = borrow.Status, UserId = borrow.UserId }; _context.BorrowBooks.Add(newborrow); _context.SaveChanges(); var id = newborrow.BorrowBookId; foreach (var itemdetail in borrow.BorrowBookDetails) { var detail = new BorrowBookDetail { BorrowBookId = id, BookId = itemdetail.BookId, Quantity = itemdetail.Quantity }; _context.BorrowBookDetails.Add(detail); } await _context.SaveChangesAsync(); return(Ok("Successed!")); } return(BadRequest("Danh sach muon trong")); }
public IActionResult Add(Book disc) { db.Books.Add(disc); db.SaveChanges(); return(View()); }