public ActionResult account_settings() { if (Session["userLogged"] == null) { return(RedirectToAction("login", "User")); } var user = Session["userLogged"] as TradingVLU.Models.user; using (vlutrading3545Entities db = new vlutrading3545Entities()) { ViewBag.user_question = db.users.Join(db.security_question, usr => user.id_security_question, ques => ques.id, (usr, ques) => new { username = usr.username, question = ques.question, answer = usr.answer_security_question }).ToList(); var user_detail = db.users.FirstOrDefault(usr => user.id == usr.id); ViewBag.user_detail = user_detail; } return(View()); }
public ActionResult login(USERMetadata userLogin) { using (vlutrading3545Entities db = new vlutrading3545Entities()) { if (db.users.Any(x => x.username == userLogin.username)) { var user = db.users.FirstOrDefault(x => x.username == userLogin.username); if (user.password == hashPwd(userLogin.password)) { Session["userLogged"] = user; updateLastLoginTimeAndIp(); ViewBag.SuccessMessage = "Successful Logged"; ViewBag.LoggedStatus = true; } else { ViewBag.DuplicateMessage = "Login failed!"; } } else { ViewBag.DuplicateMessage = "Login failed!"; } } if (Session["userLogged"] != null) { } return(View()); }
public ActionResult detail(int id) { using (vlutrading3545Entities db = new vlutrading3545Entities()) { var item = db.items.FirstOrDefault(x => x.id == id); var imgList = db.item_images.Where(x => x.item_id == id) .Select(x => new { x.filename, imgString = x.base64_string }) .ToList(); ViewBag.DetailItem = item; ViewBag.imgList = imgList; } ViewBag.IdItem = id; return(View()); }
private void updateLastLogoutTimeAndIp() { var user = Session["userLogged"] as TradingVLU.Models.user; if (user != null) { string ip_logout = "default"; if (Request.UserHostAddress != null) { ip_logout = Request.UserHostAddress; } //db.Database.SqlQuery<ObjReturn>("updateLastLoginIpAddress", user_detail.id, ip_login); var sql_sp = @"exec updateLastLogoutIpAddress {0}, {1}"; using (vlutrading3545Entities db = new vlutrading3545Entities()) { db.Database.ExecuteSqlCommand(sql_sp, user.id, ip_logout); } } }
public ActionResult register() { if (Session["userLogged"] != null) { return(RedirectToAction("account_settings", "User")); } using (vlutrading3545Entities db = new vlutrading3545Entities()) { var ques = db.security_question.ToList(); List <SelectListItem> item = new List <SelectListItem>(); foreach (var i in ques) { item.Add(new SelectListItem { Text = i.question, Value = i.id.ToString() }); } ViewBag.question = item; } return(View()); }
public ActionResult index(String name, String description, int quantity, int status, HttpPostedFileBase uploadImages) { using (vlutrading3545Entities db = new vlutrading3545Entities()) { byte[] img = null; string img_as_string = ""; if (uploadImages != null) { img = new byte[uploadImages.ContentLength]; using (BinaryReader read = new BinaryReader(uploadImages.InputStream)) { img = read.ReadBytes(uploadImages.ContentLength); } img_as_string = Convert.ToBase64String(img); } item item = new item { item_name = name, description = description, quantity = quantity, status = status, images = img_as_string, seller_id = 1, create_by = "vinh", create_date = DateTime.Now, update_by = "vinh", update_date = DateTime.Now }; try { db.items.Add(item); db.SaveChanges(); } catch (Exception e) { ViewBag.DuplicateMessage = "Error occurred while create new item. Contact Admin for details"; return(View()); throw; } //if (uploadImages != null) //{ // string[] n = uploadImages.FileName.Split('.'); // string sfile = n[0] + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + n[1]; // string spath = Server.MapPath("~/Content/img/items/"); // string sfullpath = Path.Combine(spath, sfile); // try // { // uploadImages.SaveAs(sfullpath); // db.item_images.Add(new item_images // { // item_id = 1, // filename = sfile, // path = sfullpath, // create_by = "vinh", // create_date = DateTime.Now, // update_by = "vinh", // update_date = DateTime.Now // }); // db.SaveChanges(); // } // catch (Exception ex) // { // } //} } return(View()); }
public ActionResult register(USERMetadata newUser) { using (vlutrading3545Entities db = new vlutrading3545Entities()) { var ques = db.security_question.ToList(); List <SelectListItem> item = new List <SelectListItem>(); foreach (var i in ques) { item.Add(new SelectListItem { Text = i.question, Value = i.id.ToString() }); } ViewBag.question = item; if (ModelState.IsValid) { if (db.users.Any(x => x.email == newUser.email)) { ModelState.AddModelError("Email", "Email already exist"); return(View(newUser)); } else if (db.users.Any(x => x.username == newUser.username)) { ModelState.AddModelError("Username", "Username already exist"); return(View(newUser)); } else { string ip_login = ""; if (Request.UserHostAddress != null) { ip_login = Request.UserHostAddress; } user usr = new user { username = newUser.username, password = hashPwd(newUser.password), email = newUser.email, name = newUser.name, role = 1, id_security_question = newUser.id_security_question, answer_security_question = newUser.answer_security_question, is_active = 1, ip_last_login = ip_login, last_login_date = DateTime.Now, create_by = newUser.username, create_date = DateTime.Now, update_by = newUser.username, update_date = DateTime.Now }; try { db.users.Add(usr); db.SaveChanges(); } catch (Exception e) { ViewBag.DuplicateMessage = "Error occurred while register. Contact Admin for details"; return(View()); throw; } ViewBag.SuccessMessage = "Successful Register"; ModelState.Clear(); return(View()); } } else { return(View()); } } }