public ActionResult Index(Table u) { // this action is for handle post (login) if (ModelState.IsValid) // this is check validity { using (Database1Entities5 dc = new Database1Entities5()) { var v = dc.Tables.Where(a => a.Username.Equals(u.Username) && a.Password.Equals(u.Password)).FirstOrDefault(); if (v != null) { Session["Username"] = v.Username.ToString(); Session["Password"] = v.Password.ToString(); return(RedirectToAction("About")); } } } ViewBag.Message = "Your Username or Password could not be found"; return(View(u)); }//Login end method--------------------------------------------------------------Done display Fxn------------------------------------------------------------------
public void LogForgotPassword(string Email) { Database1Entities5 db2 = new Database1Entities5(); List <CreateUser> user; using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString())) { user = db.Query <CreateUser>("Select * from dbo.UserTable where Email = @Email;", new { Email }).ToList(); } string ip = HttpContext.Current.Request.UserHostAddress; EventLog model = new EventLog(); model.Date = DateTime.Now; model.UserID = Convert.ToInt32(user[0].ID); model.From = ""; model.To = "Requested Password Reset Link to: " + Email; model.IPAddress = ip; model.Screen = "ForgotPassword"; model.Access_Level = "Admin"; using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString())) { string sql = $"Insert into dbo.EventLogTable (Date, UserID, " + "[From], [To], IPAddress, Screen, AccessLevel) values" + "(@Date, @UserID, @From, @To, @IPAddress, @Screen,@AccessLevel)"; db.Execute(sql, new { Date = model.Date, UserID = model.UserID, From = model.From, To = model.To, IPAddress = model.IPAddress, Screen = model.Screen, AccessLevel = model.Access_Level }); } }
//Filter Opportunities-------------------------------------------DOne-------------------------------------------------------------------------------------------------- public ActionResult MethodFilter(string Volunteerstatus) { if (Session["Username"] != null) { using (Database1Entities5 dc = new Database1Entities5()) { if (Volunteerstatus == "Approved") { var volunteers = from r in db.Volunteers orderby r.VFname where r.Status == Volunteerstatus || Volunteerstatus == null || Volunteerstatus == "" select r; return(View(volunteers)); } if (Volunteerstatus == "Pending Approval") { var volunteers = from r in db.Volunteers orderby r.VFname where r.Status == Volunteerstatus || Volunteerstatus == null || Volunteerstatus == "" select r; return(View(volunteers)); } if (Volunteerstatus == "Disapproved") { var volunteers = from r in db.Volunteers orderby r.VFname where r.Status == Volunteerstatus || Volunteerstatus == null || Volunteerstatus == "" select r; return(View(volunteers)); } if (Volunteerstatus == "All") { return(View(dc.Volunteers.Include(v => v.VImage).Include(v => v.Avaliability).ToList())); } if (Volunteerstatus == "Inactive") { var volunteers = from r in db.Volunteers orderby r.VFname where r.Status == Volunteerstatus || Volunteerstatus == null || Volunteerstatus == "" select r; return(View(volunteers)); } if (Volunteerstatus == "both") { var t = "Approved"; var p = "Pending Approval"; var volunteers = from r in db.Volunteers orderby r.VFname where r.Status == t || Volunteerstatus == null || Volunteerstatus == "" || r.Status == p || Volunteerstatus == null || Volunteerstatus == "" select r; return(View(volunteers)); } else { return(View(db.Volunteers.Include(v => v.VImage).Include(v => v.Avaliability).ToList())); } } } else { return(RedirectToAction("Index", "Home")); } }