public int UpdateKM(long idKM, KhuyenMai km, HttpPostedFileBase hinhAnh, double phanTram)
{
if (km.NgayKT <= km.NgayBD)
{
return(0);
}
else
{
KhuyenMai newKM = db.KhuyenMais.Find(idKM);
newKM.TenKhuyenMai = km.TenKhuyenMai;
newKM.PhanTram = phanTram;
newKM.NgayKT = km.NgayKT;
newKM.flag = true;
string path = "";
if (hinhAnh != null)
{
if (hinhAnh.ContentLength > 0)
{
string fileName = Path.GetFileName(hinhAnh.FileName);
path = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileName);
hinhAnh.SaveAs(path);
//path= path.Replace("\","/");
newKM.HinhKhuyenMai = fileName;
}
}
db.SaveChanges();
return(2);
}
}
public void UpdateSach(long idSach, Sach sach, HttpPostedFileBase anhBia, string chude, string ncc, string tg, string nxb, string km, HttpPostedFileBase anh1, HttpPostedFileBase anh2, double?chieuDai, double?chieuRong, double?chieuSau, string mota)
{
var newSach = db.Sachs.Find(idSach);
newSach.Ten = sach.Ten;
newSach.Gia = sach.Gia;
newSach.SoLuong = sach.SoLuong;
newSach.NamXuatBan = sach.NamXuatBan;
newSach.IdChuDe = Convert.ToInt64(chude);
newSach.ChuDe = db.ChuDes.Find(Convert.ToInt64(chude));
newSach.IdNCC = Convert.ToInt64(ncc);
newSach.NhaCungCap = db.NhaCungCaps.Find(Convert.ToInt64(ncc));
newSach.IdNXB = Convert.ToInt64(nxb);
newSach.NhaXuatBan = db.NhaXuatBans.Find(Convert.ToInt64(nxb));
newSach.IdTacGia = Convert.ToInt64(tg);
newSach.TacGia = db.TacGias.Find(Convert.ToInt64(tg));
newSach.HinhThuc = sach.HinhThuc;
newSach.MoTa = mota;
newSach.NgonNgu = sach.NgonNgu;
newSach.TrongLuong = sach.TrongLuong;
newSach.SoTrang = sach.SoTrang;
newSach.KickThuoc = chieuDai.ToString() + "x" + chieuRong.ToString() + "x" + chieuSau.ToString();
if (km != "0")
{
newSach.IdKhuyenMai = Convert.ToInt64(km);
newSach.KhuyenMai = db.KhuyenMais.Find(Convert.ToInt64(km));
}
else
{
newSach.IdKhuyenMai = 1;
newSach.KhuyenMai = db.KhuyenMais.Find(Convert.ToInt64(1));
}
GanAnhUpdate(newSach, anhBia, anh1, anh2);
db.SaveChanges();
}
public void UpdateCD(long idChuDe, ChuDe chuDe)
{
var cd = db.ChuDes.Find(idChuDe);
cd.Ten = chuDe.Ten;
cd.XuatXu = chuDe.XuatXu;
db.SaveChanges();
}
public void UpdateKH(long idKhachHang, KhachHang khachHang)
{
var kh = db.KhachHangs.Find(idKhachHang);
kh.Ho = khachHang.Ho;
kh.Ten = khachHang.Ten;
kh.NgaySinh = khachHang.NgaySinh;
kh.GioiTinh = khachHang.GioiTinh;
db.SaveChanges();
}
public IActionResult Create(Producer producer)
{
if (ModelState.IsValid)
{
_context.Add(producer);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(producer));
}
public void DeleteCTHD(long idCTHD)
{
ChiTietHoaDon CTHD = db.ChiTietHoaDon.Find(idCTHD);
db.ChiTietHoaDon.Remove(CTHD);
db.SaveChanges();
if (db.ChiTietHoaDon.Where(i => i.IdHoaDon == CTHD.IdHoaDon).Count() == 0)
{
db.HoaDon.Remove(db.HoaDon.Find(CTHD.IdHoaDon));
db.SaveChanges();
}
}
public string Buy(Purchase purchase)
{
purchase.Date = DateTime.Now;
db.Purchases.Add(purchase);
db.SaveChanges();
return("Спасибо," + purchase.Person + ", за покупку!");
}
public HomeController(ToyContext context)
{
db = context;
// добавляем начальные данные
if (db.Types.Count() != 0)
{
return;
}
var cat = new ToyType {
Name = "cat"
};
var lego = new ToyType {
Name = "lego"
};
var dog = new ToyType {
Name = "dog"
};
var mouse = new ToyType {
Name = "mouse"
};
var doll = new ToyType {
Name = "doll"
};
var toy1 = new Toy {
Name = "Grumpy Cat", Type = cat, Price = 599
};
var toy2 = new Toy {
Name = "Tom The Cat", Type = cat, Price = 499
};
var toy3 = new Toy {
Name = "Jerry The Mouse", Type = mouse, Price = 599
};
var toy4 = new Toy {
Name = "Mickey Mouse", Type = mouse, Price = 1099
};
var toy5 = new Toy {
Name = "Minnie Mouse", Type = mouse, Price = 399
};
var toy6 = new Toy {
Name = "Barbie", Type = doll, Price = 299
};
var toy7 = new Toy {
Name = "Ken", Type = doll, Price = 1199
};
var toy8 = new Toy {
Name = "Blue Sad Dog", Type = dog, Price = 899
};
var toy9 = new Toy {
Name = "Star Wars", Type = lego, Price = 199
};
var toy10 = new Toy {
Name = "Ninjago", Type = lego, Price = 299
};
db.Types.AddRange(cat, dog, lego, mouse, doll);
db.Toys.AddRange(toy1, toy2, toy3, toy4, toy5, toy6, toy7, toy8, toy9, toy10);
db.SaveChanges();
}
// GET: ChiTietSach
public ActionResult Index(long id)
{
ToyContext db = new ToyContext();
Sach sach = db.Sachs.Find(id);
sach.LuotXem++;
db.SaveChanges();
Session["CTSach"] = sach;
return(View("Index"));
}
public void UpdateTG(long idTacGia, TacGia tg, string moTa, HttpPostedFileBase hinhAnh)
{
var newTG = db.TacGias.Find(idTacGia);
newTG.Ten = tg.Ten;
newTG.MoTa = moTa;
string path = "";
if (hinhAnh != null)
{
if (hinhAnh.ContentLength > 0)
{
string fileName = Path.GetFileName(hinhAnh.FileName);
path = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileName);
hinhAnh.SaveAs(path);
//path= path.Replace("\","/");
newTG.HinhAnh = fileName;
}
}
db.SaveChanges();
}
public void UpdateNCC(long idNCC, NhaCungCap ncc, string moTa, HttpPostedFileBase hinhAnh)
{
var newNCC = db.NhaCungCaps.Find(idNCC);
newNCC.Ten = ncc.Ten;
newNCC.MoTa = moTa;
string path = "";
if (hinhAnh != null)
{
if (hinhAnh.ContentLength > 0)
{
string fileName = Path.GetFileName(hinhAnh.FileName);
path = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileName);
hinhAnh.SaveAs(path);
//path= path.Replace("\","/");
newNCC.HinhAnh = fileName;
}
}
db.SaveChanges();
}
public void ThanhToan(long idHD, string tenNguoiNhan, string diaChi, int sdt)
{
HoaDon hd = db.HoaDon.Find(idHD);
hd.NgayTao = DateTime.Today;
hd.TenNguoiNhan = tenNguoiNhan;
hd.DiaChi = diaChi;
hd.SDT = sdt.ToString();
hd.TinhTrangHoaDon = "Đã Thanh Toán";
double tongTien = 0;
foreach (var item in db.ChiTietHoaDon.Where(i => i.IdHoaDon == hd.IdHoaDon).ToList())
{
Sach sach = db.Sachs.Find(item.IdSach);
sach.SoLuong = sach.SoLuong - item.SoLuong;
db.SaveChanges();
tongTien = tongTien + item.ThanhTien;
}
hd.TinhTrangDonHang = "Đang Giao Hàng";
hd.TongTien = tongTien;
db.SaveChanges();
}
public ToysController(ToyContext context)
{
db = context;
if (!db.Toys.Any())
{
var toy1 = new Toy {
Name = "Grumpy Cat", Material = "cotton", Price = 599
};
var toy2 = new Toy {
Name = "Tom The Cat", Material = "cotton", Price = 499
};
var toy3 = new Toy {
Name = "Jerry The Mouse", Material = "synthetics", Price = 599
};
var toy4 = new Toy {
Name = "Mickey Mouse", Material = "plastic", Price = 1099
};
var toy5 = new Toy {
Name = "Minnie Mouse", Material = "plastic", Price = 399
};
var toy6 = new Toy {
Name = "Barbie", Material = "plastic", Price = 299
};
var toy7 = new Toy {
Name = "Ken", Material = "plastic", Price = 1199
};
var toy8 = new Toy {
Name = "Blue Sad Dog", Material = "cotton", Price = 899
};
var toy9 = new Toy {
Name = "Star Wars", Material = "plastic", Price = 199
};
var toy10 = new Toy {
Name = "Ninjago", Material = "plastic", Price = 299
};
var mat1 = new Material {
Name = "cotton"
};
var mat2 = new Material {
Name = "synthetic"
};
var mat3 = new Material {
Name = "plastic"
};
db.Materials.AddRange(mat1, mat2, mat3);
db.Toys.AddRange(toy1, toy2, toy3, toy4, toy5, toy6, toy7, toy8, toy9, toy10);
db.SaveChanges();
}
}
public ActionResult Add(Toy toy)
{
if (db.Toys.Contains(toy))
{
return(BadRequest());
}
if (!db.ToyTypes.Contains(toy.Type))
{
db.ToyTypes.Add(toy.Type);
}
toy.CreationDate = DateTime.Now;
db.Toys.Add(toy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public KhachHang UpdateTK(long idtaikhoan, string email, string newpassword, string newrepassword, string ho, string ten, DateTime ngaysinh, int gioitinh)
{
KhachHang kh = db.KhachHangs.Find(idtaikhoan);
kh.Ho = ho;
kh.Ten = ten;
kh.NgaySinh = ngaysinh;
if (gioitinh == 0)
{
kh.GioiTinh = true;
}
else
{
kh.GioiTinh = false;
}
if (String.IsNullOrEmpty(newpassword) == false && String.IsNullOrEmpty(newrepassword) == false && newpassword == newrepassword)
{
kh.Password = newpassword;
}
db.SaveChanges();
return(kh);
}
public ActionResult Giao(long idHD)
{
var tk = Session["TaiKhoan"] as KhachHang;
if (tk == null)
{
return(View("../Login/Index"));
}
else
{
if (tk.LoaiTK != "Admin")
{
return(View("../Home/Index"));
}
else
{
var db = new ToyContext();
db.HoaDon.Find(idHD).TinhTrangDonHang = "Đã Giao Hàng";
db.SaveChanges();
return(RedirectToAction("Reset", "HoaDon", new { area = "Admin" }));
}
}
}
public void Save()
{
_context.SaveChanges();
}
