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