public bool updateDonDatHang(DTO_DonDatHang dtoDonDatHang)
{
String SQLUpdate = "UPDATE DONDATHANG SET TENKHACHHANG = @TENKHACHHANG, SODIENTHOAI = @SODIENTHOAI, DIACHIGIAO = @DIACHIGIAO, " +
"NGAYGIAODON = @NGAYGIAODON, GIA = @GIA, MATRANGTHAI = @MATRANGTHAI " +
"WHERE MADONDATHANG = @MADONDATHANG";
try
{
conn = new DBConnection().getConnection();
conn.Open();
SqlCommand sqlCommand = new SqlCommand(SQLUpdate, conn);
sqlCommand.Parameters.AddWithValue("TENKHACHHANG", dtoDonDatHang.tenKhachHang);
sqlCommand.Parameters.AddWithValue("SODIENTHOAI", dtoDonDatHang.soDienThoai);
sqlCommand.Parameters.AddWithValue("DIACHIGIAO", dtoDonDatHang.diaChiGiao);
sqlCommand.Parameters.AddWithValue("NGAYGIAODON", dtoDonDatHang.ngayGiaoDon);
sqlCommand.Parameters.AddWithValue("GIA", dtoDonDatHang.gia);
sqlCommand.Parameters.AddWithValue("MATRANGTHAI", dtoDonDatHang.maTrangThai);
sqlCommand.Parameters.AddWithValue("MADONDATHANG", dtoDonDatHang.maDonDatHang);
sqlCommand.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public bool addDonDatHang(DTO_DonDatHang dtoDonDatHang)
{
String SQLInsert = "INSERT INTO DONDATHANG(MADONDATHANG, MANHANVIEN, TENKHACHHANG" +
", SODIENTHOAI, DIACHIGIAO, NGAYLAPDON, NGAYGIAODON, GIA, MATRANGTHAI) " +
"VALUES(@MADONDATHANG, @MANHANVIEN, @TENKHACHHANG, @SODIENTHOAI, @DIACHIGIAO" +
", @NGAYLAPDON, @NGAYGIAODON, @GIA, @MATRANGTHAI)";
try
{
conn = new DBConnection().getConnection();
conn.Open();
SqlCommand sqlCommand = new SqlCommand(SQLInsert, conn);
sqlCommand.Parameters.AddWithValue("MADONDATHANG", dtoDonDatHang.maDonDatHang);
sqlCommand.Parameters.AddWithValue("MANHANVIEN", dtoDonDatHang.maNhanVien);
sqlCommand.Parameters.AddWithValue("TENKHACHHANG", dtoDonDatHang.tenKhachHang);
sqlCommand.Parameters.AddWithValue("SODIENTHOAI", dtoDonDatHang.soDienThoai);
sqlCommand.Parameters.AddWithValue("DIACHIGIAO", dtoDonDatHang.diaChiGiao);
sqlCommand.Parameters.AddWithValue("NGAYLAPDON", dtoDonDatHang.ngayLapDon);
sqlCommand.Parameters.AddWithValue("NGAYGIAODON", dtoDonDatHang.ngayGiaoDon);
sqlCommand.Parameters.AddWithValue("GIA", dtoDonDatHang.gia);
sqlCommand.Parameters.AddWithValue("MATRANGTHAI", dtoDonDatHang.maTrangThai);
sqlCommand.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
String maĐonHang = "MDDH" + (busDonDatHang.getMaxID() + 1);
DTO_DonDatHang dtoDonDatHang = new DTO_DonDatHang(maĐonHang, "MVN01", "", "", "", "", 0, 1);
if (busDonDatHang.addDonDatHang(dtoDonDatHang))
{
Tool_ThemDonDatHang toolThemDonDatHang = new Tool_ThemDonDatHang(maĐonHang);
toolThemDonDatHang.ShowDialog();
if (toolThemDonDatHang.isClickTao)
{
loadDataDonDatHang();
}
return;
}
MessageBox.Show("Lỗi phần mềm!");
}
public bool updateDonDatHang(DTO_DonDatHang dtoDonDatHang)
{
return(dalDonDatHang.updateDonDatHang(dtoDonDatHang));
}
public bool addDonDatHang(DTO_DonDatHang dtoDonDatHang)
{
return(dalDonDatHang.addDonDatHang(dtoDonDatHang));
}
