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 }
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 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 }
// 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 void Validation() { if (txtMKold.Text == "") { lblThongBao.Text = "Bạn phải nhập mật khẩu cũ"; return; } if (txtMKnew.Text == "") { lblThongBao.Text = "Bạn phải nhập mật khẩu mới"; return; } if (txtMKnewConfirm.Text == "") { lblThongBao.Text = "Bạn phải xác nhận mật khẩu mới"; return; } var acc = (from i in data.DangNhaps where i.Username == txtTenDN.Text select i ).SingleOrDefault(); //string MKold = GetMd5(txtMKold.Text); //string MKnew = GetMd5(txtMKnew.Text); //if(MKold != acc.Password) //{ // lblThongBao.Text = "Nhập mật khẩu cũ sai"; // return; //} //if(MKnew == MKold) //{ // lblThongBao.Text = "Mật khẩu mới phải khác mật khẩu cũ"; // return; //} if (txtMKold.Text != acc.Password) { lblThongBao.Text = "Nhập mật khẩu cũ sai"; return; } if (txtMKnew.Text == txtMKold.Text) { lblThongBao.Text = "Mật khẩu mới phải khác mật khẩu cũ"; return; } if (txtMKnewConfirm.Text != txtMKnew.Text) { lblThongBao.Text = "Xác thực mật khẩu mới không chính xác"; return; } acc.Password = txtMKnew.Text; data.SubmitChanges(); this.Hide(); }
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 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 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); } }
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; } }
// 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); } }
// Cap nhat nhacc public static bool UpdateNhaCC(NhaCungCap _cc) { try { using (var db = new SieuThiDBDataContext()) { var cc = db.NhaCungCaps.Single(x => x.MaNCC == _cc.MaNCC); cc.TenNCC = _cc.TenNCC; cc.DiaChi = _cc.DiaChi; cc.DienThoai = _cc.DienThoai; cc.MaSoThue = _cc.MaSoThue; cc.Fax = _cc.Fax; db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool UpdateNhaCC(nhacungcap _cc) { try { using (var db = new SieuThiDBDataContext()) { var cc = db.nhacungcaps.Single(x => x.ma == _cc.ma); cc.tennhacungcap = _cc.tennhacungcap; cc.ma = _cc.ma; cc.diachi = _cc.diachi; cc.sodienthoai = _cc.sodienthoai; cc.masothue = _cc.masothue; cc.fax = _cc.fax; db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool CreateNhaCC(nhacungcap cc) { try { using (SieuThiDBDataContext db = new SieuThiDBDataContext()) { var cc1 = new nhacungcap(); cc1.tennhacungcap = cc.tennhacungcap; cc1.ma = cc.ma; cc1.diachi = cc.diachi; cc1.sodienthoai = cc.sodienthoai; cc1.masothue = cc.masothue; cc1.fax = cc.fax; db.nhacungcaps.InsertOnSubmit(cc1); db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool CreateHang(Hang hang) { try { using (SieuThiDBDataContext db = new SieuThiDBDataContext()) { var hang1 = new Hang(); hang1.MaHang = hang.MaHang; hang1.DVT = hang.DVT ?? ""; hang1.GhiChu = hang.GhiChu ?? ""; hang1.MaLoaiHang = hang.MaLoaiHang; hang1.MaNCC = hang.MaNCC; hang1.TenHang = hang.TenHang ?? ""; db.Hangs.InsertOnSubmit(hang1); db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool deleteLoaiHang(int id) { try { using (var db = new SieuThiDBDataContext()) { var nv = db.LoaiHangs.Single(x => x.MaLoaiHang == id); if (nv != null) { db.LoaiHangs.DeleteOnSubmit(nv); db.SubmitChanges(); return(true); } else { return(false); } } } catch { return(false); } }
// Xoa nhacc public static bool DeleteNhaCC(int id) { try { using (var db = new SieuThiDBDataContext()) { var cc = db.NhaCungCaps.Single(x => x.MaNCC == id); if (cc != null) { db.NhaCungCaps.DeleteOnSubmit(cc); db.SubmitChanges(); return(true); } else { return(false); } } } catch { return(false); } }
// Tạo nhacc public static bool CreateNhaCC(NhaCungCap cc) { try { using (SieuThiDBDataContext db = new SieuThiDBDataContext()) { var cc1 = new NhaCungCap(); cc1.TenNCC = cc.TenNCC ?? ""; cc1.MaNCC = cc.MaNCC; cc1.DiaChi = cc.DiaChi; cc1.DienThoai = cc.DienThoai; cc1.MaSoThue = cc.MaSoThue; cc1.Fax = cc.Fax; db.NhaCungCaps.InsertOnSubmit(cc1); db.SubmitChanges(); return(true); } } catch { return(false); } }