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);
}
}