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