public static bool updateHDB(EC_HDB cthd)
{
conn = GetData.KetNoi();
string sTruyVan = "HoaDonBan_Update";
cmd = new SqlCommand(sTruyVan, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MAHDB", SqlDbType.NVarChar).Value = cthd.MaHDB;
cmd.Parameters.Add("@NGAYBAN", SqlDbType.Date).Value = cthd.NgayBan;
cmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = cthd.MaNV;
cmd.Parameters.Add("@MAKH", SqlDbType.NVarChar).Value = cthd.MaKH;
cmd.Parameters.Add("@TONGTIEN", SqlDbType.Float).Value = cthd.TongTien;
cmd.ExecuteNonQuery();
cmd.Dispose();
try
{
GetData.ThucThiTruyVanNonQuery(sTruyVan, conn);
//Đóng kết nối
GetData.DongKetNoi(conn);
return(true);
}
catch (Exception ex)
{
//Đóng kết nối
GetData.DongKetNoi(conn);
return(false);
}
}
public static bool deleteHDB(EC_HDB cthd)
{
conn = GetData.KetNoi();
string sTruyVan = "HoaDonBan_Delete";
cmd = new SqlCommand(sTruyVan, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MAHDB", SqlDbType.NVarChar).Value = cthd.MaHDB;
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
try
{
GetData.ThucThiTruyVanNonQuery(sTruyVan, conn);
//Đóng kết nối
GetData.DongKetNoi(conn);
return(true);
}
catch (Exception ex)
{
//Đóng kết nối
GetData.DongKetNoi(conn);
return(false);
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtMaHDB.Text != "")
{
EC_HDB ban = new EC_HDB();
ban.MaHDB = txtMaHDB.Text;
if (thucthi.deleteHDB(ban))
{
MessageBox.Show("Xóa thành công");
loadData();
}
else
{
MessageBox.Show("Xóa thất bại");
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtMaHDB.Text != "")
{
EC_HDB ban = new EC_HDB();
ban.MaHDB = txtMaHDB.Text;
ban.MaKH = cbxKH.SelectedValue.ToString();
ban.NgayBan = dateNgayBan.Value;
ban.MaNV = manv;
if (txtThanhTien.Text != "")
{
ban.TongTien = float.Parse(txtThanhTien.Text);
}
if (thucthi.updateHDB(ban))
{
MessageBox.Show("Sửa thành công");
loadData();
}
else
{
MessageBox.Show("Sửa thất bại");
}
}
}
public bool deleteHDB(EC_HDB cthdn)
{
return(DA_HDB.deleteHDB(cthdn));
}
public bool updateHDB(EC_HDB cthdn)
{
return(DA_HDB.updateHDB(cthdn));
}
public bool insertHDN(EC_HDB cthdn)
{
return(DA_HDB.insertHDB(cthdn));
}
