//For user Verification Code public ActionResult UserVerification(string id) { bool Status = false; using (var db = new OlxDbEntities()) { db.Configuration.ValidateOnSaveEnabled = false; // Ignor to password confirmation var IsVerify = db.Users.Where(u => u.ActivationCode == new Guid(id).ToString()).FirstOrDefault(); if (IsVerify != null) { IsVerify.EmailVerification = true; db.SaveChanges(); ViewBag.Message = "Email Verification completed"; Status = true; } else { ViewBag.Message = "Invalid Request...Email not verify"; ViewBag.Status = false; } return(View()); } }
//For Getting Attribute of a product from table public ActionResult Detail(string Name) { using (var db = new OlxDbEntities()) { var attributes = db.Attributes.Where(x => x.Category == Name).ToList(); return(PartialView(attributes)); } }
public ActionResult SignUp(UserViewModel model) { //if(model.File==null) //{ // ModelState.AddModelError("", "Must upload File"); // return View(); //} User user = new User(); //string path = Path.Combine(Server.MapPath("~/Data/User"), Path.GetFileName(model.File.FileName)); //model.File.SaveAs(path); user.Email = model.Email; user.Password = model.Password; user.Contact = model.Contact; //user.Image = path; user.Info = model.Info; user.ActivationCode = Guid.NewGuid().ToString(); user.EmailVerification = false; UserRole userRole = new UserRole(); userRole.Role = "user"; userRole.UserId = model.Id; using (var context = new OlxDbEntities()) { bool IsTrue = context.Users.Any(x => x.Email == model.Email); if (!IsTrue) { context.Users.Add(user); context.UserRoles.Add(userRole); context.SaveChanges(); SendEmailToUser(user.Email, user.ActivationCode); var message = "Registration Completed. Please check you Email...." + user.Email; ViewBag.Message = message; return(View("Registration")); } else { ModelState.AddModelError("", "Email Already Exist"); return(View()); } } }
public ActionResult Login(Models.Membership model) { using (var db = new OlxDbEntities()) { bool IsTrue = db.Users.Any(x => x.Email == model.Email); if (IsTrue) { bool IsValid = db.Users.Any(x => x.Email == model.Email && x.Password == model.Password && x.EmailVerification == true); if (IsValid) { var result = (from user in db.Users join role in db.UserRoles on user.Id equals role.UserId where user.Email == model.Email select role.Role).ToArray(); if (result.Contains("admin")) { FormsAuthentication.SetAuthCookie(model.Email, false); return(RedirectToAction("Index", "admin")); } else { FormsAuthentication.SetAuthCookie(model.Email, false); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Invalid information plz Try again"); return(View()); } } else { ModelState.AddModelError("", "Account Does not exist"); return(View()); } } }
//Filtering Posts public ActionResult Filter(string Province, string City1, string search, string condition, int?min, int?max) { using (var db = new OlxDbEntities()) { var posts = db.Ads.Where(x => x.State == Province && x.City == City1 && x.Category.Contains(search) || (x.Condition == condition)).ToList(); if (min != null || max != null) { posts = posts.Where(x => x.Price >= min && x.Price <= max).ToList(); } ViewBag.Province = Province; ViewBag.City = City1; ViewBag.Search = search; ViewBag.min = min; ViewBag.max = max; return(View(posts)); } }