private List <CTLoaiMon_LoaiToppingDTO> LayDanhSachCheckBoxLoaiTopping(bool themLoaiMon)
{
int maLoaiMon;
if (themLoaiMon)
{
maLoaiMon = LoaiMonBUS.LayMaLoaiMonMoiNhat() + 1;
}
else
{
maLoaiMon = Convert.ToInt32(txtMaLoaiMon.Text);
}
List <CTLoaiMon_LoaiToppingDTO> lsLoaiMon_LoaiTopping = new List <CTLoaiMon_LoaiToppingDTO>();
foreach (Control ctrl in gpbLoaiTopping.Controls)
{
if (ctrl.GetType() == typeof(MetroCheckBox))
{
if (((MetroCheckBox)ctrl).Checked)
{
CTLoaiMon_LoaiToppingDTO loaiMon_LoaiTopping = new CTLoaiMon_LoaiToppingDTO();
LoaiToppingDTO loaiTopping = (LoaiToppingDTO)ctrl.Tag;
loaiMon_LoaiTopping.MaLoaiMon = maLoaiMon;
loaiMon_LoaiTopping.MaLoaiTopping = loaiTopping.MaLoaiTopping;
lsLoaiMon_LoaiTopping.Add(loaiMon_LoaiTopping);
}
}
}
return(lsLoaiMon_LoaiTopping);
}
public static bool ThemLoaiMon_LoaiTopping(CTLoaiMon_LoaiToppingDTO loaiMon_LoaiTopping)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "INSERT INTO CTLoaiMon_LoaiTopping (ma_loai_mon, ma_loai_topping) VALUES (@maLoaiMon, @maLoaiTopping)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@maLoaiMon", System.Data.SqlDbType.Int, 0).Value = loaiMon_LoaiTopping.MaLoaiMon;
command.Parameters.Add("@maLoaiTopping", System.Data.SqlDbType.Int, 0).Value = loaiMon_LoaiTopping.MaLoaiTopping;
connection.Open();
int reader = command.ExecuteNonQuery();
connection.Close();
if (reader > 0)
{
return(true);
}
return(false);
}
