public DashboardWindow()
{
InitializeComponent();
Global.Books = SachBUS.loadAll();
Global.Categories = TheLoaiBUS.loadAllAndConvertToFillCombobox();
Global.BookCategories = TheLoaiBUS.loadAll();
Global.Customers = KhachHangBUS.loadAll();
KiemTraQuyDinh kt = QuyDinhBUS.loadKiemTraQuyDinh();
Global.ControlRules = kt;
var rules = QuyDinhBUS.loadQuyDinh();
Global.quyDinh = rules;
Global.BookBoughtBills = new List <ChiTietHoaDonBanSachDTO>();
}
public static bool thayDoiKiemTraQuyDinh(KiemTraQuyDinh kt)
{
string sCommand = string.Format("Update SetQuyDinh set NoToiDa = {0}, LuongTonSauKhiBan = {1}, LuongNhapToiThieu = {2}, LuongTonToiThieuKhiNhap = {3}", kt.NoToiDa, kt.LuongTonSauKhiBan, kt.LuongNhapToiThieu, kt.LuongTonToiThieuKhiNhap);
con = DataProvider.openConnection();
bool result;
try
{
result = DataProvider.executeNonQuery(sCommand, con);
DataProvider.closeConnection(con);
}
catch
{
result = false;
DataProvider.closeConnection(con);
}
return(result);
}
public static KiemTraQuyDinh loadKiemTraQuyDinh()
{
string sCommand = "select* from SetQuyDinh";
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
KiemTraQuyDinh result = new KiemTraQuyDinh();
result.NoToiDa = int.Parse(dt.Rows[0]["NoToiDa"].ToString());
result.LuongTonSauKhiBan = int.Parse(dt.Rows[0]["LuongTonSauKhiBan"].ToString());
result.LuongNhapToiThieu = int.Parse(dt.Rows[0]["LuongNhapToiThieu"].ToString());
result.LuongTonToiThieuKhiNhap = int.Parse(dt.Rows[0]["LuongTonToiThieuKhiNhap"].ToString());
DataProvider.closeConnection(con);
return(result);
}
public static bool thayDoiKiemTraQuyDinh(KiemTraQuyDinh kt) => QuyDinhDAO.thayDoiKiemTraQuyDinh(kt);
