public string laytienkhachhangno(string makh)
{
using (QLBanHangDataContext db = new QLBanHangDataContext())
{
var ds = from HoaDon_Xuats in
(from HoaDon_Xuats in db.HoaDon_Xuats
where
HoaDon_Xuats.MAKH == makh &&
HoaDon_Xuats.TinhTrangXuat == "Đang giao dịch"
select new
{
HoaDon_Xuats.TongTien,
Dummy = "x"
})
group HoaDon_Xuats by new { HoaDon_Xuats.Dummy } into g
select new Tontienkhachang
{
tienno = g.Sum(p => p.TongTien).ToString()
};
List <Tontienkhachang> lst = ds.ToList();
if (lst.Count > 0)
{
return(lst[0].tienno.ToString());
}
else
{
return("0");
}
}
}
public List <int> laysoluonghanghoahientai(string mahh, string mahdnhap)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
var ds = from ChiTietHD_Nhaps in data.ChiTietHD_Nhaps.Where(t => t.MAHH == mahh && t.MAHD_Nhap == mahdnhap)
select ChiTietHD_Nhaps.SoLuong_Nhap.Value;
return(ds.ToList());
}
}
public List <string> laycongnokhachhang()
{
using (QLBanHangDataContext db = new QLBanHangDataContext())
{
var ds = from HoaDon_Xuats in db.HoaDon_Xuats.Where(t => t.TinhTrangXuat == "Đang giao dịch") select HoaDon_Xuats.MAKH;
return(ds.ToList());
}
}
public void xoa1nguoidung(string username)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
NguoiDung nd = new NguoiDung();
nd = data.NguoiDungs.Where(t => t.UserName == username).FirstOrDefault();
data.NguoiDungs.DeleteOnSubmit(nd);
data.SubmitChanges();
}
}
private void buttonLuu_Click(object sender, EventArgs e)
{
QLBanHangDataContext db = new QLBanHangDataContext();
SanPham spSua = db.SanPhams.SingleOrDefault(sp => sp.MaSP == textBoxMa.Text);
spSua.TenSP = textBoxTen.Text;
spSua.SoLuong = int.Parse(textBoxSoLuong.Text);
spSua.DonGia = int.Parse(textBoxDonGia.Text);
spSua.MaLoai = textBoxMaLoai.Text;//chú ý khi test phải nhập mã loại đã có trong bảng Loại sản phẩm
//Lưu vào csdl
db.SubmitChanges();
}
public void xoa1phieuthu(string mapt)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
PhieuThu pt = data.PhieuThus.Where(m => m.MaPhieuThu == mapt).FirstOrDefault();
if (pt != null)
{
data.PhieuThus.DeleteOnSubmit(pt);
data.SubmitChanges();
}
}
}
public void them1quyenchonhomnd(string Mand, string maquyen, bool quyen)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Phanquyennhom pq = new Phanquyennhom();
pq.Manhomnguoidung = Mand;
pq.Maquyen = maquyen;
pq.Quyenhan = quyen;
data.Phanquyennhoms.InsertOnSubmit(pq);
data.SubmitChanges();
}
}
public void xoa1quyenchonhomnd(string mand, string maquyen)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Phanquyennhom pq = new Phanquyennhom();
pq = data.Phanquyennhoms.Where(t => t.Maquyen == maquyen).FirstOrDefault();
if (pq != null)
{
data.Phanquyennhoms.DeleteOnSubmit(pq);
data.SubmitChanges();
}
}
}
public void xoa1khachhang(string makh)
{
using (QLBanHangDataContext db = new QLBanHangDataContext())
{
KhachHang kh = new KhachHang();
kh = db.KhachHangs.Where(t => t.MaKH == makh).FirstOrDefault();
if (kh != null)
{
db.KhachHangs.DeleteOnSubmit(kh);
db.SubmitChanges();
}
}
}
public void xoahanghoatrongchitietđonat(string mahh, string mahdnhap)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Chitietdondathang chitiethdnhap = new Chitietdondathang();
chitiethdnhap = data.Chitietdondathangs.Where(t => t.MAHH == mahh && t.MaDH == mahdnhap).FirstOrDefault();
if (chitiethdnhap != null)
{
data.Chitietdondathangs.DeleteOnSubmit(chitiethdnhap);
data.SubmitChanges();
}
}
}
public void updatetinhtrangnhapkho(string mahdnhap, string tinhtrangnhapkho)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Nhap hdnhap = new HoaDon_Nhap();
hdnhap = data.HoaDon_Nhaps.Where(t => t.MAHD_Nhap == mahdnhap).FirstOrDefault();
if (hdnhap != null)
{
hdnhap.TinhTrangNhapKho = tinhtrangnhapkho;
data.SubmitChanges();
}
}
}
public void xoa1nhomnd(string mand)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Nhomnguoidung2 ndn = new Nhomnguoidung2();
ndn = data.Nhomnguoidung2s.Where(t => t.Manhomnguoidung == mand).FirstOrDefault();
if (ndn != null)
{
data.Nhomnguoidung2s.DeleteOnSubmit(ndn);
data.SubmitChanges();
}
}
}
public void them1nhomnd(string manhonnd, string tennhomnguoidung, string mota)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Nhomnguoidung2 ndn = new Nhomnguoidung2();
ndn.Manhomnguoidung = manhonnd;
ndn.Tennhomnguoidung = tennhomnguoidung;
ndn.Mota = mota;
data.Nhomnguoidung2s.InsertOnSubmit(ndn);
data.SubmitChanges();
}
}
public void xoahanghoatrongchitiethdxuat(string mahh, string madhdxuat)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
ChiTietHD_Xuat chitiethdnhap = new ChiTietHD_Xuat();
chitiethdnhap = data.ChiTietHD_Xuats.Where(t => t.MAHH == mahh && t.MAHD_Xuat == madhdxuat).FirstOrDefault();
if (chitiethdnhap != null)
{
data.ChiTietHD_Xuats.DeleteOnSubmit(chitiethdnhap);
data.SubmitChanges();
}
}
}
public void xoa1userkhachhang(string makh)
{
using (QLBanHangDataContext db = new QLBanHangDataContext())
{
UserKhachHang user = new UserKhachHang();
user = db.UserKhachHangs.Where(t => t.MaKH == makh).FirstOrDefault();
if (user != null)
{
db.UserKhachHangs.DeleteOnSubmit(user);
db.SubmitChanges();
}
}
}
public void themuservaonhomnd(string user, string manhom)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Phanquyennguoidung nnd = new Phanquyennguoidung();
nnd.UserName = user;
nnd.Manhomnguoidung = manhom;
data.Phanquyennguoidungs.InsertOnSubmit(nnd);
data.SubmitChanges();
}
}
public void sua1nhomnd(string mand, string tennhomnd, string mota)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Nhomnguoidung2 ndn = new Nhomnguoidung2();
ndn = data.Nhomnguoidung2s.Where(t => t.Manhomnguoidung == mand).FirstOrDefault();
if (ndn != null)
{
ndn.Tennhomnguoidung = tennhomnd;
ndn.Mota = mota;
data.SubmitChanges();
}
}
}
public void them1quyen(string maquyen, string chucnangquyen, string mota)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Quyen quyen = new Quyen();
quyen.Maquyen = maquyen;
quyen.Chucnangquyen = chucnangquyen;
quyen.Mota = mota;
data.Quyens.InsertOnSubmit(quyen);
data.SubmitChanges();
}
}
public void xoa1hanghoa(string mahh)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HangHoa hanghoa = new HangHoa();
hanghoa = data.HangHoas.Where(t => t.MaHH == mahh).FirstOrDefault();
if (hanghoa != null)
{
data.HangHoas.DeleteOnSubmit(hanghoa);
data.SubmitChanges();
}
}
}
public void sua1hopdonxuat(string mahdxuat, DateTime ngaylaphoadon, string makh)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Xuat hdxuat = new HoaDon_Xuat();
hdxuat = data.HoaDon_Xuats.Where(t => t.MAHD_Xuat == mahdxuat).FirstOrDefault();
if (hdxuat != null)
{
hdxuat.NgayLap_Xuat = ngaylaphoadon;
hdxuat.MAKH = makh;
data.SubmitChanges();
}
}
}
public void xoa1chitiethoadon(string mahh, string mahdxuat) // theo mahh
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
ChiTietHD_Xuat cthdx = new ChiTietHD_Xuat();
cthdx = data.ChiTietHD_Xuats.Where(t => t.MAHH == mahh && t.MAHD_Xuat == mahdxuat).FirstOrDefault();
if (cthdx != null)
{
data.ChiTietHD_Xuats.DeleteOnSubmit(cthdx);
data.SubmitChanges();
}
}
}
public void xoa1quyen(string maquyen)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Quyen quyen = new Quyen();
quyen = data.Quyens.Where(t => t.Maquyen == maquyen).FirstOrDefault();
if (quyen != null)
{
data.Quyens.DeleteOnSubmit(quyen);
data.SubmitChanges();
}
}
}
//sua1chiiethoadonnhap
public void sua1chitiethoadon(string mahdnhap, string mahanghoa, int soluong, double dongia, double thanhtien, string donvi, double vat)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
ChiTietHD_Nhap chiTietHD_Nhap = new ChiTietHD_Nhap();
chiTietHD_Nhap = data.ChiTietHD_Nhaps.Where(t => t.MAHD_Nhap == mahdnhap && t.MAHH == mahanghoa).FirstOrDefault();
if (chiTietHD_Nhap != null)
{
chiTietHD_Nhap.SoLuong_Nhap = soluong;
chiTietHD_Nhap.DonGia_Nhap = dongia;
data.SubmitChanges();
}
}
}
public void xoa1nguoidungrahomnd(string user, string manhomnd)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Phanquyennguoidung nnd = new Phanquyennguoidung();
nnd = data.Phanquyennguoidungs.Where(t => t.UserName == user && t.Manhomnguoidung == manhomnd).FirstOrDefault();
if (nnd != null)
{
data.Phanquyennguoidungs.DeleteOnSubmit(nnd);
data.SubmitChanges();
}
}
}
public void themphieuthikhithanhtoan(string maphieuthu, string doituong, string trangthai, string manv, long sotienthu, DateTime ngayghinhan)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
PhieuThu pt = new PhieuThu();
pt.MaPhieuThu = maphieuthu;
pt.DoiTuong = doituong;
pt.TrangThai = trangthai;
pt.MaNV = manv;
pt.Sotienchi = sotienthu;
pt.Ngayghinhan = ngayghinhan;
data.PhieuThus.InsertOnSubmit(pt);
data.SubmitChanges();
}
}
public void sua1quyen(string maquyen, string chucnangquyen, string mota)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
Quyen quyen = new Quyen();
quyen = data.Quyens.Where(t => t.Maquyen == maquyen).FirstOrDefault();
//quyen.Maquyen = maquyen;
quyen.Chucnangquyen = chucnangquyen;
quyen.Mota = mota;
//data.Quyens.InsertOnSubmit(quyen);
data.SubmitChanges();
}
}
public void them1nguoidung(string username, string manv, string password, bool hoatdong)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
NguoiDung nd = new NguoiDung();
nd.UserName = username;
nd.MaNV = manv;
nd.PassWord = password;
nd.Hoatdong = hoatdong;
data.NguoiDungs.InsertOnSubmit(nd);
data.SubmitChanges();
}
}
public bool kiemtrakhoachinh(string username)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
NguoiDung nd = new NguoiDung();
nd = data.NguoiDungs.Where(t => t.UserName == username).FirstOrDefault();
if (nd != null)
{
return(true);
}
else
{
return(false);
}
}
}
public void sua1nguoidung(string username, string password, bool hoatdong)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
NguoiDung nd = new NguoiDung();
nd = data.NguoiDungs.Where(t => t.UserName == username).FirstOrDefault();
if (nd != null)
{
nd.PassWord = password;
nd.Hoatdong = hoatdong;
data.SubmitChanges();
}
}
}
public void resetpassword(string username, bool hoatdong)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
NguoiDung nd = new NguoiDung();
nd = data.NguoiDungs.Where(t => t.UserName == username).FirstOrDefault();
if (nd != null)
{
nd.PassWord = "******";
nd.Hoatdong = hoatdong;
data.SubmitChanges();
}
}
}
