// GET: Orders
public ActionResult Index([Bind(Include = "MaKhach,TenKhach,Email,DienThoai,DiaChi")] KhachHang khach)
{
bool ex = false;
int sohdb;
if (ModelState.IsValid)
{
KhachHang exist = db.KhachHangs.SingleOrDefault(x => x.DienThoai == khach.DienThoai);
if (exist == null)
{
ex = true;
db.KhachHangs.Add(khach);
db.SaveChanges();
}
List <Cart> listcart = Session["cart"] as List <Cart>;
HoaDonBan donBan = new HoaDonBan()
{
MaKhach = ex == true?khach.MaKhach:exist.MaKhach,
NgayBan = DateTime.Now,
TongTien = listcart.Sum(x => x.SoLuong * x.SanPham.DonGiaBan)
};
db.HoaDonBans.Add(donBan);
db.SaveChanges();
sohdb = donBan.SoHDB;
foreach (var item in listcart)
{
ChiTietHDB chiTiet = new ChiTietHDB();
ChiTietHDB ctexist = db.ChiTietHDBs.FirstOrDefault(x => x.SanPham.TenSP == item.SanPham.TenSP);
if (ctexist != null)
{
HoaDonBan hbexist = db.HoaDonBans.FirstOrDefault(x => x.SoHDB == ctexist.SoHDB && x.MaKhach == donBan.MaKhach);
if (hbexist != null)
{
chiTiet.SoHDB = sohdb;
chiTiet.MaSP = item.SanPham.MaSP;
chiTiet.SoLuong = item.SoLuong;
chiTiet.MaDG = ctexist.MaDG;
}
else
{
chiTiet.SoHDB = sohdb;
chiTiet.MaSP = item.SanPham.MaSP;
chiTiet.SoLuong = item.SoLuong;
}
}
else
{
chiTiet.SoHDB = sohdb;
chiTiet.MaSP = item.SanPham.MaSP;
chiTiet.SoLuong = item.SoLuong;
}
db.ChiTietHDBs.Add(chiTiet);
db.SaveChanges();
}
}
return(RedirectToAction("Shop", "Home"));
}
public ActionResult DeleteConfirmed(int SoHDB, string MaSP)
{
ChiTietHDB chiTietHDB = db.ChiTietHDBs.Find(SoHDB, MaSP);
db.ChiTietHDBs.Remove(chiTietHDB);
db.SaveChanges();
return(RedirectToAction("Details", "HoaDonBans", new { id = chiTietHDB.SoHDB }));
}
// GET: Admin/ChiTietHDBs/Delete/5
public ActionResult Delete(int SoHDB, string MaSP)
{
if (MaSP == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietHDB chiTietHDB = db.ChiTietHDBs.Find(SoHDB, MaSP);
if (chiTietHDB == null)
{
return(HttpNotFound());
}
return(View(chiTietHDB));
}
public ActionResult Create([Bind(Include = "SoHDB,MaSP,GiamGia,SoLuong")] ChiTietHDB chiTietHDB)
{
if (ModelState.IsValid)
{
if (db.ChiTietHDBs.Find(chiTietHDB.SoHDB, chiTietHDB.MaSP) != null)
{
ViewBag.Err = "Sản phẩm đã tồn tại";
}
else
{
db.ChiTietHDBs.Add(chiTietHDB);
db.SaveChanges();
return(RedirectToAction("Details", "HoaDonBans", new { id = chiTietHDB.SoHDB }));
}
}
ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietHDB.MaSP);
return(View(chiTietHDB));
}
public ActionResult UpdateChiTietHD(int productid, int?soluong, int?chitietthu)
{
var session_billid = (DoAn.Common.Session.BillSession)Session[DoAn.Common.Constants.BILL_SESSION];
if (session_billid != null)
{
var billid = session_billid.Id;
var list = new CTHDBanDao().layDSSP(productid, session_billid.Id, chitietthu);
foreach (var item in list)
{
var cart = new ChiTietHDB();
new CTHDBanDao().Update(item.Id, soluong);
}
}
var tongtienhd = db.HoaDonBans.Where(x => x.Id == session_billid.Id).Sum(x => x.TongTien);
var hoadonban = db.HoaDonBans.Find(session_billid.Id);
hoadonban.TongTien = tongtienhd;
db.SaveChanges();
return(RedirectToAction("Index", "HomeNhanVien"));
}
public void Insert_CT(ChiTietHDB cthdb)
{
db.ChiTietHDBs.Add(cthdb);
db.SaveChanges();
}
public ActionResult CreateChiTietHD(string listproduct)
{
var session_billid = (BillSession)Session[DoAn.Common.Constants.BILL_SESSION];
var chitietthu_session = (BillSession)Session[Common.Constants.CTTHU_SESSION];
if (session_billid != null)
{
var chitietthu = chitietthu_session.ChiTietThu + 1;
string[] productsid = listproduct.Split(',');
foreach (var item in productsid)
{
ChiTietHDB cthdb = new ChiTietHDB();
cthdb.MaHDB = session_billid.Id;
cthdb.MaSanPham = int.Parse(item);
var product = new ProductDao().getByid(cthdb.MaSanPham);
cthdb.SoLuong = 1;
cthdb.ThanhTien = product.KhuyenMai * cthdb.SoLuong;
cthdb.ThuocSanPham = int.Parse(productsid[0]);
cthdb.ChiTietThu = chitietthu;
new CTHDBanDao().Insert_CT(cthdb);
}
chitietthu_session.ChiTietThu = chitietthu;
Session.Add(Common.Constants.CTTHU_SESSION, chitietthu_session);
}
else
{
// tạo mã hóa đơn
var session_nhanvien = (NhanVienSession)Session[DoAn.Common.Constants.NHANVIEN_SESSION];
DateTime now = DateTime.Now;
var idbill = session_nhanvien.Id.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString();
var BillSession = new BillSession();
BillSession.Id = idbill;
Session.Add(Common.Constants.BILL_SESSION, BillSession);
BillSession.ChiTietThu = 1;
Session.Add(Common.Constants.CTTHU_SESSION, BillSession);
var hoadonban = new HoaDonBan();
hoadonban.Id = idbill;
hoadonban.MaNhanVien = session_nhanvien.Id;
hoadonban.MaKhach = 4;
hoadonban.TongTien = 0;
hoadonban.NgayBan = now;
hoadonban.DaThanhToan = 1;
hoadonban.Duyet = 1;
var machinhanh = new Models.Dao.Admin.NhanVienDao().getByid(session_nhanvien.Id).MaChiNhanh;
hoadonban.MaChiNhanh = machinhanh;
db.HoaDonBans.Add(hoadonban);
db.SaveChanges();
string[] productsid = listproduct.Split(',');
foreach (var item in productsid)
{
session_billid = (BillSession)Session[DoAn.Common.Constants.BILL_SESSION];
ChiTietHDB cthdb = new ChiTietHDB();
cthdb.MaHDB = session_billid.Id;
cthdb.MaSanPham = int.Parse(item);
var product = new ProductDao().getByid(cthdb.MaSanPham);
var giaban = product.KhuyenMai;
cthdb.SoLuong = 1;
cthdb.ThuocSanPham = int.Parse(productsid[0]);
cthdb.ThanhTien = cthdb.SoLuong * giaban;
cthdb.ChiTietThu = 1;
new CTHDBanDao().Insert_CT(cthdb);
}
}
var tongtienhd = db.HoaDonBans.Where(x => x.Id == session_billid.Id).Sum(x => x.TongTien);
var hoadonban1 = db.HoaDonBans.Find(session_billid.Id);
hoadonban1.TongTien_HoaDon = tongtienhd;
db.SaveChanges();
return(Redirect("/HomeNhanVien/Index"));
}
public ActionResult CreateBill(HoaDonBanModel model)
{
var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION];
if (session != null)
{
new KhachHangDao().Update(session.UserId, model.HoTen, model.DiaChi, model.SDT, model.Email);
// tạo idbill
DateTime now = DateTime.Now;
var idbill = session.UserId.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString();
//insert order
var dao = new CartDao();
var cart = dao.GetProductsByIdUser(session.UserId);
var item = new HoaDonBan();
item.Id = idbill.ToString();
item.MaKhach = session.UserId;
item.MaNhanVien = 1;
item.DaThanhToan = 0;
item.Duyet = 0;
item.TongTien = model.TongTien;
item.NgayBan = now;
var result = new BillDao().Insert(item);
foreach (var item_hdb in cart)
{
//insert orderdetail
var ct_hdb = new ChiTietHDB();
ct_hdb.MaHDB = idbill.ToString();
var product = new ProductDao().viewDetail(item_hdb.MaSanPham);
ct_hdb.MaSanPham = item_hdb.MaSanPham;
ct_hdb.SoLuong = item_hdb.SoLuong;
ct_hdb.GiamGia = 0;
ct_hdb.ThanhTien = product.KhuyenMai * item_hdb.SoLuong;
ct_hdb.ThuocSanPham = item_hdb.ThuocSanPham;
ct_hdb.ChiTietThu = item_hdb.SanPhamThu;
new BillDao().Insert_Bill_Detail(ct_hdb);
//delete cart
dao.Delete(item_hdb.Id);
}
var khachhang = new KhachHangDao().getById(session.UserId);
string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/neworder.html"));
content = content.Replace("{{CustomerName}}", khachhang.HoTen);
content = content.Replace("{{Phone}}", khachhang.SDT);
content = content.Replace("{{Email}}", khachhang.Email);
content = content.Replace("{{Address}}", khachhang.DiaChi);
content = content.Replace("{{Total}}", String.Format("{0:0,0}", model.TongTien));
var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(khachhang.Email, "Đơn hàng mới từ Estore", content);
new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Estore", content);
ViewBag.Success1 = "Bạn vừa đặt hàng thành công, kiếm tra email của bạn";
return(RedirectToAction("Index", "SanPham"));
}
else
{
return(Redirect("/Login/Login"));
}
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <param name="destination">The destination.</param>
/// <returns>ChiTietHDB.</returns>
public static ChiTietHDB ToEntity(this ChiTietHdbModel model, ChiTietHDB destination)
{
return(model.MapTo(destination));
}
/// <summary>
/// To the model.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns>ChiTietHdbModel.</returns>
public static ChiTietHdbModel ToModel(this ChiTietHDB entity)
{
return(entity.MapTo <ChiTietHDB, ChiTietHdbModel>());
}
public void Insert_Bill_Detail(ChiTietHDB cthdb)
{
db.ChiTietHDBs.Add(cthdb);
db.SaveChanges();
}
public void SetUp()
{
this.cthdbObj = new ChiTietHDB("11", "CN0001", 60000, 2);
}
public void Insert(ChiTietHDB entity)
{
repos.Insert(entity);
}
public void Delete(ChiTietHDB entity)
{
repos.Delete(entity);
}
public void Update(ChiTietHDB entity)
{
repos.Update(entity);
}
public ActionResult CreateBill(HoaDonBanModel model)
{
if (ModelState.IsValid)
{
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
if (session != null)
{
new KhachHangDao().Update_KH(session.UserId, model.HoTen, model.SDT, model.Email);
// tạo idbill
DateTime now = DateTime.Now;
var idbill = session.UserId.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString();
//insert order
var dao = new CartDao();
var cart = dao.GetProductsByIdUser(session.UserId);
var item = new HoaDonBan();
item.Id = idbill.ToString();
item.MaKhach = session.UserId;
item.MaNhanVien = 1;
item.DaThanhToan = 0;
item.Duyet = 0;
item.DiaChi = model.DiaChi;
item.TongTien = model.TongTien;
item.PhiShip = model.PhiShip;
item.TongTien_HoaDon = model.TongTien + model.PhiShip;
item.MaChiNhanh = model.MaChiNhanh;
item.NgayBan = now;
var result = new BillDao().Insert(item);
foreach (var item_hdb in cart)
{
//insert orderdetail
var ct_hdb = new ChiTietHDB();
ct_hdb.MaHDB = idbill.ToString();
var product = new ProductDao().viewDetail(item_hdb.MaSanPham);
ct_hdb.MaSanPham = item_hdb.MaSanPham;
ct_hdb.SoLuong = item_hdb.SoLuong;
ct_hdb.GiamGia = 0;
ct_hdb.ThanhTien = product.KhuyenMai * item_hdb.SoLuong;
ct_hdb.ThuocSanPham = item_hdb.ThuocSanPham;
ct_hdb.ChiTietThu = item_hdb.SanPhamThu;
new BillDao().Insert_Bill_Detail(ct_hdb);
//delete cart
dao.Delete(item_hdb.Id);
}
var khachhang = new KhachHangDao().getById(session.UserId);
//string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/neworder.html"));
//content = content.Replace("{{CustomerName}}", khachhang.HoTen);
//content = content.Replace("{{Phone}}", khachhang.SDT);
//content = content.Replace("{{Email}}", khachhang.Email);
//content = content.Replace("{{Address}}", khachhang.DiaChi);
//content = content.Replace("{{Total}}", String.Format("{0:0,0}", model.TongTien));
try
{
//ConfigurationManager.AppSettings["ToEmailAddress"]
//var toEmail = "*****@*****.**";
//new MailHelper().SendMail(khachhang.Email, "Đơn hàng mới từ Estore", content);
//new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Estore", content);
ViewBag.TotalMoney = model.TongTien;
Session[DoAn.Common.Constants.SANPHAMTHU_SESSION] = null;
var viewmodel = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
viewmodel.MaKhach = khachhang.Id;
viewmodel.TongTien = model.TongTien;
viewmodel.DiaChi = khachhang.DiaChi;
viewmodel.HoTen = khachhang.HoTen;
viewmodel.SDT = khachhang.SDT;
viewmodel.Email = khachhang.Email;
viewmodel.PhiShip = model.PhiShip;
ViewBag.Success = "Bạn vừa đặt hàng thành công";
ViewBag.MaHoaDonBan = idbill;
return(View(viewmodel));
}
catch (Exception e)
{
ViewBag.TotalMoney = model.TongTien;
var viewmodel = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
viewmodel.MaKhach = khachhang.Id;
viewmodel.TongTien = model.TongTien;
viewmodel.DiaChi = khachhang.DiaChi;
viewmodel.HoTen = khachhang.HoTen;
viewmodel.SDT = khachhang.SDT;
viewmodel.Email = khachhang.Email;
ViewBag.Error = "Gmail bạn nhập không chính xác, vui lòng kiểm tra lại";
return(View(viewmodel));
}
}
else
{
return(Redirect("/Login/Login"));
}
}
else
{
ViewBag.TotalMoney = model.TongTien;
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
var khachhang = new KhachHangDao().getById(session.UserId);
var modelview = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
modelview.MaKhach = khachhang.Id;
modelview.TongTien = model.TongTien;
modelview.DiaChi = khachhang.DiaChi;
modelview.HoTen = khachhang.HoTen;
modelview.SDT = khachhang.SDT;
modelview.Email = khachhang.Email;
return(View(modelview));
}
}
