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