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