private void btnThem_Click(object sender, EventArgs e)
{
if (ThongTinThucDonBLL.themMonAnTrongBangMonAn(tableMonAn, cboTenMonAn.Text.ToString().Trim()))
{
lblTongNangLuong.Text = ThongTinThucDonBLL.getTongNangLuong(dgvMonAn) + "(Kcal)";
}
}
public void getComboBoxMonAn()
{
cboTenMonAn.DataSource = ThongTinThucDonBLL.LayDanhSachTenVaMaMonAn();
cboTenMonAn.DisplayMember = "TenMonAn";
cboTenMonAn.ValueMember = "MaMonAn";
cboTenMonAn.Text = "";
}
private void dgvTreChuaXetThucDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex > dgvTreChuaXetThucDon.RowCount)
{
return;
}
dgvTreChuaXetThucDon.Rows[e.RowIndex].Cells[0].Value = !Convert.ToBoolean(dgvTreChuaXetThucDon.Rows[e.RowIndex].Cells[0].Value);
ckbAll.Checked = ThongTinThucDonBLL.isCheckedAll(dgvTreChuaXetThucDon);
}
void XoaThucDonCuaTre(bool isGetAll)
{
ThongTinThucDonBLL.getListTre(listTre, dgvTreDaXetThucDon, isGetAll);
if (!ThongTinThucDonBLL.HuyThongTinThucDon(listTre, cboBuoiAD.Text.ToString(), dtpNgay_Loc.Value))
{
return;
}
getDataGridViewTre();
getDataGridViewThongTinThucDonTheoMonAn();
getDataGridViewThongTinThucDonTheoNguyenLieu();
}
private void dgvTreDaXetThucDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex > dgvTreDaXetThucDon.RowCount)
{
return;
}
dgvTreDaXetThucDon.Rows[e.RowIndex].Cells[0].Value = !Convert.ToBoolean(dgvTreDaXetThucDon.Rows[e.RowIndex].Cells[0].Value);
ckbAll_TreDaXetTD.Checked = ThongTinThucDonBLL.isCheckedAll(dgvTreDaXetThucDon);
tableMonAn = MonAnBLL.setDateDgvMonAn(tableMonAn, ThongTinThucDonBLL.LayThongTinThucDonTheoTre(dgvTreDaXetThucDon.Rows[e.RowIndex].Cells["MaTre"].Value.ToString().Trim(), cboBuoiAD.Text, dtpNgay_Loc.Value));
lblTongNangLuong.Text = ThongTinThucDonBLL.getTongNangLuong(dgvMonAn) + "(Kcal)";
}
void ThemThucDonChoTre(bool isGetAll)
{
ThongTinThucDonBLL.getListTre(listTre, dgvTreChuaXetThucDon, isGetAll);
ThongTinThucDonBLL.getListMonAn(listMonAn, dgvMonAn);
if (!ThongTinThucDonBLL.LuuThongTinThucDon(listTre, listMonAn, cboBuoiAD.Text.ToString(), dtpNgay_Loc.Value))
{
return;
}
getDataGridViewTre();
getDataGridViewThongTinThucDonTheoMonAn();
getDataGridViewThongTinThucDonTheoNguyenLieu();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dgvMonAn.SelectedRows.Count == 0)
{
MessageBox.Show("Chưa chọn món ăn để xóa", "Thông báo", MessageBoxButtons.OK);
return;
}
if (ThongTinThucDonBLL.xoaMonAnTrongBangMonAn(tableMonAn, dgvMonAn.SelectedRows[0].Cells["TenMonAn"].Value.ToString().Trim()))
{
lblTongNangLuong.Text = ThongTinThucDonBLL.getTongNangLuong(dgvMonAn) + "(Kcal)";
}
}
public void getDataGridViewThongTinThucDonTheoNguyenLieu()
{
dgvThongTinThucDon_NguyenLieu.DataSource = ThongTinThucDonBLL.LayDanhSachNguyenLieuTheoBuoi(cboBuoiAD.Text.ToString().Trim(), dtpNgay_Loc.Value);
string[] column = { "MaNguyenLieu", "TenNguyenLieu", "SoLuong" };
Ultilities.ControlFormat.DataGridViewFormat(dgvThongTinThucDon_NguyenLieu, column);
dgvThongTinThucDon_NguyenLieu.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvThongTinThucDon_NguyenLieu.Columns["MaNguyenLieu"].HeaderText = "Mã nguyên liệu";
dgvThongTinThucDon_NguyenLieu.Columns["MaNguyenLieu"].Width = 120;
dgvThongTinThucDon_NguyenLieu.Columns["TenNguyenLieu"].HeaderText = "Tên nguyên liệu";
dgvThongTinThucDon_NguyenLieu.Columns["TenNguyenLieu"].Width = 120;
dgvThongTinThucDon_NguyenLieu.Columns["SoLuong"].HeaderText = "Số lượng (gam)";
dgvThongTinThucDon_NguyenLieu.Columns["SoLuong"].Width = 120;
dgvThongTinThucDon_NguyenLieu.ClearSelection();
}
public void getDataGridViewThongTinThucDonTheoMonAn()
{
dgvThongTinThucDon_MonAn.DataSource = ThongTinThucDonBLL.LayDanhSachMonAnTheoBuoi(cboBuoiAD.Text.ToString().Trim(), dtpNgay_Loc.Value);
string[] column = { "MaMonAn", "TenMonAn", "NangLuong", "SoLuong" };
Ultilities.ControlFormat.DataGridViewFormat(dgvThongTinThucDon_MonAn, column);
dgvThongTinThucDon_MonAn.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvThongTinThucDon_MonAn.Columns["MaMonAn"].HeaderText = "Mã món ăn";
dgvThongTinThucDon_MonAn.Columns["MaMonAn"].Width = 120;
dgvThongTinThucDon_MonAn.Columns["TenMonAn"].HeaderText = "Tên món ăn";
dgvThongTinThucDon_MonAn.Columns["TenMonAn"].Width = 120;
dgvThongTinThucDon_MonAn.Columns["NangLuong"].HeaderText = "Năng lượng (Kcal)";
dgvThongTinThucDon_MonAn.Columns["NangLuong"].Width = 120;
dgvThongTinThucDon_MonAn.Columns["SoLuong"].HeaderText = "Tổng suất ăn";
dgvThongTinThucDon_MonAn.Columns["SoLuong"].Width = 120;
dgvThongTinThucDon_MonAn.ClearSelection();
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (dgvThongTinThucDon_MonAn.Rows.Count <= 0)
{
MessageBox.Show("Chưa có dữ liệu nào cho bữa ăn này", "Thông báo", MessageBoxButtons.OK);
return;
}
if (ThongTinThucDonBLL.kiemTraInBaoCao(cboLop.SelectedValue.ToString().Trim(), cboBuoiAD.Text.Trim(), dtpNgay_Loc.Value))
{
Form frmBaoCaoSuatAn = new frmDinhDuong_BaoCaoSuatAn(cboLop.SelectedValue.ToString().Trim(), cboBuoiAD.Text.Trim(), dtpNgay_Loc.Value);
frmBaoCaoSuatAn.ShowDialog();
}
}
catch { }
}
public void getDataGridViewTreDaXetThucDon(string maLop, int thang, int nam)
{
setCheckBoxColumn(dgvTreDaXetThucDon);
dgvTreDaXetThucDon.DataSource = ThongTinThucDonBLL.LayDanhSachTreDaXetThucDon(maLop, thang, nam, cboBuoiAD.Text.ToString().Trim(), dtpNgay_Loc.Value);
string[] column = { "X", "MaTre", "HoTenTre", "BMI", "TinhTrang", "GhiChu" };
Ultilities.ControlFormat.DataGridViewFormat(dgvTreDaXetThucDon, column);
dgvTreDaXetThucDon.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvTreDaXetThucDon.Columns[1].HeaderText = "Mã Trẻ";
dgvTreDaXetThucDon.Columns[1].Width = 100;
dgvTreDaXetThucDon.Columns[2].HeaderText = "Tên Trẻ";
dgvTreDaXetThucDon.Columns[2].Width = 120;
dgvTreDaXetThucDon.Columns[3].HeaderText = "BMI";
dgvTreDaXetThucDon.Columns[3].Width = 50;
dgvTreDaXetThucDon.Columns[4].HeaderText = "Tình Trạng";
//dgvLop.Columns[4].Width = 100;
dgvTreDaXetThucDon.Columns[5].HeaderText = "Ghi Chú";
dgvTreDaXetThucDon.Columns[5].Width = 100;
dgvTreDaXetThucDon.ClearSelection();
}
private void ckbAll_TreDaXetTD_Click(object sender, EventArgs e)
{
ThongTinThucDonBLL.checkAllDataGridView(dgvTreDaXetThucDon, ckbAll_TreDaXetTD.Checked);
}
private void getComboboxMonAnTheoTuKhoa(ComboBox cbo)
{
cbo.DataSource = ThongTinThucDonBLL.LayDanhSachTenVaMaMonAn(cboBuoiAD.Text);
cbo.DisplayMember = "TenMonAn";
cbo.ValueMember = "MaMonAn";
}
