public List <nhomhang> danhsachnhomhang()
{
banhangDataContext context = new banhangDataContext();
List <nhomhang> dsnhomhang = context.nhomhangs.ToList();
return(dsnhomhang);
}
public nhomhang nhomhang(int id)
{
banhangDataContext context = new banhangDataContext();
nhomhang nh = context.nhomhangs.FirstOrDefault(x => x.manhom == id);
return(nh);
}
public List <hanghoa> danhsachhanghoatheomaloai(string maloai)
{
banhangDataContext context = new banhangDataContext();
List <hanghoa> dshh3 = context.hanghoas.Where(x => x.maloai == maloai).ToList();
return(dshh3);
}
public List <hanghoa> timkiem(string tenhang)
{
banhangDataContext context = new banhangDataContext();
List <hanghoa> dshh3 = context.hanghoas.Where(x => x.tenhang.Contains(tenhang)).ToList();
return(dshh3);
}
public List <hanghoa> danhsachhanghoahtheomanhom(int manhom)
{
banhangDataContext context = new banhangDataContext();
List <hanghoa> dshh2 = context.hanghoas.Where(x => x.manhom == manhom).ToList();
return(dshh2);
}
public hanghoa thongtinhanghoa(int id)
{
banhangDataContext context = new banhangDataContext();
hanghoa hh = context.hanghoas.FirstOrDefault(x => x.mahang == id);
return(hh);
}
public List <hanghoa> danhsachhanghoa()
{
banhangDataContext context = new banhangDataContext();
List <hanghoa> dshh = context.hanghoas.ToList();
return(dshh);
}
public List <nhomhang> danhsachnhomhangtheomaloai(string maloai)
{
banhangDataContext context = new banhangDataContext();
List <nhomhang> dslh = context.nhomhangs.Where(x => x.maloai == maloai).ToList();
return(dslh);
}
public List <donhang> danhsachdonhangtheotkkhvatinhtrang(string tkkh, string tinhtrang)
{
banhangDataContext context = new banhangDataContext();
List <donhang> dsdh2 = context.donhangs.Where(x => x.tkkh == tkkh && x.tinhtrang == tinhtrang).ToList();
return(dsdh2);
}
public List <loaihang> danhsachloaihang()
{
banhangDataContext context = new banhangDataContext();
List <loaihang> dsloaihang = context.loaihangs.ToList();
return(dsloaihang);
}
public donhang thongtindonhang(int id)
{
banhangDataContext context = new banhangDataContext();
donhang dh = context.donhangs.FirstOrDefault(x => x.masodh == id);
return(dh);
}
public List <noibac> danhsachnoibac()
{
banhangDataContext context = new banhangDataContext();
List <noibac> dsnb = context.noibacs.ToList();
return(dsnb);
}
public List <donhang> danhsachdonhangtheotkkh(string tkkh)
{
banhangDataContext context = new banhangDataContext();
List <donhang> dsdh1 = context.donhangs.Where(x => x.tkkh == tkkh).ToList();
return(dsdh1);
}
public List <donhang> danhsachdonhangtheotinhtrang(string tinhtrang)
{
banhangDataContext context = new banhangDataContext();
List <donhang> dsdh3 = context.donhangs.Where(x => x.tinhtrang == tinhtrang).ToList();
return(dsdh3);
}
public List <chitietdonhang> thongtindonhang(int id)
{
banhangDataContext context = new banhangDataContext();
List <chitietdonhang> ttdh = context.chitietdonhangs.Where(x => x.masodh == id).ToList();
return(ttdh);
}
public List <donhang> danhsachdonhang()
{
banhangDataContext context = new banhangDataContext();
List <donhang> dsdh = context.donhangs.ToList();
return(dsdh);
}
public khachhang thongtikhachhang(string id)
{
banhangDataContext context = new banhangDataContext();
khachhang kh = context.khachhangs.FirstOrDefault(x => x.tkkh == id);
kh.mkkh = null;
return(kh);
}
public nhavien thongtinhanvien(string id)
{
banhangDataContext context = new banhangDataContext();
nhavien nv = context.nhaviens.FirstOrDefault(x => x.tknv == id);
nv.mknv = null;
return(nv);
}
public List <nhavien> danhsachnhanvien()
{
banhangDataContext context = new banhangDataContext();
List <nhavien> dsnv = context.nhaviens.ToList();
foreach (nhavien x in dsnv)
{
x.mknv = null;
}
return(dsnv);
}
public List <khachhang> danhsachkhachhang()
{
banhangDataContext context = new banhangDataContext();
List <khachhang> dskh = context.khachhangs.ToList();
foreach (khachhang x in dskh)
{
x.mkkh = null;
}
return(dskh);
}
public bool dangnhap(string tknv, string mknv)
{
try
{
banhangDataContext context = new banhangDataContext();
nhavien tk = context.nhaviens.FirstOrDefault(x => x.tknv == tknv && x.mknv == mknv);
if (tk != null)
{
return(true);
}
}
catch { }
return(false);
}
public bool dangnhap(string tkkh, string mkkh)
{
try
{
banhangDataContext context = new banhangDataContext();
khachhang tk = context.khachhangs.FirstOrDefault(x => x.tkkh == tkkh && x.mkkh == mkkh);
if (tk != null)
{
return(true);
}
}
catch { }
return(false);
}
public bool themnhomhang(string maloai, string tennhom)
{
try
{
banhangDataContext context = new banhangDataContext();
nhomhang lhmoi = new nhomhang();
lhmoi.maloai = maloai;
lhmoi.tennhom = tennhom;
context.nhomhangs.InsertOnSubmit(lhmoi);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool huydonhang(int masodh)
{
try
{
banhangDataContext context = new banhangDataContext();
donhang dh = context.donhangs.FirstOrDefault(x => x.masodh == masodh);
if (dh != null)
{
dh.tinhtrang = "huy";
context.SubmitChanges();
return(true);
}
}
catch { };
return(false);
}
public bool doimatkhaunhanvien(string tknv, string mknv, string mkmoi)
{
try
{
banhangDataContext context = new banhangDataContext();
nhavien doimknv = context.nhaviens.FirstOrDefault(x => x.tknv == tknv && x.mknv == mknv);
if (doimknv != null)
{
doimknv.mknv = mkmoi;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool xoahanghoa(int mahang)
{
try
{
banhangDataContext context = new banhangDataContext();
hanghoa xoahh = context.hanghoas.FirstOrDefault(x => x.mahang == mahang);
if (xoahh != null)
{
context.hanghoas.DeleteOnSubmit(xoahh);
context.SubmitChanges();
return(true);
}
}
catch { };
return(false);
}
public bool suanoibac(int thutu, int mahang)
{
try
{
banhangDataContext context = new banhangDataContext();
noibac nb = context.noibacs.FirstOrDefault(x => x.thutu == thutu);
if (nb != null)
{
nb.mahang = mahang;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool xoanhomhang(int manhom)
{
try
{
banhangDataContext context = new banhangDataContext();
nhomhang xoalh = context.nhomhangs.FirstOrDefault(x => x.manhom == manhom);
if (xoalh != null)
{
context.nhomhangs.DeleteOnSubmit(xoalh);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool doimatkhaukhachhang(string tkkh, string mkkh, string mkmoi)
{
try
{
banhangDataContext context = new banhangDataContext();
khachhang doimkkh = context.khachhangs.FirstOrDefault(x => x.tkkh == tkkh && x.mkkh == mkkh);
if (doimkkh != null)
{
doimkkh.mkkh = mkmoi;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool them(int masodh, int mahang, int soluong, int gia1sp)
{
try
{
banhangDataContext context = new banhangDataContext();
chitietdonhang themvaodh = new chitietdonhang();
themvaodh.masodh = masodh;
themvaodh.mahang = mahang;
themvaodh.soluong = soluong;
themvaodh.giadathang1sp = gia1sp;
context.chitietdonhangs.InsertOnSubmit(themvaodh);
context.SubmitChanges();
return(true);
}
catch { };
return(false);
}
