public static List <LoaiHang> getListLoaiHang()
{
using (var db = new SieuThiDBDataContext())
{
return(db.LoaiHangs.OrderBy(x => x.TenLoaiHang).ToList());
}
}
public static List <Hang> GetListHang()
{
using (var db = new SieuThiDBDataContext())
{
return(db.Hangs.OrderBy(x => x.TenHang).ToList());
}
}
public static bool DeleteNhaCC(string id)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var nv = db.nhacungcaps.Single(x => x.ma == id);
if (nv != null)
{
db.nhacungcaps.DeleteOnSubmit(nv);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
#endregion
}
public static List <nhacungcap> GetListNhaCC()
{
using (var db = new SieuThiDBDataContext())
{
return(db.nhacungcaps.OrderBy(x => x.tennhacungcap).ToList());
}
}
public static string GetTenNCC(string maHang)
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
return(db.Hangs.Single(x => x.MaHang.ToLower() == maHang.ToLower()).NhaCungCap.TenNCC);
}
}
public static bool DeleteNhanVien(int id)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var nv = db.NhanViens.Single(x => x.MaNV == id);
if (nv != null)
{
db.NhanViens.DeleteOnSubmit(nv);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
#endregion
}
public static List <NhanVien> GetListNhanVien()
{
using (var db = new SieuThiDBDataContext())
{
return(db.NhanViens.OrderBy(x => x.TenNV).ToList());
}
}
//danh sach gian hang
public static List<GianHang> GetListGianHang()
{
using (var db = new SieuThiDBDataContext())
{
return db.GianHangs.OrderBy(x => x.TenGianHang).ToList();
}
}
// Xoa gian hang
public static bool DeleteGianHang(int id)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var gh = db.GianHangs.Single(x => x.MaGianHang == id);
if (gh != null)
{
db.GianHangs.DeleteOnSubmit(gh);
db.SubmitChanges();
return true;
}
else
{
return false;
}
}
}
catch
{
return false;
}
}
public static bool DeleteHang(string maHang)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var nv = db.Hangs.Single(x => x.MaHang.ToLower() == maHang.ToLower());
if (nv != null)
{
db.Hangs.DeleteOnSubmit(nv);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
#endregion
}
//danh sach nhacc
public static List <NhaCungCap> GetListNhaCC()
{
using (var db = new SieuThiDBDataContext())
{
return(db.NhaCungCaps.OrderBy(x => x.TenNCC).ToList());
}
}
public static string GetTenLH(string maHang)
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
string ten = db.Hangs.Single(x => x.MaHang.ToLower() == maHang.ToLower()).LoaiHang.TenLoaiHang;
return(ten);
}
}
private void dgvGianHang_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
{
GianHang gh = dgvGianHang.Rows[e.RowIndex].DataBoundItem as GianHang;
string tenLoaiHang;
using (var db = new SieuThiDBDataContext())
{
tenLoaiHang = db.LoaiHangs.Single(x => x.MaLoaiHang == gh.LoaiHangMa).TenLoaiHang;
}
dgvGianHang.Rows[e.RowIndex].Cells[colLoaiHang.Index].Value = tenLoaiHang;
}
private void FrmUpdateHH_Load(object sender, EventArgs e)
{
using (var db = new SieuThiDBDataContext())
{
lblTenMaLH.Text = db.LoaiHangs.Single(x => x.MaLoaiHang == _hang.MaLoaiHang).TenLoaiHang;
lblTenMaNCC.Text = db.NhaCungCaps.Single(x => x.MaNCC == _hang.MaNCC).TenNCC;
}
txtMaHang.Text = _hang.MaHang;
txtDVT.Text = _hang.DVT;
txtGhiChu.Text = _hang.GhiChu;
txtMaLH.Text = _hang.MaLoaiHang.ToString();
txtMaNCC.Text = _hang.MaNCC.ToString();
txtTenHang.Text = _hang.TenHang;
}
public static bool InsertHoaDon(HoaDon hd)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
db.HoaDons.InsertOnSubmit(hd);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool InsertDonHang(DonHang dh)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
db.DonHangs.InsertOnSubmit(dh);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool IsExistHang(string maHang)
{
using (var db = new SieuThiDBDataContext())
{
var hang = db.Hangs.Single(x => x.MaHang.ToLower() == maHang.ToLower());
if (hang == null)
{
return(false);
}
else
{
return(true);
}
}
}
public static bool InsertHangNhap(HangNhap hn)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
db.HangNhaps.InsertOnSubmit(hn);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static int GetMaNhaCCNext()
{
using (var db = new SieuThiDBDataContext())
{
int?ma = 0;
var nv = db.nhacungcaps.FirstOrDefault();
if (nv == null)
{
return(1);
}
else
{
db.ManvNext(ref ma);
return(ma + 1 ?? 1);
}
}
}
public static bool updateLoaiHang(LoaiHang _lh)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var loaiHang = db.LoaiHangs.Single(x => x.MaLoaiHang == _lh.MaLoaiHang);
loaiHang.TenLoaiHang = _lh.TenLoaiHang;
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
// Lay Id nhacc tiep theo
public static int GetMaNhaCCNext()
{
using (var db = new SieuThiDBDataContext())
{
int?MaNCC = 0;
var gh = db.NhaCungCaps.FirstOrDefault();
if (gh == null)
{
return(1);
}
else
{
db.MaNhaCCNext(ref MaNCC);
return(MaNCC + 1 ?? 1);
}
}
}
public static int GetMaNVNext()
{
using (var db = new SieuThiDBDataContext())
{
int?manv = 0;
var nv = db.NhanViens.FirstOrDefault();
db.ManvNext(ref manv);
if (nv == null)
{
return(1);
}
else
{
db.ManvNext(ref manv);
return(manv + 1 ?? 1);
}
}
}
public static int getCurrentMaLoaiHang()
{
using (var db = new SieuThiDBDataContext())
{
int?maLoaiHang = 0;
var lh = db.LoaiHangs.FirstOrDefault();
db.LoaiHangGanNhat(ref maLoaiHang);
if (lh == null)
{
return(1);
}
else
{
db.LoaiHangGanNhat(ref maLoaiHang);
return(maLoaiHang + 1 ?? 1);
}
}
}
public static bool createLoaiHang(LoaiHang loaiHang)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
var lh = new LoaiHang();
lh.TenLoaiHang = loaiHang.TenLoaiHang;
db.LoaiHangs.InsertOnSubmit(lh);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool UpdateNhanVien(NhanVien _nv)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var nv = db.NhanViens.Single(x => x.MaNV == _nv.MaNV);
nv.TenNV = _nv.TenNV;
nv.DienThoaiLH = _nv.DienThoaiLH;
nv.MoTaKhac = _nv.MoTaKhac;
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
// Cap nhat Gian hang
public static bool UpdateGianHang(GianHang _gh)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var gh = db.GianHangs.Single(x => x.MaGianHang == _gh.MaGianHang);
gh.TenGianHang = _gh.TenGianHang;
gh.LoaiHangMa = _gh.LoaiHangMa;
db.SubmitChanges();
return true;
}
}
catch
{
return false;
}
}
// Lay Id Gian Hang tiep theo
public static int GetMaGHNext()
{
using (var db = new SieuThiDBDataContext())
{
int? MaGianHang = 0;
var gh = db.GianHangs.FirstOrDefault();
if(gh == null)
{
return 1;
}
else
{
db.GianHangNext(ref MaGianHang);
return MaGianHang + 1 ?? 1;
}
}
}
// Tạo Gian hang
public static bool CreateGianHang(GianHang gh)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
var gh1 = new GianHang();
gh1.TenGianHang = gh.TenGianHang ?? "";
gh1.LoaiHangMa = gh.LoaiHangMa;
db.GianHangs.InsertOnSubmit(gh1);
db.SubmitChanges();
return true;
}
}
catch
{
return false;
}
}
public static bool CreateNhanVien(NhanVien nv)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
var nv1 = new NhanVien();
nv1.TenNV = nv.TenNV;
nv1.MoTaKhac = nv.MoTaKhac ?? "";
nv1.DienThoaiLH = nv.DienThoaiLH ?? "";
db.NhanViens.InsertOnSubmit(nv1);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool UpdateHang(Hang hang)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var hang1 = db.Hangs.Single(x => x.MaHang == hang.MaHang);
hang1.DVT = hang.DVT ?? "";
hang1.GhiChu = hang.GhiChu ?? "";
hang1.MaLoaiHang = hang.MaLoaiHang;
hang1.MaNCC = hang.MaNCC;
hang1.TenHang = hang.TenHang ?? "";
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
