public IActionResult DoUpdate(Hanghoa hh, IFormFile Hinh)
{
if (HttpContext.Session.Get <string>("user") != "*****@*****.**")
{
return(RedirectToAction("Error", "Administrator"));
}
Hanghoa des = db.Hanghoa.Where(x => x.Mahh == hh.Mahh).SingleOrDefault();
if (Hinh != null)
{
string path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "images", Hinh.FileName);
using (var f = new FileStream(path, FileMode.Create))
{
Hinh.CopyTo(f);
}
hh.Hinh = Hinh.FileName;
}
des.Tenhh = hh.Tenhh;
des.Tenalias = hh.Tenalias;
des.Mota = hh.Mota;
des.Hinh = hh.Hinh;
des.Giamgia = hh.Giamgia;
des.Dongia = hh.Dongia;
des.Chitietloai = hh.Chitietloai;
des.Maloai = hh.Maloai;
des.Mancc = hh.Mancc;
des.Math = hh.Math;
des.Maxx = hh.Maxx;
des.Solanxem = hh.Solanxem;
des.Ngaysx = hh.Ngaysx;
db.SaveChanges();
ViewBag.status = "Cập nhật thành công.";
return(View("Update"));
}
public void Execute()
{
Hanghoa check = null;
using (var repo = new HanghoaViewRepository())
{
repo.HanghoaId = this.item.HanghoaId;
check = repo.Execute();
}
if (check != null) //đã tồn tại
{
using (var repo = new HanghoaUpdateRepository())
{
repo.item = this.item;
repo.Execute();
}
}
else
{
using (var repo = new HanghoaInsertRepository())
{
repo.item = this.item;
repo.Execute();
}
}
}
public static void SuaHangJoa(Hanghoa hh)
{
SqlConnection conn = SqlConnect.Connect();
SqlCommand cmd = new SqlCommand("SUA_HANG_HOA", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MA_HANG", SqlDbType.Int);
cmd.Parameters.Add("@TEN_HANG", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@MA_NUOC_SX", SqlDbType.Int);
cmd.Parameters.Add("@KICH_THUOC", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@MA_LOAI_HANG", SqlDbType.Int);
cmd.Parameters.Add("@DON_VI_TINH", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@LUONG_TON", SqlDbType.Int);
cmd.Parameters.Add("@MA_KHO", SqlDbType.Int);
cmd.Parameters["@MA_HANG"].Value = hh.Mahang;
cmd.Parameters["@TEN_HANG"].Value = hh.Tenhang;
cmd.Parameters["@MA_NUOC_SX"].Value = hh.Manuocsx;
cmd.Parameters["@KICH_THUOC"].Value = hh.Kichthuoc;
cmd.Parameters["@MA_LOAI_HANG"].Value = hh.Maloaihang;
cmd.Parameters["@DON_VI_TINH"].Value = hh.Donvitinh;
cmd.Parameters["@LUONG_TON"].Value = hh.Luongton;
cmd.Parameters["@MA_KHO"].Value = hh.Makho;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public Hanghoa Execute()
{
Hanghoa data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM Hanghoa WHERE HanghoaId = @HanghoaId";
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@HanghoaId", Value = this.HanghoaId, SqlDbType = System.Data.SqlDbType.NVarChar
});
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data = new Hanghoa
{
HanghoaId = Convert.ToString(reader["HanghoaId"].vSafe()),
TenHanghoa = Convert.ToString(reader["TenHanghoa"].vSafe()),
GiaBan = Convert.ToDouble(reader["GiaBan"].vSafe()),
Mota = Convert.ToString(reader["Mota"].vSafe()),
SoLuongTonKho = Convert.ToInt32(reader["SoLuongTonKho"].vSafe()),
NhomHanghoaId = Convert.ToString(reader["NhomHanghoaId"].vSafe())
};
}
}
}
conn.Close();
}
return(data);
}
public ActionResult DeleteConfirmed(int id)
{
Hanghoa hanghoa = db.Hanghoas.Find(id);
db.Hanghoas.Remove(hanghoa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaHangHoa,TenHangHoa,DonGia,DonViTinh,MaNCC")] Hanghoa hanghoa)
{
if (ModelState.IsValid)
{
db.Entry(hanghoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hanghoa));
}
public ActionResult Create([Bind(Include = "MaHangHoa,TenHangHoa,DonGia,DonViTinh,MaNCC")] Hanghoa hanghoa)
{
if (ModelState.IsValid)
{
db.Hanghoas.Add(hanghoa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hanghoa));
}
public ActionResult Edit([Bind(Include = "Mahanghoa,Tenhanghoa,Dongia,Donvitinh,MaNCC")] Hanghoa hanghoa)
{
if (ModelState.IsValid)
{
db.Entry(hanghoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNCC = new SelectList(db.NhaCCs, "MaNCC", "TenNCC", hanghoa.MaNCC);
ViewBag.Mahanghoa = new SelectList(db.NhapXuatTons, "Mahanghoa", "Mahanghoa", hanghoa.Mahanghoa);
return(View(hanghoa));
}
public IActionResult DoDelete(Hanghoa hh)
{
if (HttpContext.Session.Get <string>("user") != "*****@*****.**")
{
return(RedirectToAction("Error", "Administrator"));
}
db.Hanghoa.Remove(db.Hanghoa.Where(x => x.Mahh == hh.Mahh).SingleOrDefault());
db.SaveChanges();
ViewBag.status = "Đã xóa thành công.";
return(View("Delete"));
}
public ActionResult Edit([Bind(Include = "Ma_HH,Ma_NCC,Ma_NH,Ten_HH")] Hanghoa hanghoa)
{
if (ModelState.IsValid)
{
db.Entry(hanghoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Ma_NCC = new SelectList(db.Nhacungcaps, "Ma_NCC", "Ten_NCC", hanghoa.Ma_NCC);
ViewBag.Ma_NH = new SelectList(db.Nhomhangs, "Ma_NH", "Ten_NH", hanghoa.Ma_NH);
return(View(hanghoa));
}
public IActionResult AddToCart(string tenhh, int soluong)
{
//lấy giỏ hàng đang có
List <CartItem> gioHang = Carts;
//kiểm tra xem hàng đã có trong giỏ chưa
CartItem item = gioHang.SingleOrDefault(p => p.Tensp == tenhh);
//nếu có
if (item != null)
{
item.Soluong += soluong;//tăng số lượng
item.ThanhTien = item.Dongia * item.Soluong;
}
else
{
Hanghoa hh = db.Hanghoa.SingleOrDefault(p => p.Tenhh.Contains(tenhh));
if (hh.Giamgia != 0)
{
item = new CartItem
{
Masp = hh.Mahh,
Soluong = soluong,
Tensp = hh.Tenhh,
Tenalias = hh.Tenalias,
Hinh = hh.Hinh,
Giamgia = (float)hh.Giamgia,
Dongia = (float)(hh.Dongia - (hh.Dongia * hh.Giamgia / 100)),
ThanhTien = (float)(hh.Dongia - (hh.Dongia * hh.Giamgia / 100)) * soluong
}
}
;
else
{
item = new CartItem
{
Masp = hh.Mahh,
Soluong = soluong,
Tensp = hh.Tenhh,
Tenalias = hh.Tenalias,
Hinh = hh.Hinh,
Giamgia = 0,
Dongia = (float)hh.Dongia,
ThanhTien = (float)hh.Dongia * soluong
}
};
gioHang.Add(item);
}
//lưu session
HttpContext.Session.Set("gioHang", gioHang);
//chuyển tới trang giỏ hàng để xem
return(Json(Carts));
}
// GET: Admin/Hanghoas/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Hanghoa hanghoa = db.Hanghoas.Find(id);
if (hanghoa == null)
{
return(HttpNotFound());
}
return(View(hanghoa));
}
public List <Hanghoa> GetListHanghoa()
{
List <Hanghoa> list = new List <Hanghoa>();
string query = "SELECT * FROM HangTon";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Hanghoa hanghoa = new Hanghoa(item);
list.Add(hanghoa);
}
return(list);
}
public List <Hanghoa> SearchHanghoaByName(string Tenhang)
{
List <Hanghoa> list = new List <Hanghoa>();
string query = string.Format("SELECT * FROM HangTon WHERE Tenhang like N'%{0}%'", Tenhang);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Hanghoa hanghoa = new Hanghoa(item);
list.Add(hanghoa);
}
return(list);
}
// GET: Admin/Hanghoas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Hanghoa hanghoa = db.Hanghoas.Find(id);
if (hanghoa == null)
{
return(HttpNotFound());
}
ViewBag.Ma_NCC = new SelectList(db.Nhacungcaps, "Ma_NCC", "Ten_NCC", hanghoa.Ma_NCC);
ViewBag.Ma_NH = new SelectList(db.Nhomhangs, "Ma_NH", "Ten_NH", hanghoa.Ma_NH);
return(View(hanghoa));
}
// GET: Hanghoas/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Hanghoa hanghoa = db.Hanghoas.Find(id);
if (hanghoa == null)
{
return(HttpNotFound());
}
ViewBag.MaNCC = new SelectList(db.NhaCCs, "MaNCC", "TenNCC", hanghoa.MaNCC);
ViewBag.Mahanghoa = new SelectList(db.NhapXuatTons, "Mahanghoa", "Mahanghoa", hanghoa.Mahanghoa);
return(View(hanghoa));
}
public IActionResult DoCreate(Hanghoa hh, IFormFile Hinh)
{
if (HttpContext.Session.Get <string>("user") != "*****@*****.**")
{
return(RedirectToAction("Error", "Administrator"));
}
if (Hinh != null)
{
string path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "images", Hinh.FileName);
using (var f = new FileStream(path, FileMode.Create))
{
Hinh.CopyTo(f);
}
hh.Hinh = Hinh.FileName;
}
db.Hanghoa.Add(hh);
db.SaveChanges();
ViewBag.status = "Tạo mới thành công.";
return(View("Create"));
}
public static void addHangHoa(Hanghoa hh)
{
Hanghoa_DAO.ThemHangHoa(hh);
}
public static void updateHangHoa(Hanghoa hh)
{
Hanghoa_DAO.SuaHangJoa(hh);
}
