public void addP_thue(P_Thueobject phieu)
{
kn.connect();
SqlCommand cmd = new SqlCommand("ADDPHIEUTHUE", kn.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter P = new SqlParameter("@MAPHIEU", phieu.Maphieu);
cmd.Parameters.Add(P);
P = new SqlParameter("@MAKH", phieu.Makh);
cmd.Parameters.Add(P);
P = new SqlParameter("@NGAYLAP", phieu.Ngaylap);
cmd.Parameters.Add(P);
P = new SqlParameter("@DATCOC", phieu.Datcoc);
cmd.Parameters.Add(P);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
MessageBox.Show("Thêm mới thành công");
}
else
{
MessageBox.Show("Không thể thêm mới@@@");
}
kn.disconnect();
}
private void btnsuap_thue_Click(object sender, EventArgs e)
{
try
{
P_Thueobject ph = new P_Thueobject();
ph.Maphieu = textBox9.Text;
ph.Makh = textBox11.Text;
ph.Ngaylap = DateTime.Parse(dateTimePicker1.Text); DateTime.Parse(dateTimePicker1.Text);
ph.Datcoc = Int32.Parse(textBox12.Text);
//ph.Thanhtien = Int32.Parse(textBox13.Text);
P_Thuecontrol.updatep_thue(ph);
datap_thue.DataSource = P_Thuecontrol.getdatap_thue();
}
catch { }
}
private void btnxoap_thue_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)
{
P_Thueobject ph = new P_Thueobject();
ph.Maphieu = textBox9.Text;
ph.Ngaylap = DateTime.Now;
P_Thuecontrol.deletep_thue(ph);
datap_thue.DataSource = P_Thuecontrol.getdatap_thue();
}
}
catch { }
}
public void deleteP_thue(P_Thueobject phieu)
{
kn.connect();
SqlCommand cmd = new SqlCommand("DELETEPHIEUTHUE", kn.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter P = new SqlParameter("@MAPHIEU", phieu.Maphieu);
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 deletep_thue(P_Thueobject ph)
{
P_Thuemodel a = new P_Thuemodel();
a.deleteP_thue(ph);
}
public static void addp_thue(P_Thueobject ph)
{
P_Thuemodel a = new P_Thuemodel();
a.addP_thue(ph);
}
