private void bt_xoadh_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn xóa đơn hàng?", "Lời nhắc", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
donhang dh = new donhang();
dh.MaDH = int.Parse(txt_madh.Text);
if (bllDH.Deletedonhang(dh))
{
ShowAlldonhang();
}
else
{
MessageBox.Show("Lỗi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public bool Deletedonhang(donhang dh)
{
string sql = "Delete DonHang Where MaDH=@MaDH";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MaDH", SqlDbType.Int).Value = dh.MaDH;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
return(true);
}
private void bt_suadh_Click(object sender, EventArgs e)
{
donhang dh = new donhang();
dh.MaDH = int.Parse(txt_madh.Text);
dh.NgayDH = dt_ngayDH.Value;
dh.DiachiGH = cb_dh.Text;
dh.Tongtien = double.Parse(txt_tongtien.Text);
if (bllDH.Updatedonhang(dh))
{
ShowAlldonhang();
}
else
{
MessageBox.Show("Lỗi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public bool Updatedonhang(donhang dh)
{
string sql = "Update DonHang Set MaDH=@MaSP,NgayDH=@NgayDH,DiaChiGH=@DiaCHiGH,Tongtien=@Tongtien Where MaDH=@MaDH";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MaDH", SqlDbType.Int).Value = dh.MaDH;
cmd.Parameters.Add("@NgayDH", SqlDbType.DateTime).Value = dh.NgayDH;
cmd.Parameters.Add("@DiaChiGH", SqlDbType.NVarChar).Value = dh.DiachiGH;
cmd.Parameters.Add("@Tongtien", SqlDbType.Float).Value = dh.Tongtien;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool Deletedonhang(donhang dh)
{
return(dalDH.Deletedonhang(dh));
}
public bool Updatedonhang(donhang dh)
{
return(dalDH.Updatedonhang(dh));
}