public int UpdateMenuCategory(MenuCategoryData menuCategory)
{
Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>();
sqlStoredProcedureParams.Add("maLoaiMon", menuCategory.MenuCategoryId);
sqlStoredProcedureParams.Add("tenLoaiMon", menuCategory.MenuCategoryName);
return provider.ExecuteNonQuery("LOAIMON_proc_update", sqlStoredProcedureParams);
}
public List<MenuItemData> GetAllMenuItem(MenuCategoryData menuCategory)
{
List<MenuItemData> listMenuItem = new List<MenuItemData>();
Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>();
sqlStoredProcedureParams.Add("maLoaiMon", menuCategory.MenuCategoryId);
DataTable dt = provider.ExecuteReader("MONAN_proc_load_with_MaLoaiMon", sqlStoredProcedureParams);
foreach (DataRow row in dt.Rows)
{
MenuItemData MenuItem = new MenuItemData();
MenuItem.MenuItemId = row["MaMonAn"].ToString();
MenuItem.MenuItemName = row["TenMonAn"].ToString();
MenuItem.ImagePath = row["HinhAnh"].ToString();
MenuItem.Price = Decimal.Parse(row["DonGia"].ToString());
MenuItem.Unit = new UnitData
{
UnitId = row["MaDonVi"].ToString(),
UnitName = row["TenDonVi"].ToString()
};
MenuItem.MenuCategory = new MenuCategoryData
{
MenuCategoryId = row["MaLoaiMon"].ToString(),
MenuCategoryName = row["TenLoaiMon"].ToString()
};
listMenuItem.Add(MenuItem);
}
return listMenuItem;
}
public List<MenuCategoryData> GetAllMenuCategory()
{
List<MenuCategoryData> listMenuCategory = new List<MenuCategoryData>();
DataTable dt = provider.ExecuteReader("LOAIMON_proc_load");
foreach (DataRow row in dt.Rows)
{
MenuCategoryData menuCategory = new MenuCategoryData();
menuCategory.MenuCategoryId = row["MaLoaiMon"].ToString();
menuCategory.MenuCategoryName = row["TenLoaiMon"].ToString();
listMenuCategory.Add(menuCategory);
}
return listMenuCategory;
}
private void btnDongY_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtTenLoaiMon.Text.Trim()))
{
MessageDialogHelper.CreateErrorMessage("Tên loại món ăn không được để trống.");
return;
}
MenuCategoryData menuCategoryData = new MenuCategoryData();
menuCategoryData.MenuCategoryName = txtTenLoaiMon.Text.Trim();
LocatorBll.MenuCategoryAndMenuItemBll.MenuCategoryToSave = menuCategoryData;
if (LocatorBll.MenuCategoryAndMenuItemBll.AddMenuCategory())
{
if (MessageDialogHelper.CreateInformationMessage("Lưu thành công.") == DialogResult.OK)
this.Close();
}
}