public ActionResult Edit([Bind(Include = "Hang_Hoa_id,Phieu_Nhap_Id,Don_gia,So_Luong")] Phieu_Nhap_Hang_Hoa phieu_Nhap_Hang_Hoa)
{
if (ModelState.IsValid)
{
db.Entry(phieu_Nhap_Hang_Hoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Phieu_Nhap_Id = new SelectList(db.Phieu_Nhap, "Phieu_Nhap_Id", "Phieu_Nhap_Id", phieu_Nhap_Hang_Hoa.Phieu_Nhap_Id);
ViewBag.Hang_Hoa_id = new SelectList(db.Hang_Hoa, "Hang_Hoa_Id", "Ten_Hang_Hoa", phieu_Nhap_Hang_Hoa.Hang_Hoa_id);
return(View(phieu_Nhap_Hang_Hoa));
}
private void tilSuaNV_Click(object sender, EventArgs e)
{
var nv = nHANVIENBindingSource1.Current as NHANVIEN;
if (nv != null)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
using (fThemSuaNV frmSua = new fThemSuaNV(nv))
{
frmSua.ShowDialog();
NHANVIEN NV = frmSua.NhanVienInfo;
nv.hoten = NV.hoten;
nv.ngaysinh = NV.ngaysinh;
nv.madonvi = NV.madonvi;
nv.chuvu = NV.chuvu;
db.NHANVIENs.Attach(nv);
db.Entry(nv).State = EntityState.Modified;
db.SaveChanges();
LoadNhanVien();
}
}
}
else
{
MessageBox.Show("Test");
}
}
private void btnHxT_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var hangxuat = hANGXUATBindingSource.Current as HANGXUAT;
var hk = db.HANGHOAs.Where(x => x.ma == hangxuat.maHang).SingleOrDefault();
if (hangxuat.Slxuat <= hk.soluong)
{
db.HANGXUATs.Add(hangxuat);
hk.soluong -= hangxuat.Slxuat;
db.HANGHOAs.Attach(hk);
db.Entry(hk).State = EntityState.Modified;
db.SaveChanges();
LoadHangXuat();
}
else
{
MetroMessageBox.Show(this, "Số lượng xuất ra vượt quá số lượng còn trong kho", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var hh = hANGHOABindingSource1.Current as HANGHOA;
var HH = db.HANGHOAs.SingleOrDefault(x => x.ma == hh.ma);
if (HH != null)
{
HH.tenhang = hh.tenhang;
HH.soluong = hh.soluong;
HH.thoigianbaohanh = hh.thoigianbaohanh;
HH.mota = hh.mota;
HH.manhom = hh.manhom;
db.HANGHOAs.Attach(HH);
db.Entry(HH).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return;
}
LoadHangHoa();
}
}
public ActionResult Edit([Bind(Include = "Nha_Cung_Cap_Id,Ten_Nha_Cung_Cap")] Nha_Cung_Cap nha_Cung_Cap)
{
if (ModelState.IsValid)
{
db.Entry(nha_Cung_Cap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nha_Cung_Cap));
}
public ActionResult Edit([Bind(Include = "Loai_Sp_Id,Ten_Loai")] Loai_SP loai_SP)
{
if (ModelState.IsValid)
{
db.Entry(loai_SP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loai_SP));
}
public bool ThemPhieuNhapHH(int ma_phieu, Phieu_Nhap_Json pn)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
var pnhh = new Phieu_Nhap_Hang_Hoa();
pnhh.Phieu_Nhap_Id = ma_phieu;
pnhh.Don_gia = pn.Don_gia;
pnhh.So_Luong = pn.So_Luong;
pnhh.Hang_Hoa_id = pn.Hang_Hoa_id;
db.Phieu_Nhap_Hang_Hoa.Add(pnhh);
var kho = db.Kho_Chua.Find(pnhh.Hang_Hoa_id);
if (kho != null)
{
kho.So_Luong += pnhh.So_Luong;
db.Entry(kho).State = System.Data.Entity.EntityState.Modified;
}
else
{
kho = new Kho_Chua();
kho.Hang_Hoa_Id = pnhh.Hang_Hoa_id;
kho.So_Luong = pnhh.So_Luong;
db.Entry(kho).State = System.Data.Entity.EntityState.Added;
}
db.SaveChanges();
tran.Commit();
return(true);
}catch (Exception)
{
tran.Rollback();
return(false);
}
}
}
}
public ActionResult Edit([Bind(Include = "Hang_Hoa_Id,Ten_Hang_Hoa,Ma_Loai,IsActive,Nha_Cung_Cap_Id")] Hang_Hoa hang_Hoa)
{
if (ModelState.IsValid)
{
db.Entry(hang_Hoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Ma_Loai = new SelectList(db.Loai_SP, "Loai_Sp_Id", "Ten_Loai", hang_Hoa.Ma_Loai);
ViewBag.Nha_Cung_Cap_Id = new SelectList(db.Nha_Cung_Cap, "Nha_Cung_Cap_Id", "Ten_Nha_Cung_Cap", hang_Hoa.Nha_Cung_Cap_Id);
return(View(hang_Hoa));
}
private void btnSuaDonVi_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var dv = dONVIBindingSource1.Current as DONVI;
var Dvd = db.DONVIs.SingleOrDefault(x => x.ma == dv.ma);
if (Dvd != null)
{
Dvd.tendonvi = dv.tendonvi;
Dvd.chucnang = dv.chucnang;
db.DONVIs.Attach(Dvd);
db.Entry(Dvd).State = EntityState.Modified;
db.SaveChanges();
LoadDonVi();
}
}
}
private void btnHxS_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var xh = hANGXUATBindingSource.Current as HANGXUAT;
var XH = db.HANGXUATs.SingleOrDefault(x => x.Spxuat == xh.Spxuat);
if (XH != null)
{
XH.maHang = xh.maHang;
XH.maNV = xh.maNV;
XH.Slxuat = xh.Slxuat;
db.HANGXUATs.Attach(XH);
db.Entry(XH).State = EntityState.Modified;
db.SaveChanges();
LoadHangXuat();
}
}
}
public ActionResult ProfileUser(UserProfile profile)
{
using (var db = new QuanLyKhoEntities())
{
int?id = db.Table_User.Where(x => x.UserName == User.Identity.Name).FirstOrDefault().UserId;
if (id != null)
{
var user = db.UserProfiles.Find(id);
user.Address = profile.Address;
user.Name = profile.Name;
user.Sex = profile.Sex;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
return(HttpNotFound());
}
}
return(RedirectToAction("Index", "Hang_Hoa"));
}
public ActionResult ChanUser(string UserName, int Role)
{
int id = ManagerLogin.GetId(UserName);
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var tk = db.Table_User.Find(id);
if (tk.IsActive == true)
{
tk.IsActive = false;
}
else if (tk.IsActive == false)
{
tk.IsActive = true;
}
db.Entry(tk).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ListUser"));
}
}
private void btnSuaHN_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var hn = hANGNHAPBindingSource.Current as HANGNHAP;
var HN = db.HANGNHAPs.SingleOrDefault(x => x.Spnhap == hn.Spnhap);
if (HN != null)
{
HN.maHang = hn.maHang;
HN.Slchungtu = hn.Slchungtu;
HN.Slthucnhap = hn.Slthucnhap;
HN.Sphieubaohang = hn.Sphieubaohang;
db.HANGNHAPs.Attach(HN);
db.Entry(HN).State = EntityState.Modified;
db.SaveChanges();
LoadHangNhap();
}
}
}
private void btnNhapHN_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var hangnhap = hANGNHAPBindingSource.Current as HANGNHAP;
db.HANGNHAPs.Add(hangnhap);
db.SaveChanges();
var hanghoa = db.HANGHOAs.Where(x => x.ma == hangnhap.maHang).SingleOrDefault();
if (hanghoa != null)
{
hanghoa.soluong += hangnhap.Slthucnhap;
db.HANGHOAs.Attach(hanghoa);
db.Entry(hanghoa).State = EntityState.Modified;
db.SaveChanges();
}
LoadHangNhap();
}
}
private void btnSuaNhomHang_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var nh = nHOMHANGBindingSource.Current as NHOMHANG;
var NH = db.NHOMHANGs.SingleOrDefault(x => x.ma == nh.ma);
if (NH != null)
{
NH.tennhom = txtTenNhom.Text;
NH.tacdung = txtTacDung.Text;
db.NHOMHANGs.Attach(NH);
db.Entry(NH).State = EntityState.Modified;
db.SaveChanges();
LoadNhomHang();
MetroMessageBox.Show(this, "Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
return;
}
}
}
private void btnPxS_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var px = pHIEUXUATBindingSource.Current as PHIEUXUAT;
var PX = db.PHIEUXUATs.FirstOrDefault(x => x.Spxuat == px.Spxuat);
if (PX != null)
{
PX.lydoxuat = px.lydoxuat;
PX.maNV = px.maNV;
PX.ngayxuat = px.ngayxuat;
db.PHIEUXUATs.Attach(PX);
db.Entry(PX).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return;
}
LoadPhieuXuat();
}
}
private void btnSuaPN_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var xPN = pHIEUNHAPBindingSource.Current as PHIEUNHAP;
var xpn = db.PHIEUNHAPs.FirstOrDefault(x => x.Spnhap == xPN.Spnhap);
if (xpn != null)
{
xpn.lydonhap = xPN.lydonhap;
xpn.maNCC = xPN.maNCC;
xpn.maNV = xPN.maNV;
xpn.ngaynhap = xPN.ngaynhap;
db.PHIEUNHAPs.Attach(xpn);
db.Entry(xpn).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return;
}
LoadPhieuNhap();
}
}
private void btnSuaNCC_Click(object sender, EventArgs e)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var ncc = nHACUNGCAPBindingSource1.Current as NHACUNGCAP;
var NCC = db.NHACUNGCAPs.SingleOrDefault(x => x.ma == ncc.ma);
if (NCC != null)
{
NCC.tenNCC = txtTenNCC.Text;
NCC.sodienthoai = txtSDTNCC.Text;
NCC.diachi = txtDiaChiNCC.Text;
db.NHACUNGCAPs.Attach(NCC);
db.Entry(NCC).State = EntityState.Modified;
db.SaveChanges();
LoadNhaCungCap();
}
else
{
MetroMessageBox.Show(this, "Sửa thất bại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
