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();
}