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