protected void btnXoa_Click(object sender, EventArgs e) { DonDatHangs dondathang = db.DonDatHangs.SingleOrDefault(p => p.MaDonHang.ToString() == GridView1.Rows[GridView1.SelectedIndex].Cells[0].Text); db.DonDatHangs.DeleteOnSubmit(dondathang); db.SubmitChanges(); var dsdonhang = from p in db.DonDatHangs select new { p.MaDonHang, p.KhachHang.TenKhachHang, p.NgayDatHang, p.TongTien, p.TinhTrang }; GridView1.DataSource = dsdonhang; GridView1.DataBind(); }
protected void btnHuyBo_Click(object sender, EventArgs e) { string makh = Request.QueryString["MaKhachHang"]; DonDatHangs dondathang = db.DonDatHangs.SingleOrDefault(p => p.MaDonHang.ToString() == GridView1.Rows[GridView1.SelectedIndex].Cells[0].Text); dondathang.TinhTrang = "Chưa sử lý"; db.SubmitChanges(); var dsdonhang = from p in db.DonDatHangs where p.MaKhachHang.ToString() == makh select new { p.MaDonHang, p.KhachHang.TenKhachHang, p.NgayDatHang, p.TongTien, p.TinhTrang }; GridView1.DataSource = dsdonhang; GridView1.DataBind(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { DonDatHangs dondathang = db.DonDatHangs.SingleOrDefault(p => p.MaDonHang.ToString() == GridView1.Rows[GridView1.SelectedIndex].Cells[0].Text); int makh = dondathang.MaKhachHang; double tongtien = 0; KhachHang kh = db.KhachHangs.SingleOrDefault(p => p.MaKhachHang == makh); var dschitiet = from p in db.ChiTietDonHangs where p.MaDonHang == dondathang.MaDonHang select new { p.MaSanPham, p.SanPhams.TenSP, p.SoLuong, DonGia = TinhGiamGia(p.SanPhams.SanPham_KhuyenMai.KhuyenMai.GiaCanGiam, Convert.ToDouble(p.SanPhams.GiaBan * p.SoLuong)) }; foreach (var giohang in dschitiet) { tongtien = tongtien + Convert.ToDouble(giohang.DonGia); } lblTongTien.Text = HienThiGia(tongtien).ToString(); lblDiaChi.Text = kh.DiaChi; lblEmail.Text = kh.Email; lblSoDienThoai.Text = kh.SoDienThoai.ToString(); lblTenKH.Text = kh.TenKhachHang; TextArea1.Value = dondathang.YeuCauKhachHang; GridView2.DataSource = dschitiet; GridView2.DataBind(); if (dondathang.TinhTrang == "Đang sử lý") { btnXuLy.Enabled = false; } if (dondathang.TinhTrang == "Chưa sử lý") { btnHuyBo.Enabled = false; } if (dondathang.TinhTrang == "Sử lý xong") { btnXuLyXong.Enabled = false; } }
protected void btnGui_Click(object sender, EventArgs e) { int makhachhang = Convert.ToInt16(Request.QueryString["MaKhachHang"]); var dsgiohang = from p in db.GioHangs where p.MaKhachHang == makhachhang select new { p.MaSanPham, p.SanPhams.TenSP, p.SoLuong, DonGia = TinhGiamGia(p.SanPhams.SanPham_KhuyenMai.KhuyenMai.GiaCanGiam, p.SanPhams.GiaBan) }; double tongtien = 0; foreach (var giohang in dsgiohang) { tongtien = tongtien + Convert.ToDouble(giohang.DonGia); } DonDatHangs dondathang = new DonDatHangs(); dondathang.MaKhachHang = makhachhang; dondathang.NgayDatHang = DateTime.Now.ToShortDateString(); dondathang.TinhTrang = "Chưa xử lý"; dondathang.TongTien = tongtien; dondathang.YeuCauKhachHang = TextArea1.Value; db.DonDatHangs.InsertOnSubmit(dondathang); db.SubmitChanges(); foreach (var giohang in dsgiohang) { ChiTietDonHang chitiet = new ChiTietDonHang(); chitiet.MaDonHang = dondathang.MaDonHang; chitiet.MaSanPham = giohang.MaSanPham; chitiet.SoLuong = Convert.ToInt16(giohang.SoLuong); db.ChiTietDonHangs.InsertOnSubmit(chitiet); db.SubmitChanges(); } Response.Write("<script> alert('Gửi thành công') </script>"); Response.Redirect("~/GioHang.aspx?MaKhachHang=" + makhachhang); }