public void suadichvu(Dichvuobject dichvu)
{
kn.connect();
SqlCommand cmd = new SqlCommand("UPDATEDV", kn.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@MADV", dichvu.Madv);
cmd.Parameters.Add(p);
p = new SqlParameter("@TENDV", dichvu.Tendv);
cmd.Parameters.Add(p);
p = new SqlParameter("@GIADV", dichvu.Giadv);
cmd.Parameters.Add(p);
p = new SqlParameter("@GHICHU", dichvu.Ghichu);
cmd.Parameters.Add(p);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
MessageBox.Show("Sửa thành công");
}
else
{
MessageBox.Show("Không thể sửa!!!");
}
kn.disconnect();
}
private void btnsuadv_Click(object sender, EventArgs e)
{
try
{
Dichvuobject dv = new Dichvuobject();
dv.Madv = txtMADV.Text;
dv.Tendv = txtTENDV.Text;
dv.Giadv = Int32.Parse(txtGIADV.Text);
dv.Ghichu = txtghichudv.Text;
Dichvucontrol.updatedv(dv);
dataGridView3.DataSource = Dichvucontrol.getdatadv();
}
catch { }
}
private void btnxoadv_Click(object sender, EventArgs e)
{
try
{
DialogResult dg = new DialogResult();
dg = MessageBox.Show("Bạn có muốn xóa không", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dg == DialogResult.Yes)
{
Dichvuobject dv = new Dichvuobject();
dv.Madv = txtMADV.Text;
Dichvucontrol.deletedv(dv);
dataGridView3.DataSource = Dichvucontrol.getdatadv();
}
}
catch { }
}
public void xoadichvu(Dichvuobject dichvu)
{
kn.connect();
SqlCommand cmd = new SqlCommand("DELETEDV", kn.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@MADV", dichvu.Madv);
cmd.Parameters.Add(p);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
MessageBox.Show("Xóa thành công");
}
else
{
MessageBox.Show("Không thể xóa!!!");
}
kn.disconnect();
}
public static void deletedv(Dichvuobject dichvu)
{
Dichvumodel dv = new Dichvumodel();
dv.xoadichvu(dichvu);
}
public static void updatedv(Dichvuobject dichvu)
{
Dichvumodel dv = new Dichvumodel();
dv.suadichvu(dichvu);
}
public static void adddv(Dichvuobject dichvu)
{
Dichvumodel dv = new Dichvumodel();
dv.themdichvu(dichvu);
}
