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