public NHATKINHAPSACH editNhatKiNhapSach(NHATKINHAPSACH nkns, int oldMaNhatKiNhapSach)
{
NHATKINHAPSACH nhatkinhapsach_re = (from c in entity.NHATKINHAPSACHes where c.STT == oldMaNhatKiNhapSach select c).FirstOrDefault();
int change;
if (nhatkinhapsach_re.SOLUONG > nkns.SOLUONG)
{
change = (int)(nhatkinhapsach_re.SOLUONG - nkns.SOLUONG);
KHO kho = (from c in entity.KHOes
where c.MASACH == nhatkinhapsach_re.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG - change;
}
else
{
change = (int)(nkns.SOLUONG - nhatkinhapsach_re.SOLUONG);
KHO kho = (from c in entity.KHOes
where c.MASACH == nhatkinhapsach_re.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG + change;
}
nhatkinhapsach_re.MASACH = nkns.MASACH;
//saveNhatKiNhapSach(nkns);
//deleteNhatKiNhapSach(nhatkinhapsach_re.STT);
nhatkinhapsach_re.NGAYNHAP = nkns.NGAYNHAP;
nhatkinhapsach_re.SOLUONG = nkns.SOLUONG;
entity.SaveChanges();
return(nhatkinhapsach_re); //nhatkinhapsach cu
}
private void tx_TextChanged(object sender, EventArgs e)
{
try
{
long value = long.Parse(txt.Text);
var ob = cb.SelectedItem;
if (ob.GetType().Name == "KHO")
{
KHO _e = DataInstance.Instance().DBContext().KHOes.Where(u => u.ID == value).First();
cb.SelectedItem = _e;
}
if (ob.GetType().Name == "NHA_CUNG_CAP")
{
NHA_CUNG_CAP _e = DataInstance.Instance().DBContext().NHA_CUNG_CAP.Where(u => u.ID == value).First();
cb.SelectedItem = _e;
}
if (ob.GetType().Name == "KHACH_HANG")
{
KHACH_HANG _e = DataInstance.Instance().DBContext().KHACH_HANG.Where(u => u.ID == value).First();
cb.SelectedItem = _e;
}
if (ob.GetType().Name == "HANG_HOA")
{
HANG_HOA _e = DataInstance.Instance().DBContext().HANG_HOA.Where(u => u.ID == value).First();
cb.SelectedItem = _e;
}
}
catch (Exception ex)
{
}
}
public ActionResult Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
KHO khuVuc = ctx.KHOes.Find(id);
if (khuVuc.ACTIVE.Equals("A"))
{
khuVuc.ACTIVE = "I";
khuVuc.UPDATE_AT = DateTime.Now;
khuVuc.UPDATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công."));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
}
private void cb_SelectedValueChanged(object sender, EventArgs e)
{
try
{
var ob = cb.SelectedItem;
if (ob.GetType().Name == "KHO")
{
KHO _e = (KHO)cb.SelectedItem;
txt.Text = _e.ID.ToString();
}
if (ob.GetType().Name == "NHA_CUNG_CAP")
{
NHA_CUNG_CAP _e = (NHA_CUNG_CAP)cb.SelectedItem;
txt.Text = _e.ID.ToString();
}
if (ob.GetType().Name == "KHACH_HANG")
{
KHACH_HANG _e = (KHACH_HANG)cb.SelectedItem;
txt.Text = _e.ID.ToString();
}
if (ob.GetType().Name == "HANG_HOA")
{
HANG_HOA _e = (HANG_HOA)cb.SelectedItem;
txt.Text = _e.ID.ToString();
}
txt.Select();
txt.SelectAll();
}
catch (Exception ex)
{
}
}
public bool suakho(string makho, string tenkho, string ghichu)
{
if (kTraKhoaChinh(makho) == 1)
{
List <KHO> list = loadKho();
KHO a = new KHO();
a = qlkho.KHOs.Where(bp => bp.MAKHO == makho.Trim()).FirstOrDefault();
a.TENKHO = tenkho;
a.GHICHU = ghichu;
foreach (KHO b in list)
{
if (b.MAKHO == makho)
{
qlkho.KHOs.DeleteOnSubmit(b);
qlkho.SubmitChanges();
}
}
qlkho.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
private void btnThemKho_Click(object sender, EventArgs e)
{
if (txtSP.Text == "" || txtDMSP.Text == "" || txtLoaiGiay.Text == "" || txtSOLUONG.Text == "" || txtTrangThai.Text == "")
{
MessageBox.Show("Không được để trống");
return;
}
KHO k = new KHO();
var kt = from s in db.KHOs where s.MASP == txtMaSP.Text && s.MADMSP == txtDMSP.Text && s.MALOAI == txtLoaiGiay.Text select s;
if (kt.Count() > 0)
{
MessageBox.Show("Trùng khóa chính");
return;
}
k.MASP = txtSP.Text;
k.MADMSP = txtDMSP.Text;
k.MALOAI = txtLoaiGiay.Text;
k.SOLUONG = Convert.ToInt16(txtSOLUONG.Text);
k.TRANGTHAI = txtTrangThai.Text;
db.KHOs.InsertOnSubmit(k);
db.SubmitChanges();
frm_kho_Load(sender, e);
MessageBox.Show("Thành công");
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
KHO khuVuc = ctx.KHOes.Find(id);
var nguoiDungList = (from s in ctx.NGUOI_DUNG
where s.ACTIVE == "A"
select s).ToList <NGUOI_DUNG>();
ViewBag.nguoiDungList = nguoiDungList;
if (khuVuc.ACTIVE.Equals("A"))
{
ctx.Dispose();
return(View(khuVuc));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult DeleteConfirmed(string id)
{
KHO kHO = db.KHOes.Find(id);
db.KHOes.Remove(kHO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void XoaKho(string Madv)
{
KHO d = new KHO();
d = qltg.KHOs.Where(t => t.MaKho == Madv).FirstOrDefault();
qltg.KHOs.DeleteOnSubmit(d);
qltg.SubmitChanges();
}
public void SuaKho(String MAKHO, string tenkho)
{
KHO d = new KHO();
d = qltg.KHOs.Where(t => t.MaKho == MAKHO).FirstOrDefault();
d.TenKho = tenkho;
qltg.SubmitChanges();
}
public KHO deleteKho(string MaKho)
{
KHO kho = (from c in entity.KHOes where c.MASACH == MaKho select c).FirstOrDefault();
entity.KHOes.Remove(kho);
entity.SaveChanges();
return(kho);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (btnThem.Text == "Thêm")
{
btnThem.Text = "Lưu";
btnSua.Enabled = false;
btnXoa.Text = "Hủy";
groupThongTin.Enabled = true;
dgvSACH.Enabled = false;
btnTimKiem.Enabled = false;
txtTimKiem.Enabled = false;
ClearControl();
return;
}
if (btnThem.Text == "Lưu")
{
if (Check())
{
btnThem.Text = "Thêm";
btnSua.Enabled = true;
btnXoa.Text = "Xóa";
groupThongTin.Enabled = false;
dgvSACH.Enabled = true;
btnTimKiem.Enabled = true;
txtTimKiem.Enabled = true;
try
{
SACH tg = getSACHByForm();
db.SACHes.Add(tg);
db.SaveChanges();
KHO kho = new KHO();
kho.SACHID = tg.ID;
kho.SOLUONG = 0;
db.KHOes.Add(kho);
db.SaveChanges();
MessageBox.Show("Thêm thông tin sách thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex) {
MessageBox.Show("Thêm thông tin sách thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
LoadDgvNhanVien();
}
return;
}
}
public void showSelected()
{
if (view.selectedKho != "")
{
KHO kho = repository.getKho(view.selectedKho);
ModelToView(kho);
//view.Kho = kho;
}
}
public void ThemKho(String MAKHO, string tenkho)
{
KHO dv = new KHO();
dv.MaKho = MAKHO;
dv.TenKho = tenkho;
qltg.KHOs.InsertOnSubmit(dv);
qltg.SubmitChanges();
}
private void btnThemChiTietNhap_Click(object sender, EventArgs e)
{
if (btnThemChiTietNhap.Text == "Thêm")
{
btnThemChiTietNhap.Text = "Lưu";
btnSuaChiTietNhap.Enabled = false;
btnXoaChiTietNhap.Text = "Hủy";
groupThongTinChiTietNhap.Enabled = true;
dgvChiTietNhap.Enabled = false;
panelPhieuNhap.Enabled = false;
ClearControlChiTietNhap();
return;
}
if (btnThemChiTietNhap.Text == "Lưu")
{
if (CheckChiTietNhap())
{
btnThemChiTietNhap.Text = "Thêm";
btnSuaChiTietNhap.Enabled = true;
btnXoaChiTietNhap.Text = "Xóa";
groupThongTinChiTietNhap.Enabled = false;
dgvChiTietNhap.Enabled = true;
panelPhieuNhap.Enabled = true;
try
{
CHITIETNHAP tg = getChiTietNhapByForm();
db.CHITIETNHAPs.Add(tg);
db.SaveChanges();
KHO kho = db.KHOes.Where(p => p.SACHID == tg.SACHID).FirstOrDefault();
kho.SOLUONG += tg.SOLUONG;
db.SaveChanges();
MessageBox.Show("Thêm thông tin Chi tiết nhập thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Thêm thông tin Chi tiết nhập thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
LoadDgvChiTietNhap();
UpdateDetailPhieuNhap();
}
return;
}
}
private KHO ViewToModel()
{
KHO kho = new KHO();
kho.MASACH = view.MASACH;
kho.SOLUONGCON = view.SOLUONGCON;
kho.TONGSOLUONG = view.TONGSOLUONG;
return(kho);
}
private void btnThem_Click(object sender, EventArgs e)
{
SANPHAM sanp = new SANPHAM();
SIZEGIAY size = new SIZEGIAY();
KHO k = new KHO();
int b = 0;
for (int i = 1; i <= dgv_sp.RowCount; i++)
{
b = i;
}
sanp.MASP = "SP" + (b + 1).ToString();
k.MASP = sanp.MASP;
k.SOLUONG = 0;
k.TRANGTHAI = cb_trangthaisp.Text.ToString();
size.MASP = sanp.MASP;
size.SIZE = 0;
size.SOLUONGSIZE = 0;
sanp.TENSP = cb_tensp.Text.ToString();
sanp.MAU = txt_mau.Text.ToString();
sanp.CHATLIEU = txt_chatlieu.Text.ToString();
sanp.TINHTRANGSP = cb_trangthai.Text.ToString();
sanp.MALOAI = cb_loaigiay.SelectedValue.ToString();
sanp.MANCC = cb_ncc.SelectedValue.ToString();
if (sp.ktkc_sp(sanp) == true)
{
if (sp.themsp(sanp) == true)
{
MessageBox.Show("thêm thành công");
usercontrol_sanpham_Load(sender, e);
if (sg.ktkc_sizegiay1(size) == true)
{
if (sg.themsizegiay(size) == true)
{
MessageBox.Show("thêm size giày thành công");
}
}
if (kh.ktkc_kho(k) == true)
{
if (kh.themkho(k) == true)
{
MessageBox.Show("thêm kho giày thành công");
}
}
usercontrol_sanpham_Load(sender, e);
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("sản phẩm này đã tồn tại");
}
}
private void btn_them_Click(object sender, EventArgs e)
{
MAIN mainForm = new MAIN();
maNhanVien = mainForm.getMaNhanVien();
List <NhaCungCap> listNhaCungCap = new List <NhaCungCap>();
List <NguyenLieu> listNguyenLieu = new List <NguyenLieu>();
listNhaCungCap = bus_nhaCungCap.LayNhaCungCap();
listNguyenLieu = bus_nguyenLieu.layNguyenLieu();
//TAO PHIEU NHAP
if (count == 0)
{
String maPhieuNhap = bus_phieuNhap.taoMa();
DateTime ngayLap = DateTime.Now.Date;
float tongTien = 0;
PhieuNhap phieunhap = new PhieuNhap(maPhieuNhap, ngayLap, tongTien, maNhanVien);
bus_phieuNhap.Them(phieunhap);
MessageBox.Show(ngayLap.ToString());
count++;
maPhieuNhapct = maPhieuNhap;
String maChiTietPhieuNhap = bus_chiTietPhieuNhap.taoMa();
String maNguyenLieu = listNguyenLieu[box_nguyenLieu.SelectedIndex].MaNguyenLieu;
int soLuong = Int32.Parse(txt_soLuong.Text.ToString());
String loaiDonVi = box_loaiDonVi.SelectedItem.ToString();
String id = bus_kho.taoMa();
KHO kho = new KHO(id, maNguyenLieu, soLuong, loaiDonVi);
listNhapKho.Add(kho);
String maNhaCungCap = listNhaCungCap[box_nhaCungCap.SelectedIndex].MaNhaCungCap;
ChiTietPhieuNhap chiTiet = new ChiTietPhieuNhap(maChiTietPhieuNhap, maNguyenLieu, soLuong, maNhaCungCap, maPhieuNhapct);
bus_chiTietPhieuNhap.Them(chiTiet);
}
else
{
String id = bus_kho.taoMa();
String maChiTietPhieuNhap = bus_chiTietPhieuNhap.taoMa();
String maNguyenLieu = listNguyenLieu[box_nguyenLieu.SelectedIndex].MaNguyenLieu;
int soLuong = Int32.Parse(txt_soLuong.Text.ToString());
String maNhaCungCap = listNhaCungCap[box_nhaCungCap.SelectedIndex].MaNhaCungCap;
String loaiDonVi = box_loaiDonVi.SelectedItem.ToString();
KHO kho = new KHO(id, maNguyenLieu, soLuong, loaiDonVi);
listNhapKho.Add(kho);
ChiTietPhieuNhap chiTiet = new ChiTietPhieuNhap(maChiTietPhieuNhap, maNguyenLieu, soLuong, maNhaCungCap, maPhieuNhapct);
bus_chiTietPhieuNhap.Them(chiTiet);
}
gridChiTietPhieuNhap.DataSource = bus_chiTietPhieuNhap.LayChiTietPhieuNhap();
}
public static bool del_HoaDon(HoaDon_View hd, DataUpdate <CT_HOADON> list_Change)
{
using (var transaction = Context.getInstance().db.Database.BeginTransaction())
{
try
{
hd.TrangThai = 0;
Context.getInstance().db.Entry(hd.toHoaDon()).State = System.Data.Entity.EntityState.Modified;
//list_Change.Inserts.ForEach(x =>
//{
//});
//list_Change.Updates.ForEach(x =>
//{
// x.TinhTrang = 1;
// Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified;
//});
list_Change.Deletes.ForEach(x =>
{
//set trang thai = 0 o day
x.TinhTrang = 0;
Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified;
//them trong kho
KHO kho = Context.getInstance().db.KHOes.Where(key => key.MaLinhKien == x.MaLinhKien).Where(k => k.Seri == x.Seri).FirstOrDefault();
kho.TrangThai = 1;
Context.getInstance().db.Entry(kho).State = System.Data.Entity.EntityState.Modified;
});
//update so tien mua hang cua khach hang
KHACHHANG kh = Context.getInstance().db.KHACHHANGs.Where(key => key.MaKhachHang == hd.MaKhachHang).FirstOrDefault();
kh.Tong -= hd.TongTien;
Context.getInstance().db.Entry(kh).State = System.Data.Entity.EntityState.Modified;
//update so luong ban hang cua nhan vien
NHANVIEN mNV = Context.getInstance().db.NHANVIENs.Where(key => key.MaNhanVien == hd.MaNhanVien).FirstOrDefault();
mNV.TongTien -= hd.TongTien;
Context.getInstance().db.Entry(mNV).State = System.Data.Entity.EntityState.Modified;
Context.getInstance().db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Context.Refresh();
Console.WriteLine("ERROR--------------------------------------" + ex.Message);
return(false);
}
}
return(true);
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
KHO kho = null;
XUAT xuat = db.XUATs.ToList()[index];
CHITIETXUAT ctx = new CHITIETXUAT();
ctx.XUATID = xuat.XUATID;
ctx.MATHANGID = (int)cbxMatHang.SelectedValue;
ctx.SOLUONG = (int)txtSoLuong.Value;
ctx.GIABAN = (int)txtDonGia.Value;
try
{
kho = db.KHOes.Where(p => p.MATHANGID == ctx.MATHANGID).First();
}
catch
{
}
if (kho == null || kho.SOLUONG < ctx.SOLUONG)
{
MessageBox.Show("Số lượng hàng trong kho của mặt hàng " + cbxMatHang.Text + " không đủ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
kho.SOLUONG -= ctx.SOLUONG;
List<CHITIETXUAT> ct = db.CHITIETXUATs.Where(p => p.XUATID == xuat.XUATID).ToList();
int i = 1;
foreach (var r in ct)
{
if (r.MATHANGID == (int)cbxMatHang.SelectedValue)
{
r.SOLUONG += (int)txtSoLuong.Value;
db.SaveChanges();
i = 0;
break;
}
}
if(i==1)
db.CHITIETXUATs.Add(ctx);
db.SaveChanges();
MessageBox.Show("Thêm chi tiết xuất thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDgvChiTietXuat();
}
catch
{
}
}
// Xóa một kho khỏi database
public static void XoaKho(Kho kho)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHO khoDB = (from n in db.KHOs
where n.MAKHO == kho.MaKho
select n).FirstOrDefault();
db.KHOs.DeleteOnSubmit(khoDB);
db.SubmitChanges();
}
}
public ActionResult Edit([Bind(Include = "MaLoHang,MaNSX,TenLoHang,SoLuong,NgayNhap")] KHO kHO)
{
if (ModelState.IsValid)
{
db.Entry(kHO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNSX = new SelectList(db.NSXes, "MaNSX", "TenNSX", kHO.MaNSX);
return(View(kHO));
}
public static IQueryable <BOTonKho> GetTonKhoByKho(KaraokeEntities kara, KHO kho)
{
return(from a in kara.TONKHOes
join b in kara.MENUMONs on a.MonID equals b.MonID
where a.KhoID == kho.KhoID && a.SoLuongTon > 0
select new BOTonKho
{
TonKho = a,
TenMon = b.TenDai
});
}
private void btnThem_Click(object sender, EventArgs e)
{
if (btnThem.Text == "Thêm")
{
btnSua.Enabled = false;
btnThem.Text = "Lưu";
btnXoa.Text = "Hủy";
ClearControl();
UnlockControl();
return;
}
if (btnThem.Text == "Lưu")
{
if (Check())
{
btnThem.Text = "Thêm";
btnXoa.Text = "Xóa";
LockControl();
MATHANG moi = getMATHANGByForm();
db.MATHANGs.Add(moi);
try
{
db.SaveChanges();
KHO kho = new KHO();
kho.MATHANGID = moi.ID;
kho.SOLUONG = 0;
db.KHOes.Add(kho);
db.SaveChanges();
MessageBox.Show("Thêm thông tin mặt hàng thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Thêm thông tin mặt hàng thất bại\n" + ex.Message,
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
LoadDgvMatHang();
}
return;
}
}
public List <KHO> loadSTOCKlist()
{
List <KHO> stocklist = new List <KHO>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM DBO.STOCK");
foreach (DataRow item in data.Rows)
{
KHO kho = new KHO(item);
stocklist.Add(kho);
}
return(stocklist);
}
public ActionResult AddNew()
{
KHO model = new KHO();
var ctx = new SmsContext();
var nguoiDungList = (from s in ctx.NGUOI_DUNG
where s.ACTIVE == "A"
select s).ToList <NGUOI_DUNG>();
ViewBag.nguoiDungList = nguoiDungList;
ctx.Dispose();
return(View());
}
public ActionResult Create([Bind(Include = "MaLoHang,MaNSX,TenLoHang,SoLuong,NgayNhap")] KHO kHO)
{
if (ModelState.IsValid)
{
db.KHOes.Add(kHO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNSX = new SelectList(db.NSXes, "MaNSX", "TenNSX", kHO.MaNSX);
return(View(kHO));
}
// Thêm kho
public static void ThemKho(Kho kho)
{
KHO KhoDB = new KHO();
KhoDB.MAKHO = kho.MaKho;
KhoDB.TENKHO = kho.TenKho;
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.KHOs.InsertOnSubmit(KhoDB);
db.SubmitChanges();
}
}
public static bool add_HoaDonNhap(HoaDonNhap_View hd, List <CT_HoaDonNhap_View> ct_hds)
{
using (var transaction = Context.getInstance().db.Database.BeginTransaction())
{
try
{
decimal phanTramLoiNhuanBanLe = decimal.Parse(HeThong_DAL.getHeThongByMa("HT002").GiaTri);
decimal phanTramLoiNhuanBanBuon = decimal.Parse(HeThong_DAL.getHeThongByMa("HT003").GiaTri);
Context.getInstance().db.Entry(hd.toHoaDonNhap()).State = System.Data.Entity.EntityState.Added;
Context.getInstance().db.SaveChanges();
LINHKIEN lk;
ct_hds.ForEach(x =>
{
foreach (var seri in x.SoSeri)
{
Context.getInstance().db.Entry(x.toCT_HoaDonNhap(seri)).State = System.Data.Entity.EntityState.Added;
//nhap kho
KHO myK = new KHO();
myK.MaLinhKien = x.MaLinhKien;
myK.Seri = seri;
myK.NgayNhap = hd.NgayLap;
myK.TrangThai = 1;
Context.getInstance().db.Entry(myK).State = System.Data.Entity.EntityState.Added;
}
lk = Context.getInstance().db.LINHKIENs.Where(key => key.MaLinhKien == x.MaLinhKien).FirstOrDefault();
if (lk.GiaNhap != x.GiaNhap)
{
lk.GiaNhap = x.GiaNhap;
lk.GiaBanLe = x.GiaNhap + (x.GiaNhap * phanTramLoiNhuanBanLe / 100);
lk.GiaBanSi = x.GiaNhap + (x.GiaNhap * phanTramLoiNhuanBanBuon / 100);
Context.getInstance().db.Entry(lk).State = System.Data.Entity.EntityState.Modified;
}
});
//update so tien nhap hang cua nha cc
NHACUNGCAP ncc = Context.getInstance().db.NHACUNGCAPs.Where(key => key.MaNhaCungCap == hd.MaNhaCungCap).FirstOrDefault();
ncc.Tong += hd.TongTien;
Context.getInstance().db.Entry(ncc).State = System.Data.Entity.EntityState.Modified;
Context.getInstance().db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Context.Refresh();
Console.WriteLine("ERROR--------------------------------------" + ex.Message);
return(false);
}
}
return(true);
}
// Sửa thông tin kho
public static void CapNhatKho(Kho kho)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHO khoDB = (from n in db.KHOs
where n.MAKHO == kho.MaKho
select n).FirstOrDefault();
khoDB.MAKHO = kho.MaKho;
khoDB.TENKHO = kho.TenKho;
db.SubmitChanges();
}
}
