public int addLoaiMon(LoaiMon loaiMon)
{
int param = 2;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maLoaiMon";
names[1] = "@tenLoaiMon";
values[0] = loaiMon.MaLoaiMon;
values[1] = loaiMon.TenLoaiMon;
return db.Update("LOAIMON_proc_insert", names, values, param);
}
public List<LoaiMon> getAllLoaiMon()
{
DataTable tb = db.LoadData("LOAIMON_proc_load");
List<LoaiMon> list = new List<LoaiMon>();
foreach(DataRow row in tb.Rows)
{
LoaiMon lm = new LoaiMon();
lm.MaLoaiMon = row["MaLoaiMon"].ToString();
lm.TenLoaiMon = row["TenLoaiMon"].ToString();
list.Add(lm);
}
return list;
}
private void btnDongY_Click(object sender, EventArgs e)
{
if (txtTenLoaiMon.Text == "")
{
MessageBox.Show("Nhập tên món ăn", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTenLoaiMon.Focus();
return;
}
LoaiMon loaiMon = new LoaiMon();
loaiMon.MaLoaiMon = txtMaLoaiMon.Text.Trim();
loaiMon.TenLoaiMon = txtTenLoaiMon.Text.Trim();
if (loaimonBus.addLoaiMon(loaiMon) != 0)
{
MessageBox.Show("Đã thêm loại món mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
Global.thucDon.parseDataLoaiMon(Global.getListLoaiMon());
this.Close();
}
}
public List<MonAn> getMonAnList_With_MaLoaiMon(string maLoaiMon)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maLoaiMon";
values[0] = maLoaiMon;
DataTable tb = db.LoadData("MONAN_proc_load_with_MaLoaiMon", names, values, param);
List<MonAn> list = new List<MonAn>();
foreach (DataRow row in tb.Rows)
{
MonAn monan = new MonAn();
LoaiMon loaimon = new LoaiMon();
DonViTinh donvi = new DonViTinh();
loaimon.MaLoaiMon = row["MaLoaiMon"].ToString();
loaimon.TenLoaiMon = row["TenLoaiMon"].ToString();
monan.LoaiMon = loaimon;
monan.MaMonAn = row["MaMonAn"].ToString();
monan.TenMonAn = row["TenMonAn"].ToString();
donvi.MaDonVi = row["MaDonVi"].ToString();
donvi.TenDonVi = row["TenDonVi"].ToString();
monan.DonViTinh = donvi;
monan.HinhAnh = row["HinhAnh"].ToString();
monan.DonGia = decimal.Parse(row["DonGia"].ToString());
list.Add(monan);
}
return list;
}
public int addLoaiMon(LoaiMon loaiMon)
{
return loaimonDAO.addLoaiMon(loaiMon);
}
