protected void gvHoaDon_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int mahd = int.Parse(gvHoaDon.DataKeys[e.NewSelectedIndex].Value.ToString());
Session["MaHoaDon"] = mahd;
HoaDon hd = new HoaDon();
BUS_HoaDon bus = new BUS_HoaDon();
hd = bus.LayThongTinHD(mahd);
txtMaHD.Text = hd.MAHD.ToString();
txtTenKH.Text = hd.HOTEN;
txtNgayLapHD.Text = hd.NGAYLAPHD;
txtNgayGiaoHang.Text = hd.NGAYGIAOHANG;
txtDiaChi.Text = hd.DIACHIGIAOHANG;
ddlTrangThai.SelectedValue = hd.TRANGTHAI.ToString();
//load chi tiet hoa don
DataTable dt = new DataTable();
BUS_CTHD busCTHD = new BUS_CTHD();
dt = busCTHD.LoadCTHD(mahd);
gvCTHD.DataSource = dt.DefaultView;
gvCTHD.DataBind();
lblThongBao.Text = "";
}
public void LoadDSSP(bool TrangThai)
{
BUS_HoaDon bus = new BUS_HoaDon();
DataTable dt = new DataTable();
dt = bus.LoadDSHD(TrangThai);
gvHoaDon.DataSource = dt.DefaultView;
gvHoaDon.DataBind();
}
protected void gvHoaDon_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
bool trangthai = bool.Parse(ddlHoaDon.SelectedValue);
Session["hdPage"] = e.NewPageIndex;
BUS_HoaDon bus = new BUS_HoaDon();
DataTable dt = new DataTable();
dt = bus.LoadDSHD(trangthai);
gvHoaDon.DataSource = dt.DefaultView;
gvHoaDon.PageIndex = e.NewPageIndex;
gvHoaDon.DataBind();
}
public void LoadDoanhThu()
{
BUS_HoaDon bus = new BUS_HoaDon();
DataTable dt = new DataTable();
dt = bus.TinhDoanhThu();
foreach (DataRow row in dt.Rows)
{
lblTongMua.Text = row["TongMua"].ToString();
lblTongBan.Text = row["TongBan"].ToString();
lblDoanhThu.Text = row["DoanhThu"].ToString();
}
}
protected void btnXacNhan_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (DateTime.Now.CompareTo(DateTime.Parse(txtNgayGiao.Text.Trim())) > 0)
{
lblNgayGiaoHang.Text = "Ngày giao hàng nhỏ hơn ngày hiện tại !";
return;
}
if (Session["Username"] != null && Session["GioHang"] != null)
{
string uname = (string)Session["Username"];
BUS_KhachHang busKH = new BUS_KhachHang();
int MaKH = busKH.LayMaKH(uname);
string ngaylaphd = DateTime.Now.ToShortDateString();
string ngaygiaohang = txtNgayGiao.Text.Trim();
string dc = txtDCNhan.Text.Trim();
// them hoa don
BUS_HoaDon busHD = new BUS_HoaDon();
HoaDon hd = new HoaDon();
hd.MAHD = int.Parse(DateTime.Now.Millisecond.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString());
hd.NGAYLAPHD = ngaylaphd;
hd.NGAYGIAOHANG = ngaygiaohang;
hd.MAKH = MaKH;
hd.DIACHIGIAOHANG = dc;
busHD.ThemHD(hd);
//them chi tiet hoa don
BUS_CTHD busCTHD = new BUS_CTHD();
ArrayList giohang = (ArrayList)Session["GioHang"];
ArrayList chitietHD = new ArrayList();
foreach (SanPham sp in giohang)
{
CTHD cthd = new CTHD();
cthd.MAHD = hd.MAHD;
cthd.MASP = sp.MaSP;
cthd.MASIZE = sp.MASIZE;
cthd.SOLUONG = sp.SoLuong;
cthd.DONGIA = sp.GiaBan;
busCTHD.ThemCTHD(cthd);
chitietHD.Add(cthd);
}
Session["chitietHD"] = chitietHD;
Session["GioHang"] = null;
Response.Redirect("thanhcong.htm");
}
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (Session["MaHoaDon"] != null)
{
BUS_HoaDon bus = new BUS_HoaDon();
int mahd = int.Parse(Session["MaHoaDon"].ToString());
HoaDon hd = new HoaDon();
hd.MAHD = mahd;
hd.DIACHIGIAOHANG = txtDiaChi.Text;
hd.TRANGTHAI = bool.Parse(ddlTrangThai.SelectedValue);
bus.CapNhatHD(hd);
if (hd.TRANGTHAI.Equals(true))
{
foreach (GridViewRow row in gvCTHD.Rows)
{
int masp = int.Parse(row.Cells[1].Text);
bus.CapNhatSoLuong(masp);
}
}
lblThongBao.Text = "";
bool trangthai = bool.Parse(ddlHoaDon.SelectedValue);
int page = int.Parse(Session["hdPage"].ToString());
DataTable dt = new DataTable();
dt = bus.LoadDSHD(trangthai);
gvHoaDon.DataSource = dt.DefaultView;
gvHoaDon.PageIndex = page;
gvHoaDon.DataBind();
Session["MaHoaDon"] = null;
}
else
{
lblThongBao.Text = "Chưa chọn hóa đơn cần cập nhật.";
}
}
