public static bool ThemHoaDonMonAn(string soHoaDon, string ma, int soLuong)
{
string query = "EXEC uspThemHangHoaDon @soHoaDon,@ma,@soLuong";
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@soHoaDon", SqlDbType.VarChar)
{
IsNullable = false, Value = soHoaDon
},
new SqlParameter("@ma", SqlDbType.VarChar)
{
IsNullable = false, Value = ma
},
new SqlParameter("@soLuong", SqlDbType.Int)
{
IsNullable = false, Value = soLuong
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
//public static int TinhTienGio(string soHoaDon, DateTime, gioRa)
//{
// string query = "EXEC uspThanhToanPhong @soHoaDon";
// List<SqlParameter> parameters = new List<SqlParameter>()
// {
// new SqlParameter("@soHoaDon",SqlDbType.VarChar){IsNullable=false,Value=soHoaDon }
// };
// int result = 0;
// try
// {
// result = (int)Dataprovider.ExcuteScalar(query, parameters.ToArray());
// }
// catch (Exception ex)
// {
// Utility.Log(ex);
// }
// return result == 0 ? false : true;
//}
public static bool ThanhToan(string soHoaDon, DateTime gioRa, int thanhTien, int giamGia)
{
string query = "EXEC uspThanhToanPhong @soHoaDon,@gioRa,@thanhTien,@giamGia";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@soHoaDon", SqlDbType.VarChar)
{
IsNullable = false, Value = soHoaDon
},
new SqlParameter("@gioRa", SqlDbType.DateTime)
{
IsNullable = false, Value = gioRa
},
new SqlParameter("@thanhTien", SqlDbType.Int)
{
IsNullable = false, Value = thanhTien
},
new SqlParameter("@giamGia", SqlDbType.Int)
{
IsNullable = false, Value = giamGia
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool GiaoHang(string soPhieuNhap, string nguoiGiao)
{
string query = "EXEC uspGiaoSanPham @soPhieuNhap,@nguoiGiao";
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@soPhieuNhap", SqlDbType.NVarChar)
{
IsNullable = false, Value = soPhieuNhap
},
new SqlParameter("@nguoiGiao", SqlDbType.NVarChar)
{
IsNullable = false, Value = nguoiGiao
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool NhanPhongDatTruoc(string soHoaDon)
{
string query = "EXEC uspNhanPhong @soHoaDon,@NgayNhan";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@soHoaDon", SqlDbType.VarChar)
{
Value = soHoaDon
},
new SqlParameter("@soHoaDon", SqlDbType.DateTime)
{
Value = DateTime.Now
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool DatCocTien(uint tienDatCoc, string soHD)
{
string query = "UPDATE HOADON SET tienDatCoc=@tienDatCoc WHERE SOHD=@soHD";
int num = 0;
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@tienDatCoc", SqlDbType.Int)
{
IsNullable = false, Value = tienDatCoc
},
new SqlParameter("@soHD", SqlDbType.VarChar)
{
IsNullable = false, Value = soHD
},
};
try
{
num = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(num == 1 ? true : false);
}
public static bool ChuyenPhong(string phongHienTai, string phongChuyen)
{
string query = "EXEC uspChuyenPhong @maPhongHienTai,@maPhongChuyen ";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maPhongHienTai", SqlDbType.VarChar)
{
Value = phongHienTai
},
new SqlParameter("@maPhongChuyen", SqlDbType.VarChar)
{
Value = phongChuyen
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool ThemKhachHang(KhachHang khachHang)
{
int rowNum = 0;
string query = "EXEC usp_ThemKhachHang @tenKH,@loaiKH,@sdt";
string tenKH = khachHang.Ten;
int loaiKH = khachHang.LoaiKH;
string sdt = khachHang.SDT;
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@tenKH", SqlDbType.NVarChar)
{
IsNullable = false, Value = tenKH
},
new SqlParameter("@loaiKH", SqlDbType.Int)
{
IsNullable = true, Value = loaiKH != 0?loaiKH:0
},
new SqlParameter("@sdt", SqlDbType.NVarChar)
{
IsNullable = true, Value = sdt ?? (Object)DBNull.Value
}
};
try
{
rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (SqlException ex)
{
Utility.Log(ex);
}
return(rowNum > 0 ? true : false);
}
public static bool XoaKhuyenMai(int maKhuyenMai)
{
string query = "EXEC uspXoaKhuyenMai @maKhuyenMai";
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maKhuyenMai", SqlDbType.Int)
{
IsNullable = false, Value = maKhuyenMai
}
};
try
{
//nếu số dòng thành công trả về lớn hơn 0 thì thành công
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool CapNhatLoaiKH(LoaiKhachHang loaiKhach)
{
int rowNum = 0;
int maLoaiKH = loaiKhach.MaLoaiKH;
string tenLoaiKH = loaiKhach.TenLoaiKH;
float mucKM = loaiKhach.MucKM;
string query = "EXEC usp_CapNhatLoaiKH @maLoaiKH,@tenLoaiKH,@mucKM";
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@maLoaiKH", SqlDbType.Int)
{
Value = maLoaiKH
},
new SqlParameter("@tenLoaiKH", SqlDbType.VarChar)
{
Value = tenLoaiKH
},
new SqlParameter("@mucKM", SqlDbType.Float)
{
Value = mucKM
},
};
try
{
rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
}
return(rowNum > 0 ? true : false);
}
public static bool CapNhatSanPham(SanPham sanPham)
{
string query = "EXEC uspCapNhatSanPham @ma,@ten,@maNhaCungCap,@maLoai,@donViTinh,@donGia,@soLuongToiThieu,@anhMinhHoa,@donGiaNhap";
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@ma", SqlDbType.NVarChar)
{
IsNullable = false, Value = sanPham.Ma
},
new SqlParameter("@ten", SqlDbType.NVarChar)
{
IsNullable = false, Value = sanPham.Ten
},
new SqlParameter("@maNhaCungCap", SqlDbType.NVarChar)
{
IsNullable = false, Value = sanPham.NhaCungCap
},
new SqlParameter("@maLoai", SqlDbType.VarChar)
{
IsNullable = false, Value = sanPham.Loai
},
new SqlParameter("@donViTinh", SqlDbType.NVarChar)
{
IsNullable = false, Value = sanPham.DonViTinh
},
new SqlParameter("@donGia", SqlDbType.Int)
{
IsNullable = false, Value = sanPham.Gia
},
new SqlParameter("@soLuongToiThieu", SqlDbType.Int)
{
IsNullable = false, Value = sanPham.SoLuongToiThieu
},
new SqlParameter("@anhMinhHoa", SqlDbType.NVarChar)
{
IsNullable = false, Value = sanPham.TenHinhAnh
},
new SqlParameter("@donGiaNhap", SqlDbType.Int)
{
IsNullable = false, Value = sanPham.DonGiaNhap
},
};
//nếu số dòng thành công trả về lớn hơn 0 thì thành công
int num = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
if (num == 0)
{
return(false);
}
return(true);
}
public static bool ThemPhong(Phong phong)
{
string query = "EXEC uspTaoPhong @maloaiphong";
string ma = TaoMa.TaoMaPhong();
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maloaiphong", SqlDbType.NVarChar)
{
Value = phong.TenLoai
}
};
return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0);
}
public static bool CapNhatkhuyenMai(KhuyenMai khuyenMai, List <int> listLoaiKhachHang, List <float> listMucKhuyenMai)
{
string query = "EXEC uspCapNhatKhuyenMai @maKhuyenMai,@tenKhuyenMai,@danhSachmaLoaiKhachHang,@danhSachMucKhuyenMai,@NgayBatDau,@NgayKetThuc";
string danhSachLoaiKhachHang = String.Join("|", listLoaiKhachHang);
string danhSachMucKhuyenMai = String.Join("|", listMucKhuyenMai);
// Truyền tham số
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maKhuyenMai", SqlDbType.NVarChar)
{
IsNullable = false, Value = khuyenMai.MaKhuyenMai
},
new SqlParameter("@tenKhuyenMai", SqlDbType.NVarChar)
{
IsNullable = false, Value = khuyenMai.TenKhuyenMai
},
new SqlParameter("@danhSachmaLoaiKhachHang", SqlDbType.VarChar)
{
IsNullable = false, Value = danhSachLoaiKhachHang
},
new SqlParameter("@danhSachMucKhuyenMai", SqlDbType.VarChar)
{
IsNullable = false, Value = danhSachMucKhuyenMai
},
new SqlParameter("@NgayBatDau", SqlDbType.DateTime2)
{
IsNullable = false, Value = khuyenMai.NgayBatDau
},
new SqlParameter("@NgayKetThuc", SqlDbType.DateTime2)
{
IsNullable = false, Value = khuyenMai.NgayKetThuc
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool SuaThietBi(ThietBi thietBi)
{
string query = "EXEC [usp_SuaThietBi] @ma,@tenTB,@maNCC,@dvt ,@donGia";
string tenTB = thietBi.Ten;
string maNCC = thietBi.MaNCC;
string dvt = thietBi.DVT;
string donGia = thietBi.DonGia;
bool rs = false;
// Truyền tham số
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@ma", SqlDbType.NVarChar)
{
IsNullable = false, Value = thietBi.Ma
},
new SqlParameter("@tenTB", SqlDbType.NVarChar)
{
IsNullable = false, Value = tenTB
},
new SqlParameter("@maNCC", SqlDbType.NVarChar)
{
IsNullable = false, Value = maNCC
},
new SqlParameter("@dvt", SqlDbType.NVarChar)
{
IsNullable = false, Value = dvt
},
new SqlParameter("@donGia", SqlDbType.BigInt)
{
IsNullable = false, Value = donGia
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
rs = true;
}
catch (Exception ex)
{
Utility.Log(ex);
rs = false;
}
return(rs);
}
public static bool ThemChiTietHoaDon(string mahd, List <string> listMa, List <string> listSoLuongMa, List <string> listSp, List <string> listSoLuongSp)
{
string query = "EXEC uspThemChiTietHoaDon @maHD,@danhSachMa,@danhSachSoLuongMa,@danhSachSp,@danhSachSoLuongSp";
string danhSachMa = String.Join("|", listMa);
string danhSachSoLuongMa = String.Join("|", listSoLuongMa);
string danhSachSp = String.Join("|", listSp);
string danhSachSoLuongSp = String.Join("|", listSoLuongSp);
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maHD", SqlDbType.NVarChar)
{
IsNullable = false, Value = mahd
},
new SqlParameter("@danhSachMa", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachMa
},
new SqlParameter("@danhSachSoLuongMa", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachSoLuongMa
},
new SqlParameter("@danhSachSp", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachSp
},
new SqlParameter("@danhSachSoLuongSp", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachSoLuongSp
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool CapNhatPhong(Phong phong)
{
string query = "EXEC uspCapNhatPhong @maphong,@maloaiphong";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maphong", SqlDbType.NVarChar)
{
Value = phong.Ten
},
new SqlParameter("@maloaiphong", SqlDbType.NVarChar)
{
Value = phong.TenLoai
}
};
return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0);
}
public static string TaoHoaDon()
{
string query = "select macuoi,soma,tiento from taoma where id=3";
DataTable table = Dataprovider.ExcuteQuery(query);
DataRow row = table.Rows[0];
int maCuoi = int.Parse(row["macuoi"].ToString()) + 1;
int soMa = int.Parse(row["soma"].ToString());
string tienTo = row["tiento"].ToString();
string maMoi = tienTo + maCuoi.ToString().PadLeft(soMa, '0');
query = "update taoma set macuoi=macuoi+1 where id=3";
int num = Dataprovider.ExcuteNonQuery(query);
if (num == 0)
{
maMoi = "";
}
return(maMoi);
}
public static bool GhiNhanDatPhong(KhachHang khachHang, string maPhong, string maNV)
{
string query = "EXEC uspGhiNhanDatPhong @maPhong,@tenKhachHang,@soDienThoai,@soHoaDon,@maNV";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maPhong", SqlDbType.VarChar)
{
Value = maPhong
},
new SqlParameter("@tenKhachHang", SqlDbType.NVarChar)
{
Value = khachHang.Ten
},
new SqlParameter("@soDienThoai", SqlDbType.VarChar)
{
Value = khachHang.SoDT
},
new SqlParameter("@soHoaDon", SqlDbType.VarChar)
{
Value = ""
},
new SqlParameter("@maNV", SqlDbType.VarChar)
{
Value = maNV
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool CapNhatSuDungThietBi(string maSuDung, string lyDo, List <string> listMa, List <string> listSoLuong)
{
string query = "EXEC uspCapNhatSuDungThietBi @maSuDung,@lyDo,@danhSachThietBi,@danhSachSoLuong";
string danhSachMa = String.Join("|", listMa);
string danhSachSoLuong = String.Join("|", listSoLuong);
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maSuDung", SqlDbType.NVarChar)
{
IsNullable = false, Value = maSuDung
},
new SqlParameter("@lyDo", SqlDbType.NVarChar)
{
IsNullable = false, Value = lyDo
},
new SqlParameter("@danhSachThietBi", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachMa
},
new SqlParameter("@danhSachSoLuong", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachSoLuong
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool NhapHang(string soPhieuNhap, List <string> listMa, List <string> listSoLuong, uint thanhTien)
{
string query = "EXEC uspNhapHangSanPham @soPhieuNhap,@danhSachMa,@danhSachSoLuong,@thanhTien";
string danhSachMa = String.Join("|", listMa);
string danhSachSoLuong = String.Join("|", listSoLuong);
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@soPhieuNhap", SqlDbType.NVarChar)
{
IsNullable = false, Value = soPhieuNhap
},
new SqlParameter("@danhSachMa", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachMa
},
new SqlParameter("@danhSachSoLuong", SqlDbType.NVarChar)
{
IsNullable = false, Value = danhSachSoLuong
},
new SqlParameter("@thanhTien", SqlDbType.Int)
{
IsNullable = false, Value = thanhTien
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public static bool XoaLoaiKH(LoaiKhachHang loaiKhach)
{
int rowNum = 0;
int maLoaiKH = loaiKhach.MaLoaiKH;
string query = "EXEC usp_XoaLoaiKH @maLoaiKH";
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@maLoaiKH", SqlDbType.Int)
{
Value = maLoaiKH
},
};
try
{
rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
}
return(rowNum > 0 ? true : false);
}
public static bool XoaThietBi(ThietBi thietBi)
{
string query = "EXCUTE usp_XoaThietBi @maTB";
string maTB = thietBi.Ma;
// Truyền tham số
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maTB", SqlDbType.Char)
{
IsNullable = false, Value = maTB
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
return(true);
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
}
public static bool XoaKhachHang(KhachHang khachHang)
{
int rowNum = 0;
string query = "EXEC usp_XoaKhachHang @maKH";
string maKH = khachHang.Ma;
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@maKH", SqlDbType.NVarChar)
{
IsNullable = false, Value = maKH
},
};
try
{
rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (SqlException ex)
{
Utility.Log(ex);
}
return(rowNum > 0 ? true : false);
}
