public ActionResult result(Account acc, string ghichu, string group2) { int MaKH = int.Parse(Session["idaccount"].ToString()); /*cập nhật lại thông tin khách hàng*/ Account account = db.Accounts.Where(s => s.IDAccount == MaKH).FirstOrDefault(); account.Hoten = acc.Hoten; account.Email = acc.Email; account.Phonenumber = acc.Phonenumber; account.Address = acc.Address; db.SaveChanges(); /*===================================*/ /*cập nhật lại thông tin đơn hàng*/ if (group2 == null) { TempData["alertcheckout"] = "Bạn chưa chọn phương thức thanh toán"; TempData["AlertType"] = "alert-warning"; return(RedirectToAction("index", "Checkout")); } else { DonhangKH donhangKH = db.DonhangKHs.Where(s => s.MaKH == MaKH && s.Tinhtrangdonhang == 0).FirstOrDefault(); donhangKH.Tinhtrangdonhang = 1; donhangKH.Phivanchuyen = 0; donhangKH.Ngaydatmua = DateTime.Now; donhangKH.TongTien = new Cart().TotalCart(MaKH); donhangKH.ghichu = ghichu; donhangKH.PhuongthucTT = group2; db.SaveChanges(); TempData["checkout"] = "Thanh toán thành công !!"; return(RedirectToAction("index", "checkout")); } }
// GET: home public ActionResult Index() { DateTime expired = DateTime.Now; List <Khuyenmai> listdatetime = db.Khuyenmais.Where(s => s.Ngayketthuc <= expired).ToList(); foreach (var item in listdatetime) { db.delete_expired(item.MaKM); db.Khuyenmais.Remove(item); db.SaveChanges(); } return(View()); }
public void Creat(int _idKH) { DonhangKH donhang = new DonhangKH(); donhang.MaDH = db.DonhangKHs.OrderByDescending(s => s.MaDH).Select(s => s.MaDH).FirstOrDefault() + 1; donhang.MaKH = _idKH; donhang.Phivanchuyen = 0; donhang.TongTien = 0; donhang.Ngaydatmua = DateTime.Now; donhang.PhuongthucTT = "null"; donhang.Tinhtrangdonhang = 0; donhang.ghichu = "null"; db.DonhangKHs.Add(donhang); db.SaveChanges(); }
public ActionResult Index(AccLogin Input, Account ACC) { var CheckMail = db.Accounts.Where(p => p.Email == Input.EmailLogin).FirstOrDefault(); if (CheckMail == null) { ACC.Email = Input.EmailLogin; ACC.Hoten = Input.name; if (Input.Password != Input.RePassword) { setAlert1("Xac nhan mat khau sai !", "warning"); return(View("Index")); } else { try { var IDMax = db.Accounts.OrderByDescending(s => s.IDAccount).Take(1).FirstOrDefault(); ACC.IDAccount = IDMax.IDAccount + 1; ACC.Password = Input.Password; ACC.Phonenumber = Input.phone; ACC.Ngaysinh = Input.DateOfBirth; ACC.Username = Input.username; ACC.Address = Input.address; db.Accounts.Add(ACC); db.SaveChanges(); return(RedirectToAction("Index", "home")); } catch (DbEntityValidationException e) { throw; } } } else { setAlert1("Email da ton tai", "error"); return(View("Index")); } }
public ActionResult ImageUser(HttpPostedFileBase file) { Account login = (Account)Session["user"]; if (file != null) { //save image in folder string physicaPath = Server.MapPath("/template/assets/images/" + file.FileName); file.SaveAs(physicaPath); //update in DataBase using (SellphonesEntities db = new SellphonesEntities()) { var x = db.Accounts.Where(s => s.IDAccount == login.IDAccount).FirstOrDefault(); x.Avatar = file.FileName; db.SaveChanges(); return(RedirectToAction("EditInfo", "Account")); } } else { return(RedirectToAction("EditInfo", "Account")); } }
public static int LoginGoogle(AccGoogle accGoogle, SellphonesEntities db) { var acc = db.Accounts.Where(s => s.Email == accGoogle.Email).FirstOrDefault(); if (acc == null) { var IDMax = db.Accounts.OrderByDescending(s => s.IDAccount).Take(1).FirstOrDefault(); Account account = new Account(); account.IDAccount = IDMax.IDAccount + 1; account.Password = "******"; account.Phonenumber = ""; account.Type = "customer"; account.Ngaysinh = DateTime.MinValue; account.Username = accGoogle.Name; account.Address = ""; account.Avatar = accGoogle.Image; account.Email = accGoogle.Email; account.Hoten = accGoogle.Name; try { db.Accounts.Add(account); db.SaveChanges(); } catch (Exception ee) { } return(account.IDAccount); } else { return(acc.IDAccount); } }