public void suachitietsddv(ChitietsddvObject chitiet)
{
kn.connect();
SqlCommand cmd = new SqlCommand("UPDATEchitietSDDV", kn.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@MAKH", chitiet.Makh);
cmd.Parameters.Add(p);
p = new SqlParameter("@MADV", chitiet.Madv);
cmd.Parameters.Add(p);
p = new SqlParameter("@NGAYSD", chitiet.Ngaysd);
cmd.Parameters.Add(p);
p = new SqlParameter("@SLDV", chitiet.Sldv);
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 btnxoachitietdv_Click(object sender, EventArgs e)
{
try
{
ChitietsddvObject ct = new ChitietsddvObject();
ct.Makh = txtchitietmakh.Text;
ct.Madv = txtchitietmadv.Text;
Chitietsddvcontrol.deletechitietsddv(ct);
dataGridView1.DataSource = Chitietsddvcontrol.getdatachitietdv();
}
catch { }
}
private void btnsuachitietdv_Click(object sender, EventArgs e)
{
try
{
ChitietsddvObject ct = new ChitietsddvObject();
ct.Makh = txtchitietmakh.Text;
ct.Madv = txtchitietmadv.Text;
//ct.Ngaysd = DateTime.Parse(datime1.Text);
ct.Ngaysd = DateTime.Now;
ct.Sldv = Int32.Parse(txtsldv.Text);
Chitietsddvcontrol.updatechitietsddv(ct);
dataGridView1.DataSource = Chitietsddvcontrol.getdatachitietdv();
}
catch { }
}
public static void deletechitietsddv(ChitietsddvObject chitiet)
{
Chitietsddvmodel ctsd = new Chitietsddvmodel();
ctsd.xoachitietsddv(chitiet);
}
public static void updatechitietsddv(ChitietsddvObject chitiet)
{
Chitietsddvmodel ctsd = new Chitietsddvmodel();
ctsd.suachitietsddv(chitiet);
}
public static void ADDchitietsddv(ChitietsddvObject chitiet)
{
Chitietsddvmodel ctsd = new Chitietsddvmodel();
ctsd.themchitietsddv(chitiet);
}
