private async void loadBan()
{
picBoxLoadingTable.Show();
picBoxLoadingTable.Update();
OptimizedPerformance.fromTableToDgv(await objBan.loadTableBan(), dgvban, "ban");
picBoxLoadingTable.Hide();
}
private async void loadNhanVien(String input)
{
picBoxLoadingStaff.Show();
picBoxLoadingStaff.Update();
DataTable table = await objNhanVien.loadTableNhanVien(input, cbbtimtheonhanvien.Text);
OptimizedPerformance.fromTableToDgv(table, dgvnhanvien, "nhanvien");
picBoxLoadingStaff.Hide();
}
//--------------------------------------------
#region Khách hàng
public async void loadKhachHang(string input)
{
picBoxKhachHang.Show();
picBoxKhachHang.Update();
DataTable table = await new KhachHang().loadTableKhachHang(input, cbbtimtheokh.Text);
OptimizedPerformance.fromTableToDgv(table, dgvKhachhang, "khachhang");
picBoxKhachHang.Hide();
}
private async void loadMonan(String input = "")
{
picBoxLoadingFoods.Show();
picBoxLoadingFoods.Update();
if (String.IsNullOrWhiteSpace(input))
{
String query = "select * from monan";
DataTable table = await ConnectDataBase.SessionConnect.executeQueryAsync(query);
OptimizedPerformance.fromTableToDgv(table, dgvmonan, "monan");
}
else
{
String query = "";
if (cbbtimtheomonan.Text.Contains("Tên"))
{
query = "select * from monan where tenmon like N'%" +
input.Trim() + "%'";
}
else if (cbbtimtheomonan.Text.Contains("Mã"))
{
query = "select * from monan where mamon like '%" +
input.Trim() + "%'";
}
DataTable table = await ConnectDataBase.SessionConnect.executeQueryAsync(query);
OptimizedPerformance.fromTableToDgv(table, dgvmonan, "monan");
}
for (int i = 0; i < dgvmonan.Columns.Count; i++)
{
if (dgvmonan.Columns[i] is DataGridViewImageColumn)
{
((DataGridViewImageColumn)dgvmonan.Columns[i]).ImageLayout = DataGridViewImageCellLayout.Zoom;
break;
}
}
picBoxLoadingFoods.Hide();
}