public bool themHoaDon(DTO_hoadon hd)
{
try
{
conn.Open();
string SQL = string.Format(
"INSERT dbo.HOADON(MA_HD,MA_NV, MA_KH,NGAY_THANH_TOAN,HINHTHUC,MAPHONG, MA_DV) VALUES(N'{0}', N'{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}' )"
, hd.MA_HD, hd.MA_NV, hd.MA_KH, hd.NGAY_THANH_TOAN, hd.HINHTHUC, hd.MAPHONG, hd.MA_DV);
SqlCommand cmd = new SqlCommand(SQL, conn);
int kq = (int)cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(false);
}
public bool suaHoaDon(DTO_hoadon hd)
{
try
{
conn.Open();
string SQL = string.Format(
"UPDATE dbo.HOADON SET MA_NV = N'{0}', MA_KH = N'{1}', NGAY_THANH_TOAN = N'{2}', HINHTHUC = N'{3}', TONGTIEN = N'{4}', MAPHONG = N'{5}', MA_DV = N'{6}' WHERE MA_HD = N'{7}'",
hd.MA_NV, hd.MA_KH, hd.NGAY_THANH_TOAN, hd.HINHTHUC, hd.TONGTIEN, hd.MAPHONG, hd.MA_DV, hd.MA_HD);
SqlCommand cmd = new SqlCommand(SQL, conn);
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(false);
}
protected void btnorder_Click1(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["tenTK"];
string tentk = cookie.Value;
if (cookie != null && string.IsNullOrEmpty(txb_hoten.Text) && string.IsNullOrEmpty(txb_diachi.Text) && string.IsNullOrEmpty(txb_sdt.Text))
{
string tenTK = cookie.Value;
DTO_hoadon hd = new DTO_hoadon();
DTO_cthoadon cthd = new DTO_cthoadon();
TaiKhoanDTO tk = TaiKhoanBUS.LayThongTinTaiKhoan(tenTK);
hd.Tentaikhoan = tk.TenTaiKhoan;
hd.Diachi = tk.DiaChi;
hd.Ngaymua = DateTime.Now;
int tong = BUS_giohang.tinhtien(tentk) + 3;
hd.Tongtien = tong;
hd.Sdt = tk.SDT;
BUS_hoadon.themhoadon(hd);
cthd.Mahd = hd.Mahd;
cthd.Dongia = hd.Tongtien;
BUS_giohang.xoagh(tentk);
Response.Redirect("index.aspx");
}
else
{
Response.Write("<script>alert('dat hang that bai')</script>")
}
}
public static DTO_hoadon ConvertToDTO(DataRow dr)
{
DTO_hoadon hd = new DTO_hoadon();
hd.Mahd = dr["MaHD"].ToString();
hd.Tentaikhoan = dr["TenTaiKhoan"].ToString();
hd.Ngaymua = Convert.ToDateTime(dr["NgayMua"]);
hd.Tongtien = Convert.ToInt32(dr["TongTien"]);
//hd.Diachi = dr["DiaChi"].ToString();
hd.Trangthai = Convert.ToBoolean(dr["TrangThai"]);
return(hd);
}
public static bool themhoadon(DTO_hoadon hd)
{
string query = "Insert into HoaDon (MaHD, TenTaiKhoan, NgayMua, DiaChi, SDTGiaoHang, ThanhTien, TrangThai) values(@MaHD, @tentaikhoan, @ngaymua, @diachi, @sdt, @thanhtien, 1)";
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@MaHD", hd.Mahd);
param[1] = new SqlParameter("@tentaikhoan", hd.Tentaikhoan);
param[2] = new SqlParameter("@ngaymua", hd.Ngaymua);
param[3] = new SqlParameter("@diachi", hd.Diachi);
param[4] = new SqlParameter("@sdt", hd.Sdt);
param[5] = new SqlParameter("@thanhtien", hd.Tongtien);
param[6] = new SqlParameter("@trangthai", hd.Trangthai);
return(DataProvider.ExecuteInsertQuery(query, param) == 1);
}
private void btnSuaHD_Click(object sender, EventArgs e)
{
DTO_hoadon hoadon = new DTO_hoadon(txtMa_HD.Text, txtMa_NV_HD.Text, txtMa_KH_HD.Text, dtpNgay_TT.Text, txtHinh_thuc.Text, txtTong.Text, txtP.Text, txtDv.Text);
// thêm
if (bus_hoadon.suaHoaDon(hoadon))
{
MessageBox.Show("sửa thành công");
dvgHoa_don.DataSource = bus_hoadon.getHoadon();
}
else
{
MessageBox.Show("sửa không thành công");
}
}
public static string themhoadon(DTO_hoadon hd)
{
try
{
hd.Mahd = (Convert.ToInt32(DAO_hoadon.laymaHDlonnhat()) + 1).ToString("000");
}
catch (Exception e)
{
hd.Mahd = "001";
}
if (DAO_hoadon.themhoadon(hd))
{
return(hd.Mahd);
}
else
{
return(null);
}
}
public bool xoaHoaDon(DTO_hoadon hd)
{
try
{
conn.Open();
string SQL = string.Format("DELETE dbo.HOADON WHERE MA_HD='{0}'", hd.MA_HD);
SqlCommand cmd = new SqlCommand(SQL, conn);
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(false);
}
private void btnThemHD_Click(object sender, EventArgs e)
{
if (txtMa_HD.Text != " " &&
txtHinh_thuc.Text != " " && txtP.Text != " " && txtMa_KH_HD.Text != "" &&
txtMa_NV_HD.Text != "" && txtDv.Text != "")
{
DTO_hoadon hoadon = new DTO_hoadon(txtMa_HD.Text, txtMa_NV_HD.Text, txtMa_KH_HD.Text, dtpNgay_TT.Text, txtHinh_thuc.Text, txtTong.Text, txtP.Text, txtDv.Text);
// thêm
if (bus_hoadon.themHoadon(hoadon))
{
MessageBox.Show("thêm thành công");
dvgHoa_don.DataSource = bus_hoadon.getHoadon();
}
else
{
MessageBox.Show("thêm không thành công");
}
}
else
{
MessageBox.Show("xin vui lòng nhập đủ thông tin");
}
}
public bool xoaHoaDon(DTO_hoadon hd)
{
return(dao_hoadon.xoaHoaDon(hd));
}
public bool suaHoaDon(DTO_hoadon hd)
{
return(dao_hoadon.suaHoaDon(hd));
}
public bool themHoadon(DTO_hoadon hd)
{
return(dao_hoadon.themHoaDon(hd));
}
