public DonHangDTO(DonHang dh)
{
MADONHANG = dh.MADONHANG;
TONGTIEN = dh.TONGTIEN;
NGAYMUA = dh.NGAYMUA;
TKUSERNAME = dh.TKUSERNAME;
}
public ActionResult Xoadh(int[] dsxoa)
{
foreach (int Id in dsxoa)
{
DonHang x = db.DonHangs.SingleOrDefault(n => n.MaDH == Id);
CTDH c = db.CTDHs.SingleOrDefault(n => n.MaDH == Id);
db.DonHangs.DeleteOnSubmit(x);
db.CTDHs.DeleteOnSubmit(c);
}
db.SubmitChanges();
return(RedirectToAction("DonHang"));
}
static public void Add(DonHang item, List <DonHangChiTiet> items)
{
dbControl = new QlShop();
using (TransactionScope scope = new TransactionScope())
{
//cap nhat so luong ton kho thuc te luc xuat
foreach (DonHangChiTiet DonHangItem in items)
{
//DonHangItem.TonKho = SanPhamController.GetTonKho(DonHangItem.SanPhamID);
DonHangItem.GiaVon = SanPhamController.GetGiaVon(DonHangItem.SanPhamID);
//SanPhamController.CapNhatTonKho(DonHangItem.SanPhamID, DonHangItem.SoLuong);
}
dbControl.DonHangs.Add(item);
dbControl.DonHangChiTiets.AddRange(items);
//cap nhat so luong ton kho
foreach (DonHangChiTiet DonHangItem in items)
{
SanPhamController.CapNhatTonKho(DonHangItem.SanPhamID, DonHangItem.SoLuong);
}
//cap nha cong no va tong tien hang
if (item.KhachHangID != null)
{
KhachHangController.CapNhatCongNo_MuaHang(item.KhachHangID, item.ConNo, item.TongCong);
}
//21/11/2015: fanit82
//cap nha vo quy tien mat
//---------------------------------
decimal decTienMatThu = 0;
decTienMatThu = item.KhachDua == null ? 0 : (decimal)item.KhachDua;
/*
* Nếu khách đưa tiền mặt lớn hơn số tiền cần thanh toán
* thì phai thoi tien cho khach, và số tiền thực sự vô quỹ tiền mặt
* chỉ là số tiền khách thanh toán
*
*
*/
if (decTienMatThu > item.ThanhToan)
{
decTienMatThu = item.ThanhToan;
}
//decTienMatThu = item.KhachDua > item.ThanhToan ? item.ThanhToan : (decimal)item.KhachDua;
QuyTienMatController.NhapQuyTienMat(item.DonHangID, item.NgayBan, decTienMatThu, "BH", "Tiền mặt bán hàng");
//------------------end-------------
dbControl.SaveChanges();
scope.Complete();
}
}
public ActionResult Create([Bind(Include = "MaDH,SDT,NgayDat, DiaChi,GiaVanChuyen,KhuyenMai,TongTien,TinhTrangDonHang")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.DonHangs.Add(donHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SDT = new SelectList(db.Users, "SDT", "HoTen", donHang.SDT);
return(View(donHang));
}
public ActionResult Edit([Bind(Include = "SoHoaDon,MaKH,MaNV,NgayDH,NgayGH,NoiGiaoHang,TongTien,ghichu,status")] DonHang donhang)
{
if (ModelState.IsValid)
{
db.Entry(donhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donhang.MaKH);
ViewBag.MaNV = new SelectList(db.NhanViens, "MaNV", "TenNV", donhang.MaNV);
return(View(donhang));
}
public ActionResult Edit([Bind(Include = "MaDH,MaKH,MaNV,TenNguoiNhan,SoDT,DiaChi,NgayDat,TinhTrang")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.Entry(donHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donHang.MaKH);
ViewBag.MaNV = new SelectList(db.NhanViens, "MaNV", "TenNV", donHang.MaNV);
return(View(donHang));
}
public ActionResult Xoa(int MaDonHang)
{
//trả về đói tượng lapotp với điều kiện
DonHang dh = db.DonHangs.SingleOrDefault(n => n.MaDH == MaDonHang);
if (dh == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(dh));
}
public ActionResult Create([Bind(Include = "MaDH,NgayDat,NgayGiao,TinhTrangDonHang,DaThanhToan,MaKH,UuDai")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.DonHangs.Add(donHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donHang.MaKH);
return(View(donHang));
}
public bool capNhatTrangThaiThanhToan(int maDH, bool isThanhToan)
{
DonHang dhTim = db.DonHangs.FirstOrDefault(n => n.MaDH.Equals(maDH));
if (dhTim == null)
{
return(false);
}
dhTim.DaThanhToan = isThanhToan;
db.SubmitChanges();
return(true);
}
public async Task <IActionResult> Create([Bind("Id,NgayDatHang,TrangThaiDonHang,TongTien,MaKh,NguoiNhan,DiaChiGiaoHang")] DonHang donHang)
{
if (ModelState.IsValid)
{
_context.Add(donHang);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MaKh"] = new SelectList(_context.KhachHangs, "MaKh", "MaKh", donHang.MaKh);
return(View(donHang));
}
public ActionResult Create([Bind(Include = "soDH,id_KH,ngayLap,ngayGiaoHang,tongTien,tinhTrang,tenNVGiaoHang")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.DonHangs.Add(donHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_KH = new SelectList(db.User_KH, "id_KH", "id_KH", donHang.id_KH);
return(View(donHang));
}
public ActionResult AddOrEdit(DonHang d)
{
using (DBNoiThat db = new DBNoiThat())
{
//Kiểm tra và tạo thư mục đơn hàng
if (!Directory.Exists(Server.MapPath("~/storage/Don-hang")))
{
Directory.CreateDirectory(Server.MapPath("~/storage/Don-hang"));
}
//Kiểm tra và tạo thư mục cho ngày
if (!Directory.Exists(Server.MapPath("~/storage/Don-hang/" + d.ThoiGian)))
{
Directory.CreateDirectory(Server.MapPath("~/storage/Don-hang/" + d.ThoiGian));
}
if (d.ID == 0)
{
d.TinhTrangThanhToan = 0;
d.TinhTrangGiaoHang = 0;
d.TongTien = 0;
d.DaGiamGia = 0;
db.DonHangs.Add(d);
db.SaveChanges();
return(Json(new { success = true, message = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet));
}
else
{
try
{
DonHang dh = db.DonHangs.Where(p => p.ID == d.ID).FirstOrDefault();
dh.HoTen = d.HoTen;
dh.Sdt = d.Sdt;
dh.Email = d.Email;
dh.ThoiGian = d.ThoiGian;
dh.HinhThucThanhToan = d.HinhThucThanhToan;
dh.TinhTrangThanhToan = d.TinhTrangThanhToan;
dh.TinhTrangGiaoHang = d.TinhTrangGiaoHang;
dh.DaGiamGia = d.DaGiamGia;
dh.TongTien = dh.TongTien - dh.DaGiamGia;
db.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, message = "Cập nhật thất bại!" }, JsonRequestBehavior.AllowGet));
}
}
}
}
public ActionResult DatHangSubmit(string NgayGiao,string MaKM)
{
DonHang dh = new DonHang();
if (Session["TaiKhoan"] != null || Session["TaiKhoan"].ToString() == "")
{
KhachHang customer = (KhachHang)Session["TaiKhoan"];
if (ModelState.IsValid)
{
dh.MaKH = customer.MaKH;
dh.NgayDat = DateTime.Now;
if (NgayGiao.Trim() != "")
dh.NgayGiao = Convert.ToDateTime(NgayGiao);
dh.TinhTrangGiaoHang = 0;
dh.DaThanhToan = "Chưa thanh toán";
if (MaKM != "" &&MaKM!="NULL")
dh.MaKM = MaKM;
db.DonHangs.Add(dh);
db.SaveChanges();
if (MaKM != "" && MaKM != "NULL")
foreach(var item in db.KhuyenMais)
{
if (item.MaKM == MaKM.ToUpper())
{
item.DaSuDung = true;
break;
}
}
db.SaveChanges();
}
}
if (Session["ShoppingCart"] != null)
{
List<CartItem> ls = (List<CartItem>)Session["ShoppingCart"];
foreach (CartItem item in ls)
{
ChiTietDonHang CTDH = new ChiTietDonHang();
CTDH.MaDonHang = dh.MaDonHang;
CTDH.MaSach = item.productOrder.MaSach;
CTDH.SoLuong = item.Quality;
CTDH.DonGia = item.productOrder.GiaBan;
db.ChiTietDonHangs.Add(CTDH);
Sach sach = db.Saches.Find(item.productOrder.MaSach);
sach.SoLuongTon -= item.Quality;
db.SaveChanges();
}
}
Session["ShoppingCart"] = null;
return Json(new { success = "Đặt hàng thành công!!!" });
}
public ActionResult DatHang(int MaKH, bool IsThanhToan, bool IsGiaoHang)
{
ThanhVien tvSession = (ThanhVien)Session["TaiKhoan"];
List <ItemDonHang> lstDonHang = LayDonHang();
if (lstDonHang == null || lstDonHang.Count == 0)
{
return(Content("Giỏ hàng rỗng !!!"));
}
DonHang dh = new DonHang();
dh.MaKH = MaKH;
dh.NgayMua = DateTime.Now;
dh.NgayGiao = DateTime.Now;
dh.TongTien = TinhTongTien();
if (IsThanhToan == true)
{
dh.DaThanhToan = true;
}
else
{
dh.DaThanhToan = false;
}
if (IsGiaoHang == true)
{
dh.MaTinhTrang = 1;
}
else
{
dh.MaTinhTrang = 2;
}
//dh.MaHinhThuc = 1;
dh.DaXoa = false;
dh.DaHuy = false;
dh.MaThanhVIen = tvSession.MaThanhVien;
db.DonHangs.Add(dh);
db.SaveChanges();
//Thêm chi tiết đơn hàng
foreach (var item in lstDonHang)
{
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.MaDonHang = dh.MaDonHang;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuong;
ctdh.DonGia = item.DonGia;
ctdh.DaXoa = false;
db.ChiTietDonHangs.Add(ctdh);
}
db.SaveChanges();
Session["DonHang"] = null;
return(Content("Thêm đơn hàng thành công. Tổng giá trị đơn hàng là: " + TinhTongTien().ToString("#,##")));
}
public ActionResult XacNhanThanhToan() // model : thong tin cua khachhang
{
using (var db = new ApplicationDbContext())
{
var kh = new KhachHang();
var donHang = new DonHang();
var spDonHang = new SanPhamDonHang();
var sessionGioHang = Session["GioHang"] as GioHang;
// insert mot don hang roi: => DonHangId => thi dong thoi minh cung phai insert vao bang san pham don hang
kh.HoTen = Request.Form["hoTen"];
kh.SoDienThoai = Convert.ToInt32(Request.Form["soDienThoai"]);
kh.Email = Request.Form["email"];
kh.DiaChi = Request.Form["diaChi"];
int khacHangID = KhachHangDAO.Instance.insertKhacHang(kh);
// get danh sach nhan vien: (where lanhanvienkiemduyetdonhang,(12h00 -> 5h00) calamviec < nam trong khoang nay > DateTime.Now) NhanVienID
if (khacHangID != 0)
{
donHang.NhanVienID = 1;
donHang.KhachHangID = khacHangID;
donHang.NgayNhan = Convert.ToDateTime(Request.Form["ngayNhan"]);
donHang.DiaChiNhanHangChiTiet = Request.Form["diaChiNhanHang"];
donHang.GhiChu = Request.Form["ghiChu"];
donHang.GiaTriDonHang = sessionGioHang.TongTien;
var donHangId = DonHangDAO.Instance.insertDonHang(donHang);
if (donHangId != 0)
{
spDonHang.DonHangID = donHangId;
foreach (var item in sessionGioHang.Gio)
{
spDonHang.GhiChu = donHang.GhiChu;
spDonHang.SanPhamID = item.SanPham.SanPhamID;
spDonHang.SoLuong = item.SoLuong;
SanPhamDonHangDAO.Instance.insertSanPhamDonHang(spDonHang);
}
}
ViewBag.DonHangID = donHangId;
string content = System.IO.File.ReadAllText(System.Web.HttpContext.Current.Server.MapPath("~/assets/client/template/neworder.html"));
content = content.Replace("{{cstomerName}}", kh.HoTen);
content = content.Replace("{{SDT}}", kh.SoDienThoai.ToString());
content = content.Replace("{{Email}}", kh.Email);
content = content.Replace("{{DiaChi}}", kh.DiaChi);
content = content.Replace("{{TongTien}}", donHang.GiaTriDonHang.ToString());
var toEmailAddr = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
var mailHelper = new MailHelper();
//mailHelper.SendMail(kh.Email, "Don hang moi tu website ban hang cua ban", content);
mailHelper.SendMail(toEmailAddr, "Don hang moi tu website ban hang cua ban", content);
}
// Send
return(View());
}
}
public bool Insert(DonHang donhang)
{
try
{
db.DonHangs.Add(donhang);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public ActionResult Sua(int MaDH)
{
//Lấy ra đối tượng sách theo mã
ViewBag.listKH = new SelectList(db.KhachHangs, "MaKH", "TenKH");
DonHang DonHang = db.DonHangs.SingleOrDefault(n => n.MaDH == MaDH);
if (DonHang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(DonHang));
}
public long insert(DonHang entity)
{
try
{
db.DonHangs.Add(entity);
db.SaveChanges();
return(entity.MaDonHang);
}
catch (Exception e)
{
return(-1);
}
}
// GET: TacGia/Details/5
public ActionResult HienThi(int maDonHang)
{
DonHang donHang = db.DonHangs.SingleOrDefault(n => n.MaDonHang == maDonHang);
if (donHang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(donHang));
//return View();
}
public ActionResult XacnhanxoaDonhang(int id)
{
DonHang dh = db.DonHangs.SingleOrDefault(n => n.IdDonHang == id);
if (dh == null)
{
Response.StatusCode = 404;
return(null);
}
db.DonHangs.DeleteOnSubmit(dh);
db.SubmitChanges();
return(RedirectToAction("QLDonhang"));
}
public ActionResult Create(DonHang model)
{
if (ModelState.IsValid)
{
db.DonHangs.Add(model);
db.SaveChanges();
return(RedirectToAction("DSDonHang"));
}
else
{
return(View(model));
}
}
// insert
public int insertDonHang(DonHang donHang)
{
try
{
db.DonHangs.Add(donHang);
db.SaveChanges();
return(donHang.DonHangID);
}
catch (Exception)
{
return(0); // them that bai
}
}
private void tbxSDTInput_TextChanged(object sender, EventArgs e)
{
if (mListDonHang.FirstOrDefault(x => x.SDT.Contains(tbxSDTInput.Text)) == null)
{
ClearThongTinDonHang();
}
else
{
DonHang _donhang = mListDonHang.FirstOrDefault(x => x.SDT.Contains(tbxSDTInput.Text));
MaDonChon = _donhang.MaDonHang;
DienThongTinDonHang(_donhang);
}
}
public ActionResult XacNhanXoa(int MaDonHang)
{
DonHang dh = db.DonHangs.SingleOrDefault(n => n.MaDonHang == MaDonHang);
if (dh == null)
{
Response.StatusCode = 404;
return(null);
}
db.DonHangs.Remove(dh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool ThemMoi(DonHang ma)
{
try
{
db.DonHangs.Add(ma);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void xoaDonHang(DonHang DonHang)
{
sessionManager.BeginTransaction();
try
{
session.Delete(DonHang);
sessionManager.CommitTransaction();
}
catch (HibernateException ex)
{
throw new DataException(ex.Message, ex);
}
}
public IActionResult taoDonHangs(DonHang donHang)
{
context.Add(donHang);
context.SaveChanges();
// for (int i = 0; i < donHang.ChiTietDonHangs.Count(); i++)
// {
// context.ChiTietDonHangs.Add(donHang.ChiTietDonHangs.ElementAt(i));
// context.SaveChanges();
// }
return(NoContent());
}
public ActionResult Edit([Bind(Include = "MaDonHang,MaNhanVien,MaKhachHang,MaTrangThai,TongTien,ThoiGianTaoDonHang,ThoiGianThanhToan,ThoiGianGiaoHang,GhiChu")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.Entry(donHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKhachHang = new SelectList(db.KhachHangs, "MaKhachHang", "HoTen", donHang.MaKhachHang);
ViewBag.MaNhanVien = new SelectList(db.NhanViens, "MaNhanVien", "HoTen", donHang.MaNhanVien);
ViewBag.MaTrangThai = new SelectList(db.TrangThaiDonHangs, "MaTrangThai", "TenTrangThai", donHang.MaTrangThai);
return(View(donHang));
}
public ActionResult Create([Bind(Include = "MaDH,Email,MaTT,DiaChiNguoiNhan,SDT")] DonHang donHang)
{
if (ModelState.IsValid)
{
donHang.idKH = User.Identity.GetUserId();
db.DonHangs.Add(donHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaTT = new SelectList(db.TrangThaiDonHangs, "MaTT", "TrangThai", donHang.MaTT);
return(View(donHang));
}
public ActionResult Create([Bind(Include = "MaDH,ThanhTien,Ngaylap,Tinhtrang,Nguoitao,MaKH,SDT,DiaChi,PhuongThucThanhToan")] DonHang donHang)
{
if (ModelState.IsValid)
{
db.DonHangs.Add(donHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donHang.MaKH);
ViewBag.PhuongThucThanhToan = new SelectList(db.PhuongThucThanhToans, "id", "PhuongThucThanhToan1", donHang.PhuongThucThanhToan);
return(View(donHang));
}
public ActionResult Xoa(int MaDonHang)
{
//Lấy ra đối tượng sách theo mã
DonHang donhang = db.DonHangs.SingleOrDefault(n => n.MaDonHang == MaDonHang);
if (donhang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(donhang));
}
private void DienThongTinDonHang(DonHang _donhang)
{
tbxTenKhachHang.Text = _donhang.TenKhachHang;
tbxSDT.Text = _donhang.SDT;
tbxDiaChi.Text = _donhang.DiaChi;
tbxKhoiLuong.Text = _donhang.KhoiLuong;
tbxGiaTien.Text = _donhang.GiaTien;
tbxPhiVanChuyen.Text = _donhang.PhiVanChuyen;
tbxTongTien.Text = _donhang.TongTien;
lbDonViVanChuyen.Text = _donhang.DonViVanChuyen;
tbxSoTien.Text = _donhang.SoTien.ToString();
tbxKhoiLuongThucTe.Text = _donhang.CanNangThucTe;
}
protected void Page_Load(object sender, EventArgs e)
{
List<SanPhamGioHang> listSPGH = new List<SanPhamGioHang>();
int a = 100;
List<DonHang> listDH = new List<DonHang>();
DonHang dh = new DonHang();
if (!IsPostBack)
{
ArrayList listDM = new ArrayList();
listDM = DataProvider.LayDanhMuc();
ListView1.DataSource = listDM;
ListView1.DataBind();
if (Session["mand"] != null)
{
if (Request["mahoadon"] != null)
{
int mahoadon = int.Parse(Request["mahoadon"]);
int mand = int.Parse(Session["mand"].ToString());
listSPGH = DataProvider.LayDanhSachChiTietDonHangTheoMaHoaDon(mahoadon);
listSP.DataSource = listSPGH;
listSP.DataBind();
dh = DataProvider.LoadDonHangTheoMaHoaDon(mahoadon);
listDH.Add(dh);
listDonHang.DataSource = listDH;
listDonHang.DataBind();
}
}
else
{
this.Response.Redirect("/");
}
}
//public boolean ShowControl(string msg)
//{
// if (msg == HttpContext.Current.Profile.UserName)
// return true;
// else
// return false;
//}
}
private void LoadData()
{
int id = 0;
if (Common.LoaiNguoiDungID() == 3)
{
id = 0;
}
else if (Common.LoaiNguoiDungID() == 2)
{
id = Common.NguoiDungID();
}
DonHang dh = new DonHang();
DataSet ds = dh.SelectByNguoiDungID(id);
grdDonHang.DataSource = ds.Tables[0];
grdDonHang.DataBind();
}
public static DonHang LoadDonHangTheoMaHoaDon(int mahoadon)
{
DonHang nd = null;
string query = String.Format("SELECT TongTien, TinhTrang FROM DonHang WHERE ID = " + mahoadon + " and Status = 1");
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
nd = new DonHang();
nd.TongTien = reader.GetInt64(0);
nd.TinhTrang = reader.GetString(1);
return nd;
}
}
finally
{
conn.Close();
}
return null;
}
public static Boolean ThemDonHang1(ref DonHang dh)
{
string query = String.Format("INSERT INTO DonHang(MaND, TongTien, NgayLap, LoaiThanhToan) VALUES (" + dh.MaND + ", " + dh.TongTien + ", '" + dh.NgayLap + "', N'" + dh.LoaiThanhToan + "')");
Boolean kq = false;
try
{
conn.Open();
command.CommandText = query;// +" SELECT SCOPE_IDENTITY() AS ID";
if (command.ExecuteNonQuery() > 0)
{
query = "SELECT SCOPE_IDENTITY() AS ID";
command.CommandText = query;
Object idOb = command.ExecuteScalar();
dh.ID = int.Parse(idOb.ToString());
kq = true;
}
}
catch (Exception ex)
{
kq = false;
}
finally
{
conn.Close();
}
return kq;
}
private void ShoppingCartToSend()
{
if (Session["dtShoppingCart"] != null)
{
int intSoLoai = 0;
int intSoSanPham = 0;
int DonHangID = 0;
DonHang dh = new DonHang();
DonHangID = dh.InsertFields(Common.NguoiDungID(), null, null, null, null, null);
DataTable dtShoppingCart = (DataTable) Session["dtShoppingCart"];
dtShoppingCart.DefaultView.Sort = "NguoiDungID";
DataView dv = dtShoppingCart.DefaultView;
HtmlGenericControl div;
HtmlGenericControl divtbl;
HtmlTable tbl;
HtmlTableRow tr;
HtmlTableCell td;
string strNguoiDungID = "";
string strNguoiDungIDNext = "";
int i = 0;
if (dv.Count > 0)
{
btnTinhLai.Enabled = true;
btnXoa.Enabled = true;
do
{
div = new HtmlGenericControl();
strNguoiDungID = dv[i]["NguoiDungID"].ToString();
strNguoiDungIDNext = dv[i]["NguoiDungID"].ToString();
int chid = 0;
string tench = "";
div.InnerHtml = GetThongTinCuaHang(int.Parse(strNguoiDungID), out chid, out tench);
tbl = new HtmlTable();
divtbl = new HtmlGenericControl();
divtbl.Style.Add("align", "right");
setTableAttributes(tbl, false);
int j = 0;
HtmlGenericControl divThanhTien = new HtmlGenericControl();
divThanhTien.ID = strNguoiDungID;
decimal dcmSoTien = 0;
while (strNguoiDungIDNext == strNguoiDungID)
{
DataRowView dr = dv[i];
j++;
tr = new HtmlTableRow();
HtmlGenericControl divTongTien = new HtmlGenericControl();
divTongTien.ID = dr["SanPhamID"].ToString();
divTongTien.InnerText =
string.Format("{0:0,0}", decimal.Parse(dr["TongTien"].ToString())).Replace(",", ".");
AddDonHangToDB(dr, DonHangID, chid, tench);
foreach (DataColumn dc in dtShoppingCart.Columns)
{
if ((dc.ColumnName != "NguoiDungID") && (dc.ColumnName != "Xoa"))
{
td = new HtmlTableCell();
switch (dc.ColumnName)
{
case "SanPhamID":
td.Align = "center";
td.Width = "10%";
td.InnerText = j.ToString();
break;
case "TenSanPham":
td.Width = "25%";
td.InnerText = dr[dc.ColumnName].ToString();
td.Align = "center";
break;
case "GiaSanPham":
td.Width = "15%";
td.InnerText =
string.Format("{0:0,0}", decimal.Parse(dr[dc.ColumnName].ToString())).
Replace(",", ".");
td.Align = "right";
break;
case "SoSanPham":
td.Align = "right";
td.Width = "15%";
td.InnerText = dr[dc.ColumnName].ToString();
//txt.Width = Unit.Pixel(80);
break;
case "Xoa":
break;
case "TongTien":
td.Width = "15%";
//td.InnerText = string.Format("{0:0,0}", dr[dc.ColumnName]).Replace(",", ".");
//td.ID = dr["SanPhamID"].ToString();
td.Controls.Add(divTongTien);
td.Align = "right";
dcmSoTien += decimal.Parse(dr[dc.ColumnName].ToString());
break;
default:
td.Align = "center";
//td.Width = "22%";
td.InnerText = dr[dc.ColumnName].ToString();
break;
}
tr.Cells.Add(td);
}
}
tbl.Rows.Add(tr);
intSoLoai += 1;
intSoSanPham += int.Parse(dr["SoSanPham"].ToString());
//dblSoTien += double.Parse(dr["TongSoTien"].ToString());
//tblShoppingCart.Rows.Insert(1, tr);
if (i < dv.Count - 1)
{
strNguoiDungIDNext = dv[i + 1]["NguoiDungID"].ToString();
strNguoiDungID = dv[i]["NguoiDungID"].ToString();
}
else
{
strNguoiDungIDNext = "no";
}
i++;
}
tr = new HtmlTableRow();
//HtmlTableCell td1 = new HtmlTableCell();
HtmlTableCell td2 = new HtmlTableCell();
td2.Align = "center";
td2.ColSpan = 6;
//td1.InnerHtml = " ";
divThanhTien.InnerText = "Tổng số tiền là: " + string.Format("{0:0,0}", dcmSoTien).Replace(",", ".") +
" VNĐ ";
td2.Controls.Add(divThanhTien);
//td2.Controls.Add(div);
//td2.InnerText = string.Format("{0:0,0}", dcmSoTien).Replace(",", ".");
// td2.ID = strNguoiDungID;
//tr.Cells.Add(td1);
tr.Cells.Add(td2);
tbl.Rows.Add(tr);
divShoppingCart.Controls.Add(div);
divShoppingCart.Controls.Add(divtbl);
divShoppingCart.Controls.Add(tbl);
HtmlGenericControl hr = new HtmlGenericControl();
hr.TagName = "hr";
hr.Attributes.Add("height", "1px");
hr.Attributes.Add("color", "#ff6600");
divShoppingCart.Controls.Add(hr);
} while (i < dv.Count);
}
else
{
divShoppingCart.InnerText = "Không có sản phẩm nào trong giỏ hàng của bạn";
btnTinhLai.Enabled = false;
btnXoa.Enabled = false;
}
//lblSoLoaiSanPham.Text = "Có " + intSoLoai.ToString() + " mặt hàng được chọn";
//lblSoSanPham.Text = intSoSanPham.ToString();
//lblSoTien.Text = string.Format("{0:00.0000}", dblSoTien);
}
}
public int ThemDH(int MaKH, DateTime NgayMua, decimal TongTien, int TinhTrang, string NVDuyet)
{
DonHang dh = new DonHang();
dh.MaKH = MaKH;
dh.NgayMua = (DateTime)NgayMua;
dh.TongTien = (decimal)TongTien;
dh.TinhTrang = TinhTrang;
dh.NVDuyet = NVDuyet;
try
{
using (DBGiayDepEntities db = new DBGiayDepEntities())
{
db.DonHangs.Add(dh);
db.SaveChanges();
return dh.MaDH;
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return 0;
}
}
public static ArrayList LayDonHang()
{
ArrayList list = new ArrayList();
string sql = String.Format("SELECT * FROM DonHang WHERE YEAR(NgayLap) = 2015");
try
{
conn.Open();
command.CommandText = sql;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int madh = reader.GetInt32(1);
int makh = reader.GetInt32(2);
double tongtien = reader.GetDouble(3);
DateTime ngaylap1 = reader.GetDateTime(4);
string ngaylap = (ngaylap1.ToString("yyyy-MM-dd").ToString());
string tinhtrang = reader.GetString(5);
DonHang dh = new DonHang(madh,makh,tongtien,ngaylap,tinhtrang);
list.Add(dh);
}
}
finally
{
conn.Close();
}
return list;
}
public static List<DonHang> LayDanhSachDonHangTheoMaND(int maND)
{
List<DonHang> list = new List<DonHang>();
string query = String.Format("SELECT ID, MaND, TongTien, NgayLap, TinhTrang, LoaiThanhToan FROM DonHang where MaND = " + maND + " ORDER BY NgayLap DESC");
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Int32 id = reader.GetInt32(0);
Int32 mand = reader.GetInt32(1);
Int64 tongtien = reader.GetInt64(2);
DateTime ngaylap1 = reader.GetDateTime(3);
String ngaylap = (ngaylap1.ToString("dd-MM-yyyy").ToString());
String tinhtrang = reader.GetString(4);
String loaithanhtoan = reader.GetString(5);
DonHang sp = new DonHang(id, mand, tongtien, ngaylap, tinhtrang, loaithanhtoan);
list.Add(sp);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return list;
}
