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)); }