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