public bool Insert(DONDATHANG dh, List <CT_DONDATHANG> ct)
{
return(dao.Insert(dh, ct));
}
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 ActionResult DemoAjax()
{
DONDATHANG ddh = db.DONDATHANGs.First();
return(View());
}
public bool Create(DONDATHANG ddh)
{
return(DataProvider.Instance.ExcuteNonQuery("pInsertDonDatHang @MaKH , @triGia , @ngayGiaoHang , @tennguoinhan , @diaChiNhan , @DienThoaiNhan , @HTThanhtoan , @HTGiaoHang ", new object[] { ddh.MaKH, ddh.Trigia, ddh.Ngaygiaohang, ddh.Tennguoinhan, ddh.Diachinhan, ddh.Dienthoainhan, ddh.HTThanhtoan, ddh.HTGiaohang }) > 0);
}
public ActionResult GioHang(FormCollection frm, DONDATHANG donhang)
{
int x = 0;
string danggiao = "Đang giao";
if (Session["Email"] == null && Session["username"] == null)
{
return(RedirectToAction("LoginSSO", "Account"));
}
else
{
if (Session["username"] != null)
{
x = int.Parse(Session["makh"].ToString());
}
else
{
x = int.Parse(Session["MaKH"].ToString());
}
var user = db.KHACHHANGs.FirstOrDefault(n => n.MaKH == x);
if (user.DiaChiKH == null || user.DienThoaiKH == null)
{
user = db.KHACHHANGs.Find(x);
{
user.DienThoaiKH = frm["dienthoainhanhang"];
user.DiaChiKH = frm["diachinhanhang"];
};
if (Session["username"] != null)
{
db.Entry(user);
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["GioHang"] = null;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
else
{
db.Entry(user);
donhang.MaKH = int.Parse(Session["MaKH"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["GioHang"] = null;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
}
else
{
if (Session["username"] != null)
{
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["Madh"] = donhang.SoDH;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
else
{
donhang.MaKH = int.Parse(Session["MaKH"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["Madh"] = donhang.SoDH;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
}
}
}
public int Insert(DONDATHANG dondathang)
{
db.DONDATHANGs.Add(dondathang);
db.SaveChanges();
return(dondathang.SoDH);
}
public ActionResult ThanhToan()
{
HOCVIEN hocvien = (HOCVIEN)Session[SesHocVien];
List<KHOAHOC> giohang = (List<KHOAHOC>)Session["GioHang"];
DONDATHANG donhang = new DONDATHANG();
if (hocvien == null)
{
return RedirectToAction(actionName: "DangNhap");
}
if(giohang != null)
{
donhang.MaHV = hocvien.MaHV;
donhang.Ngaydat = DateTime.Now;
donhang.Dathanhtoan = false;
foreach(KHOAHOC khoahoc in giohang)
{
donhang.CHITIETDONTHANGs.Add(new CHITIETDONTHANG() {
MaKH = khoahoc.MaKH
});
}
db.DONDATHANGs.InsertOnSubmit(donhang);
db.SubmitChanges();
} else
{
return View();
}
APIContext apiContext = Configuration.GetAPIContext();
try
{
string payerId = Request.Params["PayerID"];
if (string.IsNullOrEmpty(payerId))
{
string baseURI = Request.Url.Scheme + "://" + Request.Url.Authority + "/HocVien/ThanhToan?";
var guid = Convert.ToString((new Random()).Next(100000));
var createdPayment = CreatePayment(apiContext, baseURI + "guid=" + guid);
var links = createdPayment.links.GetEnumerator();
string paypalRedirectUrl = null;
while (links.MoveNext())
{
Links lnk = links.Current;
if (lnk.rel.ToLower().Trim().Equals("approval_url"))
{
paypalRedirectUrl = lnk.href;
}
}
Session.Add(guid, createdPayment.id);
return Redirect(paypalRedirectUrl);
}
else
{
var guid = Request.Params["guid"];
var executedPayment = ExecutePayment(apiContext, payerId, Session[guid] as string);
if (executedPayment.state.ToLower() != "approved")
{
return View("Faile");
}
}
}
catch (Exception ex)
{
Logger.Log("Error " + ex.Message);
return View("Faile");
}
donhang.Dathanhtoan = true;
db.SubmitChanges();
return View("Success");
}
public ActionResult XacNhanDonHang(FormCollection f)
{
if (f["CMND"].Length != 9 && f["CMND"].Length != 12)
{
ViewData["L1"] = "Vui lòng nhập đúng CMND";
return(View());
}
List <GIOHANG> gh = LayGioHang();
DONDATHANG donhang = new DONDATHANG();
donhang.CMND = f["CMND"];
donhang.Ngaydat = DateTime.Now;
donhang.Ngaygiao = DateTime.Parse(f["NgayGiao"]);
donhang.DiaChiLienHe = f["DCGiaoHang"];
donhang.EmailLienHe = f["Email"];
donhang.SDTLienHe = f["SDT"];
donhang.Tinhtranggiaohang = false;
donhang.TongTien = TongTien();
donhang.Dathanhtoan = false;
donhang.TrangThai = true;
db.DONDATHANGs.InsertOnSubmit(donhang);
db.SubmitChanges();
string mathanhtoantructuyen = DateTime.Now.Ticks.ToString();
if (string.Compare(f["rbHinhThucThanhToan"], "Onepay") == 0)
{
string SECURE_SECRET = OnepayCode.SECURE_SECRET;// HAO : CAN THANH MA THAT TRONG APP CODE
//// KHOI TAO LOP THU VIEN VA GAN GIA TRI CAC THAM SO
VPCRequest conn = new VPCRequest(OnepayCode.VPCRequest);
conn.SetSecureSecret(SECURE_SECRET);
//add digital order field
conn.AddDigitalOrderField("Title", "onepay paygate");
conn.AddDigitalOrderField("vpc_Locale", "vn");
conn.AddDigitalOrderField("vpc_Version", "2");
conn.AddDigitalOrderField("vpc_Command", "pay");
conn.AddDigitalOrderField("vpc_Merchant", OnepayCode.Merchant);
conn.AddDigitalOrderField("vpc_AccessCode", OnepayCode.AccessCode);
conn.AddDigitalOrderField("vpc_MerchTxnRef", mathanhtoantructuyen);
conn.AddDigitalOrderField("vpc_OrderInfo", mathanhtoantructuyen);
conn.AddDigitalOrderField("vpc_Amount", (TongTien() * 100).ToString());
conn.AddDigitalOrderField("vpc_Currency", "VND");
conn.AddDigitalOrderField("vpc_ReturnURL", OnepayCode.ReturnURL);
conn.AddDigitalOrderField("vpc_SHIP_Street01", "");
conn.AddDigitalOrderField("vpc_SHIP_Provice", "");
conn.AddDigitalOrderField("vpc_SHIP_City", "");
conn.AddDigitalOrderField("vpc_SHIP_Country", "");
conn.AddDigitalOrderField("vpc_Customer_Phone", "");
conn.AddDigitalOrderField("vpc_Customer_Email", "");
conn.AddDigitalOrderField("vpc_Customer_Id", "");
conn.AddDigitalOrderField("vpc_TicketNo", Request.UserHostAddress);
string ketQua = "";
string url = conn.Create3PartyQueryString();
ketQua = url;
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
DONGHO dh = db.DONGHOs.SingleOrDefault(m => m.MaSP == item.iMaSP);
ctdh.MaDonHang = donhang.MaDonHang;
ctdh.MaSP = item.iMaSP;
ctdh.Soluong = item.iSoLuong;
ctdh.ThanhTien = item.fThanhTien;
ctdh.Dongia = item.fDonGia;
db.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
dh.Soluongton = dh.Soluongton - item.iSoLuong;
UpdateModel(dh);
}
Session["GIOHANG"] = null;
db.SubmitChanges();
ViewBag.Ma = donhang.MaDonHang;
return(Redirect(ketQua));
}
else
{
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
DONGHO dh = db.DONGHOs.SingleOrDefault(m => m.MaSP == item.iMaSP);
ctdh.MaDonHang = donhang.MaDonHang;
ctdh.MaSP = item.iMaSP;
ctdh.Soluong = item.iSoLuong;
ctdh.ThanhTien = item.fThanhTien;
ctdh.Dongia = item.fDonGia;
db.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
dh.Soluongton = dh.Soluongton - item.iSoLuong;
UpdateModel(dh);
}
Session["GIOHANG"] = null;
db.SubmitChanges();
return(View());
}
}
private void groupControl1_CustomButtonClick(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
{
if (Convert.ToInt32(e.Button.Properties.Tag.ToString()) == 1)
{
PHIEUNHAPHANG pn = new PHIEUNHAPHANG();
pn.MAPN = txtmaphieunhap.Text;
pn.MADH = txtmaphieudat.Text;
pn.MANV = _message;
pn.NGAYGIAOHANG = DateTime.Parse(cmbngaylap.Text);
pn.TONGTIEN = decimal.Parse(txtthanhtien.Text);
pn.TINHTRANG = false;
BH.PHIEUNHAPHANGs.InsertOnSubmit(pn);
BH.SubmitChanges();
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
CHITIET_PHIEUNHAP ctpn = new CHITIET_PHIEUNHAP();
SANPHAM sp = new SANPHAM();
DONDATHANG dh = new DONDATHANG();
ctpn.MAPN = txtmaphieunhap.Text;
ctpn.MA_CT_DH = dataGridView1.Rows[j].Cells[5].Value.ToString();
ctpn.SOLUONG = decimal.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
ctpn.DONGIA = decimal.Parse(dataGridView1.Rows[j].Cells[3].Value.ToString());
ctpn.THANHTIEN = decimal.Parse(dataGridView1.Rows[j].Cells[4].Value.ToString());
//cập nhật sản phẩm
int sl = (from slhanghoa in BH.SANPHAMs
where slhanghoa.MASP == dataGridView1.Rows[j].Cells[6].Value.ToString()
select
slhanghoa.SOLUONG).FirstOrDefault();
int soln = int.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
int slcapnhat = sl + soln;
sp = BH.SANPHAMs.Where(s => s.MASP == dataGridView1.Rows[j].Cells[6].Value.ToString()).Single();
sp.SOLUONG = slcapnhat;
//kiểm tra số lượng nhập
// dem dong
int sum;
int count = (from nhaphang in BH.CHITIET_PHIEUNHAPs
where nhaphang.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
nhaphang.SOLUONG
).Count();
if (count == 0)
{
sum = 0;
}
else
{
//tổng số lượng các lần nhập hàng
sum = (int)(from nhaphang in BH.CHITIET_PHIEUNHAPs
where nhaphang.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
nhaphang.SOLUONG
).Sum();
}
// tổng nhập
int tongnhap = sum + int.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
//số lượng chi tiết đơn đặt hàng
var sl1 = (from slhanghoa1 in BH.CT_DONDHs
where slhanghoa1.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
slhanghoa1.SOLUONG).FirstOrDefault();
if (tongnhap > int.Parse(sl1.ToString()))
{
XtraMessageBox.Show("Số lượng nhập quá lớn", "Thông báo");
}
else
{
if (tongnhap == int.Parse(sl1.ToString()))
{
// cap nhat tinh trang
dh = BH.DONDATHANGs.Where(s => s.MADH == txtmaphieudat.Text).Single();
dh.TINHTRANG = true;
}
else
{
dh.TINHTRANG = false;
}
BH.CHITIET_PHIEUNHAPs.InsertOnSubmit(ctpn);
BH.SubmitChanges();
XtraMessageBox.Show("Lưu thành công");
}
}
}
else if (Convert.ToInt32(e.Button.Properties.Tag.ToString()) == 2)
{
dataGridView1.DataSource = null;
// Bind with the new data.
dataGridView1.AutoGenerateColumns = false;
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Mã phiếu nhập";
dataGridView1.Columns[1].Name = "Sản phẩm";
dataGridView1.Columns[2].Name = "Số lượng";
dataGridView1.Columns[3].Name = "Đơn giá";
dataGridView1.Columns[4].Name = "Thành tiền";
dataGridView1.Columns[5].Name = "Mã CT";
dataGridView1.Columns[6].Name = "Mã sản phẩm";
bool kt = true;
var v3Value = cmbsanpham.Properties.GetDataSourceValue("MASP", cmbsanpham.ItemIndex);
string value = (from tennv in BH.CT_DONDHs
join sp in BH.SANPHAMs on tennv.MASP equals sp.MASP
join ddh in BH.DONDATHANGs on tennv.MADH equals ddh.MADH
where tennv.MASP == v3Value.ToString() && tennv.MADH == txtmaphieudat.Text
select
tennv.MA_CT_DH).FirstOrDefault();
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
if (value == dataGridView1.Rows[j].Cells[5].Value.ToString())
{
int slcong = Int32.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
slcong = slcong + int.Parse(txtsoluong.Text);
dataGridView1.Rows[j].Cells[2].Value = slcong;
double thanhtien = 0;
thanhtien = (slcong * double.Parse(dataGridView1.Rows[j].Cells[3].Value.ToString()));
dataGridView1.Rows[j].Cells[4].Value = thanhtien;
kt = false;
break;
}
}
if (kt)
{
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count - 1;
dataGridView1.Rows[row].Cells[0].Value = txtmaphieunhap.Text;
dataGridView1.Rows[row].Cells[1].Value = cmbsanpham.Text;
dataGridView1.Rows[row].Cells[2].Value = txtsoluong.Text;
dataGridView1.Rows[row].Cells[3].Value = txtdongia.Text;
double tt = int.Parse(dataGridView1.Rows[row].Cells[2].Value.ToString()) * double.Parse(dataGridView1.Rows[row].Cells[3].Value.ToString());
dataGridView1.Rows[row].Cells[4].Value = tt.ToString();
dataGridView1.Rows[row].Cells[5].Value = value;
dataGridView1.Rows[row].Cells[6].Value = v3Value;
}
double i = tinhtongtien();
txtthanhtien.Text = string.Format("{0:n0}", Double.Parse(i.ToString()));
}
}
public ActionResult DatHang(FormCollection f)
{
//them don dat hang
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <GioHang> listhang = Laygiohang();
ddh.MAKH = kh.MAKH;
ddh.NGAYDH = DateTime.Now;
var ngaygiao = String.Format("{0:dd/MM/yyyy}", f["ngaygiao"]);
ddh.NGAYGIAO = DateTime.Parse(ngaygiao);
ddh.TINHTRANGGIAO = false;
ddh.DATHANHTOAN = false;
db.DONDATHANGs.InsertOnSubmit(ddh);
db.SubmitChanges();
//them chi tiet don hang
foreach (var item in listhang)
{
CTHOADON ctdh = new CTHOADON();
ctdh.MADDH = ddh.MADDH;
ctdh.MASP = item.iMasp;
ctdh.SOLUONG = item.iSoluong;
ctdh.DONGIA = (decimal)item.dDongia;
ctdh.SIZE = item.iSize;
ctdh.THANHTIEN = (decimal)item.iThanhtien;
db.CTHOADONs.InsertOnSubmit(ctdh);
}
//Mail
StringBuilder Body = new StringBuilder();
Body.Append("<p>Cảm ơn quý khách đã sử dụng sản phẩm của chúng tôi, chúng tôi sẽ liên lạc lại cho quý khách trong thời gian sớm nhất:</p>");
Body.Append("<table>");
Body.Append("<tr><td colspan='2'><h4>Thông tin khách hàng</h4></td></tr>");
Body.Append("<tr><td>Họ và tên:</td><td>" + kh.HOTEN + "/td></tr>");
Body.Append("<tr><td>Số điện thoại:</td><td>" + kh.SDT + "</td></tr>");
Body.Append("<tr><td>Địa chỉ:</td><td>" + kh.DIACHI + "</td></tr>");
Body.Append("<tr><td>Email:</td><td>" + kh.EMAIL + "</td></tr>");
//Body.Append("<tr><td>Nguồn khách:</td><td>Google.com</td></tr>");
Body.Append("</table>");
MailMessage mail = new MailMessage();
mail.To.Add(kh.EMAIL);// cai nay la mail khach hang
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Tiêu đề của mail được gửi";
mail.Body = Body.ToString();// phần thân của mail ở trên
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "khoaleyeuthuytran");// tài khoản Gmail của bạn
smtp.EnableSsl = true;
smtp.Timeout = 30000;
smtp.Send(mail);
//
db.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("Xacnhandonhang", "GioHang"));
}
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());
}
public ActionResult XemThem(DONDATHANG model)
{
cf.ExecuteNonQuery("SELECT *FROM dbo.thongtinDDH(" + model.MaDDH + ")");
return(RedirectToAction("Index"));
}
public int Insert(DONDATHANG ddh)
{
db.DONDATHANGs.Add(ddh);
db.SaveChanges();
return(ddh.sohoadon);
}
public int Insert(DONDATHANG dondathang)
{
cf.DONDATHANG.Add(dondathang);
cf.SaveChanges();
return(dondathang.SoDH);
}
