public ActionResult DatHang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <Giohang> gh = Laygiohang();
ddh.MaKH = kh.MaKH;
ddh.NgayDH = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
ddh.Ngaygiaohang = DateTime.Parse(ngaygiao);
ddh.HTGiaohang = false;
ddh.HTThanhtoan = false;
cc2.Create(ddh);
foreach (var item in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.Masach = item.Masach;
ctdh.Soluong = item.Soluong;
ctdh.Dongia = (Decimal)item.Dongia;
cc2.ChiTietDatHang(ctdh);
}
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "GioHang"));
}
public ActionResult DatHang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <Giohang> gh = Laygiohang();
ddh.MaKH = kh.MaKH;
ddh.NgayDH = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
ddh.HTGiaohang = false;
ddh.HTThanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.Masach = item.iMasach;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dDongia;
data.CTDATHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult DatHang(FormCollection f)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <Giohang> gh = layGioHang();
ddh.MaKH = kh.MaKH;
ddh.NgayDH = DateTime.Now;
ddh.Trigia = (int)TongTien();
var ngaygiao = String.Format("{0:MM/dd/yyyy}", f["Ngaygiao"]);
ddh.Ngaygiaohang = DateTime.Parse(ngaygiao);
ddh.HTGiaohang = false;
ddh.Dagiao = false;
ddh.Tennguoinhan = kh.HoTenKH;
ddh.Diachinhan = kh.DiachiKH;
ddh.Dienthoainhan = kh.DienthoaiKH;
db.DONDATHANGs.InsertOnSubmit(ddh);
db.SubmitChanges();
foreach (var item in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.Masach = item.iMaSach;
ctdh.Soluong = item.iSoLuong;
ctdh.Dongia = (decimal)item.dDongia;
db.CTDATHANGs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "GioHang"));
}
public ActionResult DatHang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["User"];
List <GioHang> gh = Laygiohang();
ddh.STT = kh.STT;
ddh.NGAYDAT = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["NGAYGIAO"]);
ddh.NGAYGIAO = DateTime.Parse(ngaygiao);
ddh.TINHTRANGGIAOHANG = false;
ddh.DATHANHTOAN = false;
db.DONDATHANGs.InsertOnSubmit(ddh);
db.SubmitChanges();
foreach (var item in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.MADH = ddh.MADH;
ctdh.MASP = item.iMASP;
ctdh.SOLUONG = item.iSOLUONG;
ctdh.DONGIA = (decimal)item.iGIA;
db.CTDATHANGs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult Dathang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <Giohang> gh = Laygiohang();
ddh.MaKH = kh.MaKH;
ddh.NgayDH = DateTime.Now;
var ngaygiao = String.Format("{0:dd/MM/yyyy}", collection["Ngaygiaohang"]);
ddh.Ngaygiaohang = DateTime.Parse(ngaygiao);
ddh.HTThanhtoan = false;
ddh.HTThanhtoan = false;
data.DONDATHANGs.Add(ddh);
data.SaveChanges();
foreach (var item in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.MaDC = item.mMadochoi;
ctdh.Soluong = item.mSoluong;
ctdh.Dongia = (decimal)item.mDongia;
data.CTDATHANGs.Add(ctdh);
}
data.SaveChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult DatHang(FormCollection col)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["TAIKHOAN"];
List <item> gh = laygiohang();
ddh.MAKH = kh.MAKH;
ddh.NGAYDAT = DateTime.Now;
var ngayGiao = String.Format("{0:MM/dd/yyyy}", col["NGAYGIAO"]);
ddh.NGAYGIAO = DateTime.Parse(ngayGiao);
ddh.TINHTRANGGIAOHANG = false;
ddh.DATHANHTOAN = false;
foreach (var it in gh)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.MADH = ddh.MADH;
ctdh.MASANPHAM = it.masp;
ctdh.SOLUONG = it.soluong;
ctdh.DONGIA = it.gia;
db.CTDATHANGs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("xanhandonhang", "GioHang"));
}
public ActionResult Order(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"];
List <Cart> listCart = GetCart();
ddh.MaKH = kh.MaKH;
ddh.NgayDH = DateTime.Now;
var ngaygiao = String.Format("{0:MM/DD/YYYY}", collection["NgayGiao"]);
ddh.Ngaygiaohang = DateTime.Parse(ngaygiao);
ddh.HTGiaohang = false;
ddh.HTThanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in listCart)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.Masach = item.MaSach;
ctdh.Soluong = item.SoLuong;
ctdh.Dongia = (decimal)item.DonGia;
data.CTDATHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("ConfirmOrder", "Cart"));
}
public ActionResult Xacnhandathang(FormCollection frc)
{
List <GioHang> lstGHang = (List <GioHang>)Session[strCart];
DONDATHANG donDatHang = new DONDATHANG()
{
TenKH = frc["hoTen"],
SoDienthoaiKH = frc["soDienThoai"],
DiachiKH = frc["diaChi"],
Ngaydat = DateTime.Now,
Ngaygiao = DateTime.Now,
Dathanhtoan = false,
Tinhtranggiohang = false,
MaKH = int.Parse(Session["MaKH"].ToString())
};
db.DONDATHANGs.Add(donDatHang);
db.SaveChanges();
foreach (GioHang giohang in lstGHang)
{
CTDATHANG cTDATHANG = new CTDATHANG()
{
MaDonHang = donDatHang.MaDonHang,
MaSach = giohang.SACH.Masach,
Soluong = giohang.Soluong,
Dongia = giohang.SACH.Giaban * giohang.Soluong
};
db.CTDATHANGs.Add(cTDATHANG);
db.SaveChanges();
}
Session.Remove(strCart);
return(View("Dathangthanhcong"));
}
public ActionResult Order()
{
if (Session["MaKhachHang"] == null || Session["TenDangNhap"] == null)
{
return(RedirectToAction("Signin", "User"));
}
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
Chitetdathang p = new Chitetdathang();
DATHANG DH = new DATHANG();
Khach_Hang KH = (Khach_Hang)Session["TaiKhoan"];
List <Cart> GH = getCart();
DH.Ma_KhachHang = KH.Ma_Khach_Hang;
DH.NgayDatHang = DateTime.Now;
DH.TenNguoiNhan = KH.HoKH + " " + KH.TenKH;
if (DH.TenNguoiNhan == null)
{
DH.TenNguoiNhan = KH.TenDangNhap;
}
DH.SoDienThoai = Request["Sodienthoai"];
DH.DiaChiNhan = Request["DiachiNhan"];
DH.HinhThucThanhToan = Request["Hinhthucthanhtoan"];
DH.TriGia = TongTien();
dbo.DATHANGs.Add(DH);
dbo.SaveChanges();
foreach (var item in GH)
{
CTDATHANG CTDH = new CTDATHANG();
CTDH.SoHD = item.SoHD;
CTDH.SoHD = DH.SoHD;
CTDH.MaHangHoa = item.Ma_Sach;
CTDH.SoLuong = item.SoLuong;
CTDH.DonGia = (decimal)item.DonGia;
CTDH.ThanhTien = (decimal)item.ThanhTien;
Sach sl = dbo.Saches.Find(item.Ma_Sach);
sl.SoLuongTon = sl.SoLuongTon - item.SoLuong;
sl.SoLuongBan = 0;
sl.SoLuongBan = sl.SoLuongBan + item.SoLuong;
if (sl.SoLuongTon >= 0)
{
dbo.Entry(sl).State = EntityState.Modified;
}
else
{
sl.SoLuongTon = 0;
ViewBag.sltErr = sl.SoLuongTon;
dbo.Entry(sl).State = EntityState.Modified;
}
dbo.CTDATHANGs.Add(CTDH);
}
dbo.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("Index", "Home"));
}
public List <CTDATHANG> LoadCTDatHang()
{
List <CTDATHANG> result = new List <CTDATHANG>();
DataTable data = DataProvider.Instance.ExcuteQuery("Select * from dbo.CTDATHANG");
foreach (DataRow row in data.Rows)
{
CTDATHANG temp = new CTDATHANG(row);
result.Add(temp);
}
return(result);
}
public bool Insert(CTDATHANG chitiet)
{
try
{
db.CTDATHANGs.Add(chitiet);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public ActionResult ThanhToan(string shipName, string address, string mobile, string httt, string htgh)
{
var od = new OrderDao();
var session = (AccLogin)Session[CommonConstants.Account_Session];
var dondathang = new DONDATHANG();
dondathang.ID = new AccountDao().GetCus(session.UserName).ID;
dondathang.NgayGiaoHang = DateTime.Now;
dondathang.TenNguoiNhan = shipName;
dondathang.DiaChiNhan = address;
dondathang.DienThoaiNhan = mobile;
dondathang.HTGiaoHang = htgh;
dondathang.HTThanhToan = httt;
try
{
var soDH = od.Insert(dondathang);
var cart = (List <CartItem>)Session[CartSession];
var chitietDao = new OrderDetailDao();
decimal total = 0;
string tenmonan = null, gia = null;
foreach (var item in cart)
{
decimal thanhtien = 0;
var chitiet = new CTDATHANG();
chitiet.SoDH = soDH;
chitiet.MaTS = item.Monan.MaTS;
chitiet.DonGia = item.Monan.DonGia;
chitiet.SoLuong = item.SoLuong;
thanhtien += item.Monan.DonGia.Value * item.SoLuong;
od.InsertSLBan(item.Monan.MaTS, item.SoLuong);
chitietDao.Insert(chitiet);
total += (item.Monan.DonGia.GetValueOrDefault(0) * item.SoLuong);
tenmonan += item.Monan.TenTS + "<br />";
gia += item.Monan.DonGia.GetValueOrDefault(0).ToString("N0") + "<br />";
}
Session[CartSession] = null;
}
catch (Exception)
{
return(Redirect("/loi-thanh-toan"));
}
return(RedirectToAction("DatHangThanhCong", "GioHang"));
}
public ActionResult ThanhToan(string shipName, string address, string mobile, string httt, string htgh)
{
var od = new OrderDao();
var session = (UserLogin)Session[CommonConstants.SESSION];
var dondathang = new DONDATHANG();
dondathang.MaKH = new UserDao().GetByName(session.TenDN).MaKH;
dondathang.NgayDH = DateTime.Now;
dondathang.TenNguoiNhan = shipName;
dondathang.DiaChiNhan = address;
dondathang.DienThoaiNhan = mobile;
dondathang.HTThanhToan = httt;
dondathang.HTGiaoHang = htgh;
var soDH = od.Insert(dondathang);
var cart = (List <CartItem>)Session[CartSession];
var chitietDao = new OrderDetailDao();
decimal total = 0;
//string tenmonan = null, gia = null;
foreach (var item in cart)
{
var chitiet = new CTDATHANG();
chitiet.SoDH = soDH;
chitiet.MaMonAn = item.MonAn.MaMonAn;
chitiet.DonGia = item.MonAn.DonGia;
chitiet.SoLuong = item.SoLuong;
chitiet.ThanhTien = item.MonAn.DonGia * item.SoLuong;
od.InsertSLBan(item.MonAn.MaMonAn, item.SoLuong);
chitietDao.Insert(chitiet);
total += (item.MonAn.DonGia.GetValueOrDefault(0) * item.SoLuong);
//tenmonan += item.MonAn.TenMonAn + "<br />";
//gia += item.MonAn.DonGia.GetValueOrDefault(0).ToString("N0") + "<br />";
}
od.InsertTotal(soDH, total);
//try
//{
// var content = System.IO.File.ReadAllText(Server.MapPath("/Template/MailOrder.html"));
// var toEmail_User = new UserDao().GetByName(session.TenDN).Email;
// string time = DateTime.Now.ToString("dd MMMM yyyy hh:mm:ss tt");
// content = content.Replace("{{SoDH}}", soDH.ToString());
// content = content.Replace("{{Time}}", time);
// content = content.Replace("{{CustomerName}}", shipName);
// content = content.Replace("{{Phone}}", mobile);
// content = content.Replace("{{Address}}", address);
// content = content.Replace("{{Email}}", toEmail_User);
// content = content.Replace("{{Item}}", tenmonan);
// content = content.Replace("{{Price}}", gia);
// content = content.Replace("{{Total}}", total.ToString("N0"));
// var mailHelper = new MailHelper();
// mailHelper.SendMail(toEmail_User, "Đơn hàng mới từ CD Food", content);
// Session[CartSession] = null;
//}
//catch (Exception ex)
//{
// ViewBag.LoiThanhToan = ex;
// return View(cart);
//}
Session[CartSession] = null;
return(Redirect("/hoan-thanh"));
}
public bool ChiTietDatHang(CTDATHANG ctdh)
{
return(DataProvider.Instance.ExcuteNonQuery("pInsertChiTietDonHang @SoDH , @MaSach , @SoLuong , @donGia ", new object[] { ctdh.SoDH, ctdh.Masach, ctdh.Soluong, ctdh.Dongia }) > 0);
}
public ActionResult ThongTinDonHang(DONDATHANG ddh)
{
if (Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "")
{
return(RedirectToAction("DangNhap", "NguoiDung"));
}
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"];
//ViewBag.HoTen = kh.HotenKH;
//ViewBag.DiaChi = kh.DiachiKH;
//ViewBag.DienThoai = kh.DienthoaiKH;
//ViewBag.Email = kh.Email;
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.TongTien = TongTien();
List <GioHang> lstGioHang = LayGioHang();
ViewBag.lstGioHang = lstGioHang;
if (ModelState.IsValid)
{
DONDATHANG donhang = new DONDATHANG();
donhang.MaKH = kh.MaKH;
donhang.Ngaydathang = DateTime.Now;
donhang.Ngaygiaohang = ddh.Ngaygiaohang;
donhang.Tennguoinhan = ddh.Tennguoinhan;
donhang.Diachinhan = ddh.Diachinhan;
donhang.Dienthoainhan = ddh.Dienthoainhan;
donhang.HTThanhtoan = ddh.HTThanhtoan;
donhang.HTGiaohang = ddh.HTGiaohang;
donhang.Trigia = (decimal)ViewBag.TongTien;
db.DONDATHANGs.Add(donhang);
foreach (var item in lstGioHang)
{
CTDATHANG ctdh = new CTDATHANG();
ctdh.SoDH = ddh.SoDH;
ctdh.Masach = item.iMaSP;
ctdh.Soluong = item.iSoLuong;
ctdh.Dongia = item.dDonGia;
ctdh.Thanhtien = item.dThanhTien;
db.CTDATHANGs.Add(ctdh);
}
db.SaveChanges();
////gửi mail
string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/Email.html"));
content = content.Replace("{{HoTen}}", kh.HotenKH);
content = content.Replace("{{DienThoai}}", kh.DienthoaiKH);
content = content.Replace("{{Email}}", kh.Email);
content = content.Replace("{{DiaChi}}", kh.DiachiKH);
content = content.Replace("{{SoLuong}}", "" + TongSoLuong());
content = content.Replace("{{TriGia}}", TongTien().ToString());
SendMail("Đơn hàng mới từ ShopABC", content);
//MailMessage mm = new MailMessage("*****@*****.**",kh.Email);
//mm.Subject ="Đơn đặt hàng";
//mm.Body ="Họ và tên khách hàng:" + kh.HotenKH + "\nEmail:"+kh.Email+"\nĐịa chỉ:"+kh.DiachiKH+"Số điện thoại:"+kh.DienthoaiKH;
//mm.IsBodyHtml = true;
//SmtpClient sc = new SmtpClient();
//sc.Host = "smtp.gmail.com";
//sc.Port = 587;
//sc.EnableSsl = true;
//NetworkCredential nc = new NetworkCredential("*****@*****.**", "asdasd0003");
//sc.UseDefaultCredentials = true;
//sc.Credentials = nc;
//sc.Send(mm);
return(RedirectToAction("XacNhanDonHang"));
}
return(View());
}
