public static void XoaDonDatHang(DDatHangDTO ddhDTO)
{
string sQuery = "delete from HoaDon where MaHD =" + ddhDTO.MaHD;
OleDbConnection con = DataProvider.TaoKetNoi();
DataProvider.ExecuteNonQuery(sQuery, con);
DataProvider.DongKetNoi(con);
}
public static void ThemChiTietHoaDon(DDatHangDTO ddhDTO)
{
string sQuery = "insert into ChiTietHoaDon(MaHD,MaSP,DonGia,SoLuong) values(" + ddhDTO.MaHD
+ "," + ddhDTO.MaSP + "," + ddhDTO.DonGiaSP + "," + ddhDTO.SoLuongSP + ")";
OleDbConnection con = DataProvider.TaoKetNoi();
DataProvider.ExecuteNonQuery(sQuery, con);
DataProvider.DongKetNoi(con);
}
public static DataTable LayChiTietHoaDon(DDatHangDTO ddhDTO)
{
string sQuery = "select * from ChiTietHoaDon where MaHD =" + ddhDTO.MaHD;
OleDbConnection con = DataProvider.TaoKetNoi();
DataTable dt = DataProvider.LayDataTable(sQuery, con);
DataProvider.DongKetNoi(con);
return(dt);
}
public static void SuaDonDatHang(DDatHangDTO ddhDTO)
{
string sQuery = "update HoaDon set TenDangNhap = '" + ddhDTO.Username + "',DiaDiemGiaoHang ='"
+ ddhDTO.DiaChi + "',SDT ='" + ddhDTO.SDT + "',TenNguoiNhan='" + ddhDTO.TenNguoiNhan + "',NgayGiao='"
+ ddhDTO.Newdelivery + "',TongTien=" + ddhDTO.TongTien + ",NgayNhapHD='" + ddhDTO.NewOrder + "' where MaHD =" + ddhDTO.MaHD;
OleDbConnection con = DataProvider.TaoKetNoi();
DataProvider.ExecuteNonQuery(sQuery, con);
DataProvider.DongKetNoi(con);
}
protected void GridView1_RowSelect(object sender, GridViewSelectEventArgs e)
{
DDatHangDTO ddhDTO = new DDatHangDTO();
ddhDTO.MaHD = int.Parse(GridView1.DataKeys[e.NewSelectedIndex]["MaHD"].ToString());
DataTable dt = DDatHangBUS.LayChiTietHoaDon(ddhDTO);
GridView2.DataSource = dt;
GridView2.DataBind();
}
public static bool ThemDonDatHang(DDatHangDTO ddhDTO)
{
string sQuery = "insert into HoaDon(TenDangNhap,DiaDiemGiaoHang,SDT,TenNguoiNhan,NgayGiao,TongTien,NgayNhapHD) values('"
+ ddhDTO.Username + "','" + ddhDTO.DiaChi + "','" + ddhDTO.SDT + "','" + ddhDTO.TenNguoiNhan + "','"
+ ddhDTO.NgayGiao + "'," + ddhDTO.TongTien + ",'" + ddhDTO.NgapNhapHD + "')";
OleDbConnection con = DataProvider.TaoKetNoi();
bool kq = DataProvider.ExecuteNonQuery(sQuery, con);
DataProvider.DongKetNoi(con);
return(kq);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow row = GridView1.Rows[e.RowIndex];
string sID = gv.DataKeys[e.RowIndex]["MaHD"].ToString();
DDatHangDTO ddhDTO = new DDatHangDTO();
ddhDTO.MaHD = int.Parse(sID);
if (gv.Rows.Count == 1)
{
CurrentPage--;
}
DDatHangBUS.XoaDonDatHang(ddhDTO);
BindItemsList();
}
catch (Exception ex)
{ }
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Session["TenDangNhap"] == null)
{
Response.Write("<script type='text/javascript'>alert('Bạn phải đăng nhập mới thực hiện được chức năng này.');</script>");
}
else
{
try
{
DDatHangDTO ddhDTO = new DDatHangDTO();
ddhDTO.Username = Session["TenDangNhap"].ToString();
string sTongTien = lblTongCong.Text.Substring(0, lblTongCong.Text.Length - 1);
ddhDTO.TongTien = int.Parse(sTongTien);
ddhDTO.TenNguoiNhan = txtNguoiNhan.Text;
ddhDTO.SDT = txtSDT.Text;
DateTime dNgayNhapHD = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
ddhDTO.NgapNhapHD = dNgayNhapHD;
DateTime dNgayGiao = new DateTime(int.Parse(ddlNam.SelectedItem.Value.ToString()), int.Parse(ddlThang.SelectedItem.Value.ToString()), int.Parse(ddlNgay.SelectedItem.Value.ToString()));
ddhDTO.NgayGiao = dNgayGiao;
ddhDTO.DiaChi = txtDiaChi.Text;
DDatHangBUS.ThemDonDatHang(ddhDTO);
DataTable dt = (DataTable)Session["GioHang"];
ddhDTO.MaHD = int.Parse(DDatHangBUS.LayMaHoaDon().ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
ddhDTO.MaSP = int.Parse(dt.Rows[i][0].ToString());
ddhDTO.SoLuongSP = int.Parse(dt.Rows[i][2].ToString());
ddhDTO.DonGiaSP = int.Parse(dt.Rows[i][3].ToString());
DDatHangBUS.ThemChiTietHoaDon(ddhDTO);
}
lblThongBao.Text = "Đặt hàng thành công.";
}
catch (Exception ex)
{
lblThongBao.Text = "Đặt hàng thất bại.";
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow row = GridView1.Rows[e.RowIndex];
string sID = gv.DataKeys[e.RowIndex]["MaHD"].ToString();
string sNewUserName = ((TextBox)(row.Cells[1].Controls[0])).Text;
string sNewAddress = ((TextBox)(row.Cells[2].Controls[0])).Text;
string sNewPhoneNumber = ((TextBox)(row.Cells[3].Controls[0])).Text;
string sNewRecipient = ((TextBox)(row.Cells[4].Controls[0])).Text;
string sNewDeliveryDate = ((TextBox)(row.Cells[5].Controls[0])).Text;
string sNewTotal = ((TextBox)(row.Cells[6].Controls[0])).Text;
string sNewOrderDay = ((TextBox)(row.Cells[7].Controls[0])).Text;
DDatHangDTO ddhDTO = new DDatHangDTO();
ddhDTO.MaHD = int.Parse(sID);
ddhDTO.Username = sNewUserName;
ddhDTO.DiaChi = sNewAddress;
ddhDTO.SDT = sNewPhoneNumber;
ddhDTO.TenNguoiNhan = sNewRecipient;
ddhDTO.Newdelivery = sNewDeliveryDate;
ddhDTO.TongTien = int.Parse(sNewTotal);
ddhDTO.NewOrder = sNewOrderDay;
DDatHangBUS.SuaDonDatHang(ddhDTO);
GridView1.EditIndex = -1;
BindItemsList();
}
catch (Exception ex)
{
Response.Write("<script type='text/javascript'>"
+ "alert('Có lỗi xảy ra. Vui Lòng điền đúng kiểu dữ liệu yêu cầu !!!');"
+ "</script>");
}
}
public static DataTable LayChiTietHoaDon(DDatHangDTO ddhDTO)
{
return(DDatHangDAO.LayChiTietHoaDon(ddhDTO));
}
public static void XoaDonDatHang(DDatHangDTO ddhDTO)
{
DDatHangDAO.XoaDonDatHang(ddhDTO);
}
public static void SuaDonDatHang(DDatHangDTO ddhDTO)
{
DDatHangDAO.SuaDonDatHang(ddhDTO);
}
public static void ThemChiTietHoaDon(DDatHangDTO ddhDTO)
{
DDatHangDAO.ThemChiTietHoaDon(ddhDTO);
}
public static bool ThemDonDatHang(DDatHangDTO ddhDTO)
{
return(DDatHangDAO.ThemDonDatHang(ddhDTO));
}
