public void Insert(int sophieu, int masp, int sl, decimal dongia, decimal thanhtien) { var r = datacontext.CTPHIEUBANs.Where(p => p.MaSP == masp && p.SoPhieuBan == sophieu).FirstOrDefault(); if (r != null) // da ton tai thi cap nhat so luong // update { r.SoLuong += sl; r.ThanhTien += thanhtien; SanPham.Update(masp, sl); // cap nhat so luongton PhieuBan.UpdateTongTien(r.SoPhieuBan, thanhtien); // cap nhat tongtien datacontext.SubmitChanges(); } else // them moi { CTPHIEUBAN ct = new CTPHIEUBAN(); ct.SoPhieuBan = sophieu; ct.MaSP = masp; ct.SoLuong = sl; ct.DonGia = dongia; ct.ThanhTien = thanhtien; datacontext.CTPHIEUBANs.InsertOnSubmit(ct); datacontext.SubmitChanges(); PhieuBan.UpdateTongTien(ct.SoPhieuBan, ct.ThanhTien.Value); //cap nhat tong tien SanPham.Update(ct.MaSP, sl); // cap nhat so luong ton } }
public void LoaiDichVu_Upd(LoaiDichVu_DTO a) { var obj = vbdq.LOAIDICHVUs.Single(x => x.MaLoaiDV == a.MaLoaiDV); obj.TenLoaiDV = a.TenLoaiDV; obj.DonGia = a.DonGia; vbdq.SubmitChanges(); }
public void XoaDVTinh(int madvtinh) { var MyQuery = (from p in DB.DONVITINHs where p.MaDonViTinh == madvtinh select p).FirstOrDefault(); DB.DONVITINHs.DeleteOnSubmit(MyQuery); DB.SubmitChanges(); }
public void PhieuGiaCong_Upd(PhieuGiaCong_DTO pbh) { var obj = vbdq.PHIEUGIACONGs.Single(x => x.SoPhieuGiaCong == pbh.SoPhieuGiaCong); obj.NgayLap = DateTime.Parse(pbh.NgayLap.ToString()); obj.TongTien = Decimal.Parse(pbh.TongTien.ToString()); vbdq.SubmitChanges(); }
public void XoaLoaiSP(int maloaisp) { var MyQuery = (from p in DB.LOAISPs where p.MaLoaiSP == maloaisp select p).FirstOrDefault(); DB.LOAISPs.DeleteOnSubmit(MyQuery); DB.SubmitChanges(); }
public void XoaKieuSP(int makieusp) { var MyQuery = (from p in DB.KIEUSPs where p.MaKieuSP == makieusp select p).FirstOrDefault(); DB.KIEUSPs.DeleteOnSubmit(MyQuery); DB.SubmitChanges(); }
public void ThemPhieuNhap(PhieuNhap_DTO a) { PHIEUNHAP b = new PHIEUNHAP(); b.NgayLap = DateTime.Parse(a.NgayLap); b.TongTien = a.TongTien; DB.PHIEUNHAPs.InsertOnSubmit(b); DB.SubmitChanges(); }
public void CapNhat(BaoCaoTonKho_DTO a) { BAOCAOTONKHO b = new BAOCAOTONKHO(); b.MaBaoCao = a.MaBaoCao; b.NgayLap = DateTime.Parse(a.NgayLap); vbdq.BAOCAOTONKHOs.InsertOnSubmit(b); vbdq.SubmitChanges(); }
public void Update(int masp, int soluongban) { SANPHAM p = datacontext.SANPHAMs.Where(x => x.MaSP == masp).FirstOrDefault(); if (p != null) { p.SoLuongTon -= soluongban; } datacontext.SubmitChanges(); }
public void ThoGiaCong_Upd(ThoGiaCong_DTO a) { var obj = vbdq.THOGIACONGs.Single(x => x.MaTho == a.MaTho); obj.TenTho = a.TenTho; obj.SDT = a.SDT; obj.DiaChi = a.DiaChi; vbdq.SubmitChanges(); }
public void PhieuChi_Upd(PhieuChi_DTO a) { PHIEUCHI b = new PHIEUCHI(); var obj = vbdq.PHIEUCHIs.Single(x => x.SoPhieuChi == a.SoPhieuChi); // obj.SoPhieuChi = a.SoPhieuChi; obj.NoiDung = a.NoiDung; obj.NgayChi = DateTime.Parse(a.NgayChi); obj.SoTienChi = a.SoTienChi; // vbdq.PHIEUCHIs.InsertOnSubmit(b); vbdq.SubmitChanges(); }
public void CTPhieuDichVu_Upd(CTPhieuDichVu_DTO pbh) { var obj = vbdq.CTPHIEUDICHVUs.Single(x => x.SoPhieuDV == pbh.SoPhieuDichVu && x.STT == pbh.STT); obj.MaLoaiDV = pbh.MaLoaiDV; obj.DonGia = Decimal.Parse(pbh.DonGia.ToString()); obj.SoLuong = pbh.SoLuong; obj.ThanhTien = Decimal.Parse(pbh.ThanhTien.ToString()); obj.TinhTrang = Int32.Parse(pbh.TinhTrang.ToString()); obj.NgayGiao = DateTime.Parse(pbh.NgayGiao.ToString()); vbdq.SubmitChanges(); }
public int Set(string tenthamso, string giatri) { THAMSO ts = datacontext.THAMSOs.Where(p => p.TEN == tenthamso).FirstOrDefault(); if (ts != null) { ts.GIATRI = giatri; datacontext.SubmitChanges(); return(0); // tìm thấy } else { return(1); // k tìm thấy tham số } }
public void Insert(PhieuNo_DTO x) { PHIEUNO phieuno = new PHIEUNO() { SoPhieuNo = x.SoPhieuNo, SoPhieuBan = x.SoPhieuBan, NgayNo = DateTime.Parse(x.NgayNo), NgayThanhToan = DateTime.Parse(x.NgayThanhToan), SoTienTra = x.SoTienTra, SoTienConLai = x.SoTienConLai }; datacontext.PHIEUNOs.InsertOnSubmit(phieuno); datacontext.SubmitChanges(); }
public void CapNhatTongTien(int sophieugc, int sophieudv, int stt, Decimal tien, int loai) { var obj = vbdq.PHIEUGIACONGs.Single(x => x.SoPhieuGiaCong == sophieugc); var obj_ct = vbdq.CTGIACONGs.Single(x => x.SoPhieuGiaCong == sophieugc && x.SoPhieuDV == sophieudv && x.STT == stt); if (loai == 1) //them ct { obj.TongTien += obj_ct.ThanhTien; } else if (loai == 2) //sua ct { obj.TongTien = obj_ct.ThanhTien + obj.TongTien - tien; } else { obj.TongTien -= obj_ct.ThanhTien; //xoa ct } vbdq.SubmitChanges(); }
public void Save() { try { datacontext.SubmitChanges(); } catch (Exception e) { } }
public void ThemChiTietNhap(CTPhieuNhap_DTO a) { CTPHIEUNHAP b = new CTPHIEUNHAP(); b.ThanhTien = a.ThanhTien; b.SoPhieuNhap = a.SoPhieuNhap; b.SLNhap = a.SLNhap; b.MaSP = a.MaSP; b.DonGia = a.DonGia; DB.CTPHIEUNHAPs.InsertOnSubmit(b); var obj = DB.PHIEUNHAPs.Single(x => x.SoPhieuNhap == a.SoPhieuNhap); obj.TongTien += a.ThanhTien; var c = DB.SANPHAMs.Single(x => x.MaSP == a.MaSP); c.SoLuongTon += a.SLNhap; //obj.NgayLap = DateTime.Parse(a.NgayLap); //DB.SubmitChanges(); DB.SubmitChanges(); }
public void Delete(string quyen) { datacontext = new VBDQDataContext(); PHANQUYEN p = datacontext.PHANQUYENs.Where(m => m.QUYEN == quyen).FirstOrDefault(); if (p != null) { datacontext.PHANQUYENs.DeleteOnSubmit(p); } datacontext.SubmitChanges(); }
public void SaveThamSo(String NoToiDa, String Quen) { var obj = vbdq.THAMSOs.Single(x => x.TEN == "NoToiDa"); obj.GIATRI = NoToiDa; obj = vbdq.THAMSOs.Single(x => x.TEN == "Quen"); obj.GIATRI = Quen; vbdq.SubmitChanges(); }
public void Insert(NguoiDung_DTO x) { NGUOIDUNG nguoidungmoi = new NGUOIDUNG() { QUYEN = x.Quyen, USERNAME = x.UserName, PASS = x.Pass }; datacontext.NGUOIDUNGs.InsertOnSubmit(nguoidungmoi); datacontext.SubmitChanges(); }
public void ThemChiTietMua(CTPhieuMua_DTO a) { DB = new VBDQDataContext(); CTPHIEUMUA b = new CTPHIEUMUA(); b.SoPhieuMua = a.SoPhieuMua; b.STT = this.LayKhoaMoi(b.SoPhieuMua) + 1; b.MaSP = a.MaSP; b.DonGia = a.DonGia; b.SoLuong = a.SoLuong; b.ThanhTien = a.ThanhTien; DB.CTPHIEUMUAs.InsertOnSubmit(b); DB.SubmitChanges(); var obj = DB.PHIEUMUAHANGs.Single(x => x.SoPhieuMua == a.SoPhieuMua); //obj.TongTien = a.TongTien; obj.TongTien += b.ThanhTien; var c = DB.SANPHAMs.Single(x => x.MaSP == a.MaSP); c.SoLuongTon += a.SoLuong; DB.SubmitChanges(); }
public void CapNhapCTPhieuMH(CTPhieuMua_DTO a) { decimal tamp; int tam; var b = DB.CTPHIEUMUAs.Single(x => x.SoPhieuMua == a.SoPhieuMua && x.STT == a.STT); b.MaSP = a.MaSP; b.DonGia = a.DonGia; tam = (a.SoLuong - b.SoLuong) ?? default(int); b.SoLuong = a.SoLuong; tamp = a.ThanhTien - b.ThanhTien ?? default(decimal); b.ThanhTien = a.ThanhTien; DB.SubmitChanges(); var obj = DB.PHIEUMUAHANGs.Single(x => x.SoPhieuMua == a.SoPhieuMua); //obj.TongTien = a.TongTien; obj.TongTien += tamp; var c = DB.SANPHAMs.Single(x => x.MaSP == a.MaSP); c.SoLuongTon += tam; DB.SubmitChanges(); }
public void Delete(int sophieu)// xóa tất cả chi tiết sau đó xóa phiếu bán { // xoa chi tiet truoc :: nha' var chitiet = datacontext.CTPHIEUBANs.Where(x => x.SoPhieuBan == sophieu); foreach (var item in chitiet.ToList()) { //trc khi xóa phải trả số lượng tồn lại SANPHAM sp = datacontext.SANPHAMs.Where(x => x.MaSP == item.MaSP).FirstOrDefault(); sp.SoLuongTon += item.SoLuong; //giờ thì xóa chi tiết datacontext.CTPHIEUBANs.DeleteOnSubmit(item); datacontext.SubmitChanges(); } // giờ thì xóa phiếu bán PHIEUBANHANG p = datacontext.PHIEUBANHANGs.Where(x => x.SoPhieuBan == sophieu).FirstOrDefault(); if (p != null) { datacontext.PHIEUBANHANGs.DeleteOnSubmit(p); } this.Save(); }
public void Delete(string username) { datacontext = new VBDQDataContext(); if (username == "super") { return; // không cho xóa trùm cuối } NGUOIDUNG p = datacontext.NGUOIDUNGs.Where(m => m.USERNAME == username).FirstOrDefault(); if (p != null) { datacontext.NGUOIDUNGs.DeleteOnSubmit(p); } datacontext.SubmitChanges(); }
public void Update(PhanQuyen_DTO x) { datacontext = new VBDQDataContext(); PHANQUYEN p = datacontext.PHANQUYENs.Where(m => m.QUYEN == x.Quyen).FirstOrDefault(); if (p != null) { p.PHIEUMUA = x.PhieuMua; p.PHIEUBAN = x.PhieuBan; p.DICHVU = x.DichVu; p.QUANLY = x.QuanLy; p.THUKHO = x.ThuKho; } datacontext.SubmitChanges(); }
public void Insert(PhanQuyen_DTO x) { PHANQUYEN phanquyenmoi = new PHANQUYEN() { QUYEN = x.Quyen, PHIEUMUA = x.PhieuMua, PHIEUBAN = x.PhieuBan, DICHVU = x.DichVu, QUANLY = x.QuanLy, THUKHO = x.ThuKho }; datacontext.PHANQUYENs.InsertOnSubmit(phanquyenmoi); datacontext.SubmitChanges(); }
public void CapNhapPhieuMH(PhieuMuaHang_DTO a) { var obj = DB.PHIEUMUAHANGs.Single(x => x.SoPhieuMua == a.SoPhieuMua); //obj.TongTien = a.TongTien; int tamp = obj.MaKH; obj.MaKH = a.MaKH; if (tamp != a.MaKH) { KHACHHANG kh = DB.KHACHHANGs.Where(p => p.MaKH == a.MaKH).FirstOrDefault(); if (kh != null) { kh.Quen += 1; } KHACHHANG k = DB.KHACHHANGs.Where(p => p.MaKH == tamp).FirstOrDefault(); if (k != null) { k.Quen -= 1; } } obj.NgayThanhToan = DateTime.Parse(a.NgayThanhToan); obj.NgayMua = DateTime.Parse(a.NgayMua); DB.SubmitChanges(); }
public void Update(NguoiDung_DTO x) { datacontext = new VBDQDataContext(); if (x.UserName == "super") { return; // không cho sửa trùm cuối } NGUOIDUNG p = datacontext.NGUOIDUNGs.Where(m => m.USERNAME == x.UserName).FirstOrDefault(); if (p != null) { p.PASS = x.Pass; p.QUYEN = x.Quyen; } datacontext.SubmitChanges(); }