public void insertCTHD(int mahd, int mamon, int soluong, int mode) { String store = "sp_insertCTHD_0"; switch (mode) { case 0: store = "sp_insertCTHD_0"; break; case 1: store = "sp_insertCTHD_1"; break; case 3: store = "sp_insertCTHD_3"; //unrepeatable read break; } SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@mahd", SqlDbType.Int); cm.Parameters["@mahd"].Value = mahd; cm.Parameters.Add("@mamon", SqlDbType.Int); cm.Parameters["@mamon"].Value = mamon; cm.Parameters.Add("@soluong", SqlDbType.Int); cm.Parameters["@soluong"].Value = soluong; provider.ExecuteInsertUpdateDelete(cm); }
public int ThemHoaDon(int maBan, int maNV) { SqlCommand cm = provider.CreateCommandStoreName("sp_insertHoaDon"); cm.Parameters.Add("@maban", SqlDbType.Int); cm.Parameters["@maban"].Value = maBan; cm.Parameters.Add("@manv", SqlDbType.Int); cm.Parameters["@manv"].Value = maNV; int t = provider.ExecuteInsertUpdateDelete(cm); return(t); }
public static int XoaKhuVuc(string maKhuVuc) { Provider provider = new Provider(); string sql = string.Format("delete KhuVuc where MaKhuVuc={0}", maKhuVuc); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemLoaiBanAn(LoaiBanAn_DTO LoaiBA) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiBan values ('{0}',{1})", LoaiBA.MaLoai, LoaiBA.SucChua); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatMonAn(int mode, MonAn_DTO MonAn, int maMonAn) { Provider provider = new Provider(); string store = "sp_CapNhatMonAn"; if (mode == 3) { store = "sp_CapNhatMonAn_Fix"; } //chua xu ly nha hang // string sql = string.Format("update MonAn set TenMon=N'{0}',Gia='{1}',DonViTinh='{2}' where MaMon='{3}' and MaNH='{4}'", MonAn.tenmon, MonAn.Gia, MonAn.Dvtinh, maMonAn,maNH); SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@TenMon", SqlDbType.NVarChar, 50); cm.Parameters.Add("@gia", SqlDbType.Money); cm.Parameters.Add("@DVTinh", SqlDbType.NVarChar, 10); cm.Parameters.Add("@MaMon", SqlDbType.Int); cm.Parameters["@TenMon"].Value = MonAn.tenmon; cm.Parameters["@gia"].Value = MonAn.Gia; cm.Parameters["@DVTinh"].Value = MonAn.Dvtinh; cm.Parameters["@MaMon"].Value = maMonAn; return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemNhanVien(NhanVien_DTO NhanVien, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into NhanVien values (N'{0}','{1}','{2}',{3},{4}) ", NhanVien.TenNV, maNH, NhanVien.MaLoaiNhanVien, NhanVien.Cmnd, NhanVien.Sdt); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int XoaNhanVien(int MaNV) { Provider provider = new Provider(); string sql = string.Format("delete NhanVien where MaNV={0}", MaNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatNhanVien(NhanVien_DTO NhanVien, int MaNV) { Provider provider = new Provider(); string sql = string.Format("update NhanVien set TenNV=N'{0}',sdt={1} where MaNV={2}", NhanVien.TenNV, NhanVien.Sdt, MaNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemMonAn(int mode, MonAn_DTO MonAn, string maNH) { Provider provider = new Provider(); string store = "sp_ThemMonAn"; if (mode == 3) { store = "sp_ThemMonAn_Fix"; } //string sql = string.Format("insert into MonAn(TenMon,LoaiMon,Gia,DonViTinh,MaNH) values ('{0}','{1}','{2}','{3}','{4}')", MonAn.tenmon, MonAn.Mamon, MonAn.Gia, MonAn.Dvtinh,maNH); SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@TenMon", SqlDbType.NVarChar, 50); cm.Parameters.Add("@LoaiMon", SqlDbType.NChar, 20); cm.Parameters.Add("@Gia", SqlDbType.Int); cm.Parameters.Add("@DonViTinh", SqlDbType.NVarChar, 20); cm.Parameters.Add("@MaNH", SqlDbType.NChar, 5); cm.Parameters["@TenMon"].Value = MonAn.tenmon; cm.Parameters["@LoaiMon"].Value = MonAn.Mamon; cm.Parameters["@Gia"].Value = MonAn.Gia; cm.Parameters["@DonViTinh"].Value = MonAn.Dvtinh; cm.Parameters["@MaNH"].Value = maNH; return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemBanAn(BanAn_DTO BanAn, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into BanAn values ({0},'{1}','{2}',{3})", BanAn.MaKhuVuc, BanAn.LoaiBan, maNH, BanAn.TrangThai); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatBanAn(BanAn_DTO BanAn) { Provider provider = new Provider(); string sql = string.Format("update BanAn set TrangThai={0} where MaBan={1}", BanAn.TrangThai, BanAn.MaBan); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatLoaiNhanVien(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("update LoaiNV set TenLoai=N'{0}' where MaLoai='{1}'", loaiNV.TenLoaiNV, loaiNV.MaLoaiNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int XoaBanAn(string maBan) { Provider provider = new Provider(); string sql = string.Format("delete BanAn where MaBan={0}", maBan); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int XoatLoaiMonAn(string ma) { Provider provider = new Provider(); string sql = string.Format("delete LoaiMonAn where MaLoai='{0}'", ma); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemKhuVuc(KhuVuc_DTO KhuVuc, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into KhuVuc values ({0},'{1}','{2}','{3}')", KhuVuc.MaKhuVuc, KhuVuc.TenKhuVuc, KhuVuc.ViTri, maNH); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatLoaiBA(LoaiBanAn_DTO loaiBA) { Provider provider = new Provider(); string sql = string.Format("update LoaiBan set SucChua={0} where Maloai='{1}'", loaiBA.SucChua, loaiBA.MaLoai); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatKhuVuc(KhuVuc_DTO KhuVuc) { Provider provider = new Provider(); string sql = string.Format("update KhuVuc set TenKhuVuc=N'{0}',ViTri=N'{1}' where MaKhuVuc={2}", KhuVuc.TenKhuVuc, KhuVuc.ViTri, KhuVuc.MaKhuVuc); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemLoaiBanAn(LoaiBanAn_DTO LoaiBA) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiBan values ('{0}',{1})", LoaiBA.MaLoai, LoaiBA.SucChua); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemKhuVuc(KhuVuc_DTO KhuVuc, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into KhuVuc values ({0},'{1}','{2}','{3}')", KhuVuc.MaKhuVuc, KhuVuc.TenKhuVuc, KhuVuc.ViTri, maNH); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatLoaiNhanVien(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("update LoaiNV set TenLoai=N'{0}' where MaLoai='{1}'", loaiNV.TenLoaiNV, loaiNV.MaLoaiNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemLoaiNV(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiNV(MaLoai,TenLoai,Luong) values ('{0}','{1}',{2})", loaiNV.MaLoaiNV, loaiNV.TenLoaiNV, loaiNV.Luong); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int XoaLoaiNhanVien(string maLoai) { Provider provider = new Provider(); string sql = string.Format("delete LoaiNV where MaLoai='{0}'", maLoai); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int XoaNhanVien(int MaNV) { Provider provider = new Provider(); string sql = string.Format("delete NhanVien where MaNV={0}", MaNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatNhanVien(NhanVien_DTO NhanVien, int MaNV) { Provider provider = new Provider(); string sql = string.Format("update NhanVien set TenNV=N'{0}',sdt={1} where MaNV={2}", NhanVien.TenNV, NhanVien.Sdt, MaNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemNhanVien(NhanVien_DTO NhanVien, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into NhanVien values (N'{0}','{1}','{2}',{3},{4}) ", NhanVien.TenNV, maNH, NhanVien.MaLoaiNhanVien, NhanVien.Cmnd, NhanVien.Sdt); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatKhuVuc(KhuVuc_DTO KhuVuc) { Provider provider = new Provider(); string sql = string.Format("update KhuVuc set TenKhuVuc=N'{0}',ViTri=N'{1}' where MaKhuVuc={2}", KhuVuc.TenKhuVuc, KhuVuc.ViTri, KhuVuc.MaKhuVuc); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatLoaiBA(LoaiBanAn_DTO loaiBA) { Provider provider = new Provider(); string sql = string.Format("update LoaiBan set SucChua={0} where Maloai='{1}'", loaiBA.SucChua, loaiBA.MaLoai); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatMonAn_Commit(MonAn_DTO MonAn, int maMonAn) { Provider provider = new Provider(); string sql = string.Format("update MonAn set TenMon=N'{0}',Gia='{1}',DonViTinh='{2}' where MaMon='{3}'", MonAn.tenmon, MonAn.Gia, MonAn.Dvtinh, maMonAn); sql += " commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatBanAn(BanAn_DTO BanAn) { Provider provider = new Provider(); string sql = string.Format("update BanAn set TrangThai={0} where MaBan={1}", BanAn.TrangThai, BanAn.MaBan); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemLoaiMonAn_XungDot(LoaiMonAn_DTO loaiMonAn) { Provider provider = new Provider(); string sql = string.Format("begin tran insert into LoaiMonAn values('{0}',N'{1}') ", loaiMonAn.Maloai, loaiMonAn.Tenloai); sql += " waitfor delay '0:0:20' Rollback Commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemBanAn(BanAn_DTO BanAn, string maNH) { Provider provider = new Provider(); string sql = string.Format("insert into BanAn values ({0},'{1}','{2}',{3})", BanAn.MaKhuVuc, BanAn.LoaiBan, maNH, BanAn.TrangThai); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int XoaBanAn(string maBan) { Provider provider = new Provider(); string sql = string.Format("delete BanAn where MaBan={0}", maBan); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemLoaiMonAn(LoaiMonAn_DTO loaiMonAn) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiMonAn values('{0}',N'{1}') ", loaiMonAn.Maloai, loaiMonAn.Tenloai); // sql += " waitfor delay '0:0:20' Rollback Commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public void UpdateTrangThaiBanAn(int maban, int trangthai) { SqlCommand cm = provider.CreateCommandStoreName("sp_UpdateTrangThaiBanAn"); cm.Parameters.Add("@maban", SqlDbType.Int); cm.Parameters.Add("@trangthai", SqlDbType.Int); cm.Parameters["@maban"].Value = maban; cm.Parameters["@trangthai"].Value = trangthai; provider.ExecuteInsertUpdateDelete(cm); }
public static int CapNhatMonAn_Commit(MonAn_DTO MonAn, int maMonAn) { Provider provider = new Provider(); string sql = string.Format("update MonAn set TenMon=N'{0}',Gia='{1}',DonViTinh='{2}' where MaMon='{3}'", MonAn.tenmon, MonAn.Gia, MonAn.Dvtinh, maMonAn); sql += " commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public int ThemDatBan(DatBan_DTO bandat) { // Provider provider = new Provider(); DateTime t = DateTime.Parse(bandat.ThoiGianDen); string thoigianden = t.ToString("MM/dd/yyyy"); if (bandat.Sdt == "") { bandat.Sdt = "0"; } string sql = string.Format("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED begin tran insert into DatBan values({0},{1},{2},'{3}',{4},'{5}',{6})", bandat.MaNH, bandat.MaBan, bandat.MaKhachHang, DateTime.Now.ToString("MM/dd/yyyy"), 0, thoigianden, bandat.Sdt);//0 ban dat sql += " waitfor delay '0:0:5'"; sql += "declare @sdt int "; sql += "select @sdt=sdt from DatBan where maban=" + bandat.MaBan; sql += " if @sdt=0"; sql += " rollback tran"; sql += " else commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int XoaMonAn(int mode, int maMonAn) { Provider provider = new Provider(); //chua xu ly nha hang // string sql = string.Format("delete MonAn where MaMon={0}", maMonAn); string store = "sp_XoaMonAn"; if (mode == 3) { store = "sp_XoaMonAn_Fix"; } SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@maMon", SqlDbType.Int); cm.Parameters["@maMon"].Value = maMonAn; return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int CapNhatMonAn(int mode,MonAn_DTO MonAn, int maMonAn) { Provider provider = new Provider(); string store="sp_CapNhatMonAn"; if(mode==3) store = "sp_CapNhatMonAn_Fix"; //chua xu ly nha hang // string sql = string.Format("update MonAn set TenMon=N'{0}',Gia='{1}',DonViTinh='{2}' where MaMon='{3}' and MaNH='{4}'", MonAn.tenmon, MonAn.Gia, MonAn.Dvtinh, maMonAn,maNH); SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@TenMon", SqlDbType.NVarChar, 50); cm.Parameters.Add("@gia", SqlDbType.Money); cm.Parameters.Add("@DVTinh", SqlDbType.NVarChar, 10); cm.Parameters.Add("@MaMon", SqlDbType.Int); cm.Parameters["@TenMon"].Value = MonAn.tenmon; cm.Parameters["@gia"].Value = MonAn.Gia; cm.Parameters["@DVTinh"].Value = MonAn.Dvtinh; cm.Parameters["@MaMon"].Value = maMonAn; return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemMonAn(int mode,MonAn_DTO MonAn,string maNH) { Provider provider = new Provider(); string store="sp_ThemMonAn"; if(mode==3) store = "sp_ThemMonAn_Fix"; //string sql = string.Format("insert into MonAn(TenMon,LoaiMon,Gia,DonViTinh,MaNH) values ('{0}','{1}','{2}','{3}','{4}')", MonAn.tenmon, MonAn.Mamon, MonAn.Gia, MonAn.Dvtinh,maNH); SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@TenMon", SqlDbType.NVarChar,50); cm.Parameters.Add("@LoaiMon", SqlDbType.NChar, 20); cm.Parameters.Add("@Gia", SqlDbType.Int); cm.Parameters.Add("@DonViTinh", SqlDbType.NVarChar, 20); cm.Parameters.Add("@MaNH", SqlDbType.NChar, 5); cm.Parameters["@TenMon"].Value = MonAn.tenmon; cm.Parameters["@LoaiMon"].Value = MonAn.Mamon; cm.Parameters["@Gia"].Value = MonAn.Gia; cm.Parameters["@DonViTinh"].Value = MonAn.Dvtinh; cm.Parameters["@MaNH"].Value = maNH; return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemLoaiNV(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiNV(MaLoai,TenLoai,Luong) values ('{0}','{1}',{2})", loaiNV.MaLoaiNV, loaiNV.TenLoaiNV, loaiNV.Luong); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int XoaMonAn(int mode,int maMonAn) { Provider provider = new Provider(); //chua xu ly nha hang // string sql = string.Format("delete MonAn where MaMon={0}", maMonAn); string store= "sp_XoaMonAn"; if(mode==3) store = "sp_XoaMonAn_Fix"; SqlCommand cm = provider.CreateCommandStoreName(store); cm.Parameters.Add("@maMon", SqlDbType.Int); cm.Parameters["@maMon"].Value = maMonAn; return provider.ExecuteInsertUpdateDelete(cm); }