public static bool CapNhatMon(Mon_DTO mon)
{
SqlConnection cnn = ConnectToSQL.HamKetNoi();
string str = "UPDATE MON SET Tenmon = @Tenmon, Dongia = @Dongia, Loai = @Loai WHERE Mamon = @Mamon";
SqlCommand cmd = new SqlCommand(str, cnn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Mamon", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@Tenmon", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@Dongia", SqlDbType.Float);
cmd.Parameters.Add("@Loai", SqlDbType.VarChar, 10);
cmd.Parameters["@Mamon"].Value = mon.Mamon;
cmd.Parameters["@Tenmon"].Value = mon.Tenmon;
cmd.Parameters["@Dongia"].Value = mon.Dongia;
cmd.Parameters["@Loai"].Value = mon.Loai;
cnn.Open();
int count = cmd.ExecuteNonQuery();
if (count < 1)
{
return(false);
}
cnn.Close();
return(true);
}
public static bool ThemMon(Mon_DTO mon)
{
SqlConnection kt = ConnectToSQL.HamKetNoi();
string sql = "SELECT Mamon FROM MON WHERE Mamon = @Mamon";
SqlCommand cmd1 = new SqlCommand(sql, kt);
cmd1.CommandType = CommandType.Text;
cmd1.Parameters.Add("@Mamon", SqlDbType.VarChar, 10);
cmd1.Parameters["@Mamon"].Value = mon.Mamon;
kt.Open();
SqlDataReader reader = cmd1.ExecuteReader();
int count = 0;
if (reader.Read())
{
count++;
string s = reader.GetString(0);
}
reader.Close();
if (count == 1)
{
//MessageBox.Show("Sinh vien da ton tai!");
return(false);
}
SqlConnection cnn = ConnectToSQL.HamKetNoi();
string str = "INSERT INTO MON(Mamon, Tenmon, Dongia, Loai) VALUES (@Mamon, @Tenmon, @Dongia, @Loai)";
SqlCommand cmd = new SqlCommand(str, cnn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Mamon", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@Tenmon", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@Dongia", SqlDbType.Float);
cmd.Parameters.Add("@Loai", SqlDbType.VarChar, 10);
cmd.Parameters["@Mamon"].Value = mon.Mamon;
cmd.Parameters["@Tenmon"].Value = mon.Tenmon;
cmd.Parameters["@Dongia"].Value = mon.Dongia;
cmd.Parameters["@Loai"].Value = mon.Loai;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
return(true);
}
public static bool XoaMon(Mon_DTO mon)
{
SqlConnection cnn = ConnectToSQL.HamKetNoi();
string str = "DELETE FROM MON WHERE Mamon = @Mamon";
SqlCommand cmd = new SqlCommand(str, cnn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Mamon", SqlDbType.VarChar, 10);
cmd.Parameters["@Mamon"].Value = mon.Mamon;
cnn.Open();
int count = cmd.ExecuteNonQuery();
if (count < 1)
{
return(false);
}
cnn.Close();
return(true);
}
private void btnXoaMon_Click(object sender, EventArgs e)
{
string mamon = txtMaMon.Text;
string tenmon = txtTenMon.Text;
float dongia = float.Parse(txtDonGia.Text);
string loai = comboBoxThuocLoai.Text;
Mon_DTO mon = new Mon_DTO(mamon, tenmon, dongia, loai);
bool kt = Mon_BUS.XoaMon(mon);
if (kt == false)
{
MessageBox.Show("Thao tác không thành công!");
return;
}
else
{
MessageBox.Show("Xóa món thành công!");
dataGridView2.DataSource = Mon_BUS.LoadDSMon();
bingdingMon();
}
}
public static bool CapNhatMon(Mon_DTO mon)
{
return(Mon_DAO.CapNhatMon(mon));
}
public static bool XoaMon(Mon_DTO mon)
{
return(Mon_DAO.XoaMon(mon));
}
public static bool ThemMon(Mon_DTO mon)
{
return(Mon_DAO.ThemMon(mon));
}
