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); }
private void btnThemLoaiTopping_Click(object sender, EventArgs e) { if (txtTenLoaiTopping.Text == "") { MessageBox.Show("Vui lòng nhập đủ thông tin!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } LoaiToppingDTO loaiTopping = new LoaiToppingDTO(); loaiTopping.TenLoaiTopping = txtTenLoaiTopping.Text; loaiTopping.TrangThai = true; if (LoaiToppingBUS.ThemLoaiTopping(loaiTopping)) { MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LamMoiLoaiTopping(); QLLT_LoadDachSachLoaiTopping(); dgvLoaiTopping.ClearSelection(); } else { MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); loaiTopping = null; } }
public static List <LoaiToppingDTO> LayDanhSachCTLoaiMon_LoaiTopping(int maLoaiMon) { SqlConnection connection = DataProvider.GetConnection(); string query = "SELECT DISTINCT LoaiTopping.ma_loai_topping, LoaiTopping.ten_loai_topping FROM CTLoaiMon_LoaiTopping,LoaiTopping WHERE CTLoaiMon_LoaiTopping.ma_loai_topping=LoaiTopping.ma_loai_topping AND CTLoaiMon_LoaiTopping.ma_loai_mon=@maLoaiMon AND LoaiTopping.trang_thai=1"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("@maLoaiMon", System.Data.SqlDbType.Int, 0).Value = maLoaiMon; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <LoaiToppingDTO> result = new List <LoaiToppingDTO>(); if (reader.HasRows) { while (reader.Read()) { LoaiToppingDTO loaiTopping = new LoaiToppingDTO(); loaiTopping.MaLoaiTopping = reader.GetInt32(0); loaiTopping.TenLoaiTopping = reader.GetString(1); result.Add(loaiTopping); } } command.Connection.Close(); return(result); }
public static List <LoaiToppingDTO> LayDanhSachTatCaLoaiTopping() { SqlConnection connection = DataProvider.GetConnection(); string query = "SELECT ma_loai_topping, ten_loai_topping, trang_thai FROM LoaiTopping"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <LoaiToppingDTO> result = new List <LoaiToppingDTO>(); if (reader.HasRows) { while (reader.Read()) { LoaiToppingDTO loaiTopping = new LoaiToppingDTO(); loaiTopping.MaLoaiTopping = reader.GetInt32(0); loaiTopping.TenLoaiTopping = reader.GetString(1); loaiTopping.TrangThai = reader.GetBoolean(2); result.Add(loaiTopping); } } connection.Close(); return(result); }
private void QLTP_LoadDachSachLoaiTopping() { List <LoaiToppingDTO> lsLoaiTopping = LoaiToppingBUS.LayDanhSachLoaiTopping(); cmbLoaiTopping.DataSource = lsLoaiTopping; cmbLoaiTopping.DisplayMember = "TenLoaiTopping"; cmbLoaiTopping.ValueMember = "MaLoaiTopping"; List <LoaiToppingDTO> lsLT = LoaiToppingBUS.LayDanhSachLoaiTopping(); LoaiToppingDTO ltp = new LoaiToppingDTO(); ltp.MaLoaiTopping = 0; ltp.TenLoaiTopping = "Tất cả"; lsLT.Insert(0, ltp); cmbTimKiemTheoLoaiTopping.DataSource = lsLT; }
public static List <LoaiToppingDTO> LayDanhSachLoaiTopping(string timKiem, bool trangThai) { SqlConnection connection = DataProvider.GetConnection(); string query = "SELECT ma_loai_topping, ten_loai_topping, trang_thai FROM LoaiTopping WHERE 1=1"; SqlCommand command = new SqlCommand(); if (timKiem != "") { query += " AND ten_loai_topping LIKE N'%'+@timKiem+'%'"; command.Parameters.Add("@timKiem", System.Data.SqlDbType.NVarChar, 255).Value = timKiem; } if (trangThai) { query += " AND trang_thai=1"; } else { query += " AND trang_thai=0"; } command.Connection = connection; command.CommandText = query; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <LoaiToppingDTO> result = new List <LoaiToppingDTO>(); if (reader.HasRows) { while (reader.Read()) { LoaiToppingDTO loaiTopping = new LoaiToppingDTO(); loaiTopping.MaLoaiTopping = reader.GetInt32(0); loaiTopping.TenLoaiTopping = reader.GetString(1); loaiTopping.TrangThai = reader.GetBoolean(2); result.Add(loaiTopping); } } connection.Close(); return(result); }
public static bool ThemLoaiTopping(LoaiToppingDTO loaiTopping) { SqlConnection connection = DataProvider.GetConnection(); string query = "INSERT INTO LoaiTopping (ten_loai_topping, trang_thai) VALUES (@tenLoaiTopping, @trangThai)"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("@tenLoaiTopping", System.Data.SqlDbType.NVarChar, 255).Value = loaiTopping.TenLoaiTopping; command.Parameters.Add("@trangThai", System.Data.SqlDbType.Bit, 0).Value = loaiTopping.TrangThai; command.Connection.Open(); int reader = command.ExecuteNonQuery(); connection.Close(); if (reader > 0) { return(true); } return(false); }
private void btnSuaLoaiTopping_Click(object sender, EventArgs e) { LoaiToppingDTO loaiTopping = new LoaiToppingDTO(); loaiTopping.MaLoaiTopping = Convert.ToInt32(txtMaLoaiTopping.Text); loaiTopping.TenLoaiTopping = txtTenLoaiTopping.Text; loaiTopping.TrangThai = true; if (LoaiToppingBUS.SuaLoaiTopping(loaiTopping)) { MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LamMoiLoaiTopping(); QLLT_LoadDachSachLoaiTopping(); dgvLoaiTopping.ClearSelection(); } else { MessageBox.Show("Sửa thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); loaiTopping = null; } }
public static bool SuaLoaiTopping(LoaiToppingDTO loaiTopping) { SqlConnection connection = DataProvider.GetConnection(); string query = "UPDATE LoaiTopping SET ten_loai_topping=@tenLoaiTopping, trang_thai=@trangThai WHERE ma_loai_topping=@maLoaiTopping"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("@maLoaiTopping", System.Data.SqlDbType.Int, 0).Value = loaiTopping.MaLoaiTopping; command.Parameters.Add("@tenLoaiTopping", System.Data.SqlDbType.NVarChar, 255).Value = loaiTopping.TenLoaiTopping; command.Parameters.Add("@trangThai", System.Data.SqlDbType.Bit, 0).Value = loaiTopping.TrangThai; command.Connection.Open(); int reader = command.ExecuteNonQuery(); connection.Close(); if (reader > 0) { return(true); } return(false); }
public static bool SuaLoaiTopping(LoaiToppingDTO loaiTopping) { return(LoaiToppingDAO.SuaLoaiTopping(loaiTopping)); }
public static bool ThemLoaiTopping(LoaiToppingDTO loaiTopping) { return(LoaiToppingDAO.ThemLoaiTopping(loaiTopping)); }