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); }