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