public ActionResult Index(
[Bind(Include =
"UserName, Password, PersonKey")
] Login lg)
{
lg.PersonKey = 0;
int result = db.usp_Login(lg.UserName, lg.Password);
Message m = new Message();
if (result == -1)
{
m.MessageText = "Validation failed, please try again or register.";
}
else
{
Session["ukey"] = (from p in db.People
where p.PersonEmail.Equals(lg.UserName)
select p.PersonKey).FirstOrDefault();
lg.PersonKey = (int)Session["ukey"];
m.MessageText = "Thank you for logging in. You are now free to donate or apply for assistance";
}
return(View("LoginResult", m));
}
public ActionResult Index([Bind(Include =
"UserName, " +
"Password, " +
"PersonKey"
)] Login li)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
li.PersonKey = 0;
int result = db.usp_Login(li.UserName, li.Password);
Message msg = new Message();
msg.Succeeded = result != -1;
if (msg.Succeeded)
{
Session["PersonKey"] = (int)(from p in db.People
where p.PersonEmail.Equals(li.UserName)
select p.PersonKey).FirstOrDefault();
msg.UserName = (string)(from p in db.People
where p.PersonEmail.Equals(li.UserName)
select p.PersonFirstName).FirstOrDefault();
return(RedirectToAction("Result", msg));
}
else
{
return(View("Result", msg));
}
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginResult = db.usp_Login(lc.UserName, lc.Password);
if (loginResult != -1)
{
var uid = (from r in db.People
where r.PersonEmail.Equals(lc.UserName)
select r.PersonKey).FirstOrDefault();
int rKey = (int)uid;
Session["reviewKey"] = rKey;
Message msg = new Message();
msg.MessageText = "Thank you, " + lc.UserName + " for logging in. You can now donate or apply for assistance.";
return(RedirectToAction("Result", msg));
}
Message message = new Message();
message.MessageText = "Invalid Login";
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "Username, Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginresult = db.usp_Login(lc.Username, lc.Password);
if (loginresult != -1)
{
var uid = (from p in db.People
where p.PersonEmail.Equals(lc.Username)
select p.PersonKey).FirstOrDefault();
int pKey = (int)uid;
Session["personKey"] = pKey;
//create message
Message m = new Message();
m.MessageTitle = "Login Results";
m.MessageText = "Thank You, " + lc.Username + " for logging in. You can now donate or apply for grants";
return(RedirectToAction("Result", m));
}
Message bad = new Message();
bad.MessageTitle = "Login Results";
bad.MessageText = "Invalid Login";
return(View("Result", bad));
}
public ActionResult Index([Bind(Include = "UserName, Password, PersonKey")] LoginClass loginClass)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
loginClass.PersonKey = 0;
int result = db.usp_Login(loginClass.UserName, loginClass.Password);
Message msg = new Message();
if (result != -1)
{
var ukey = (from r in db.People
where r.PersonEmail.Equals(loginClass.UserName)
select r.PersonKey).FirstOrDefault();
loginClass.PersonKey = (int)ukey;
Session["NewPersonKey"] = loginClass.PersonKey;
msg.MessageText = "Welcome " + loginClass.UserName;
}
else
{
msg.MessageText = "Invalid Login";
}
//return the class to the Result view
return(View("Result", loginClass));
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginResult = db.usp_Login(lc.UserName, lc.Password);
if (loginResult != -1)
{
var uid = (from np in db.People
where np.PersonEmail.Equals(lc.UserName)
select np.PersonKey).FirstOrDefault();
int npKey = (int)uid;
Session["personkey"] = npKey;
Message msg = new Message();
msg.MessageText = "Thank you," + lc.UserName
+ "for logging in. You can now"
+ "donate or apply for assistance";
return(RedirectToAction("Result", msg));
}
Message message = new Message();
message.MessageText = "Validation failed, please try again or register if you have not done so yet";
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "Email, PlainPassword")] LoginClass lc)
{
int results = db.usp_Login(lc.Email, lc.PlainPassword);
int revKey = 0;
Message msg = new Message();
if (results != -1)
{
var pkey = (from r in db.People
where r.PersonEmail.Equals(lc.Email)
select r.PersonKey).FirstOrDefault();
revKey = (int)pkey;
Session["PersonKey"] = revKey;
msg.MessageText = "Welcome, " + lc.Email;
}
else
{
msg.MessageText = "Invalid Login. Please try again or register first.";
}
return(View("Result", msg));
}
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lgc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
lgc.PersonKey = 0;
int result = db.usp_Login(lgc.Email, lgc.Password);
if (result != -1)
{
var ukey = (from p in db.People
where p.PersonEmail.Equals(lgc.Email)
select p.PersonKey).FirstOrDefault();
lgc.PersonKey = ukey;
System.Web.HttpContext.Current.Session["ukey"] = ukey;
}
var resultMessage = new Message();
if (result != -1)
{
resultMessage.MessageText = "Thank you for loggin in. You may now Donate or apply for assistance.";
}
else
{
resultMessage.MessageText = "Login failed. Please check your credentials, or Register if you have not yet done so.";
}
return(View("Result", resultMessage));
}
public ActionResult Index([Bind(Include = "UserName, Password")] LogInClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginResult = db.usp_Login(lc.UserName, lc.Password);
if (loginResult != -1)
{
var uid = (from r in db.People
where r.PersonFirstName.Equals(lc.UserName)
select r.PersonKey).FirstOrDefault();
int rKey = (int)uid;
Session ["ReviewerKey"] = rKey;
Class1Messages msg = new Class1Messages();
msg.MessageText = "Thank You, "
+ lc.UserName
+ " for login you can donate";
return(RedirectToAction("Result", msg));
}
Class1Messages message = new Class1Messages();
message.MessageText = "invalid Login";
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "Email, Password")] Login lc)
{ //make connection with database
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
//use stored procedure in database
int result = db.usp_Login(lc.Email, lc.Password);
if (result != -1)
{
var uID = (from p in db.People
where p.PersonEmail.Equals(lc.Email)
select p.PersonKey).FirstOrDefault();
//cast ID into a int
int key = (int)uID;
//store it in a session key
Session["PersonKey"] = key;
var pName = (from p in db.People
where p.PersonEmail.Equals(lc.Email)
select p.PersonFirstName).FirstOrDefault();
//create a message class and pass the string to the result view
Message msg = new Message("Welcome, " + pName + ". You can now make donation or request for grant.");
return(RedirectToAction("Result", msg));
}
//if it fails pass this message to the result view
Message message = new Message("Invalid Login");
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "UserName , Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginresult = db.usp_Login(lc.UserName, lc.Password);
if (loginresult != -1)
{
var uid = (from r in db.People
where r.PersonEmail.Equals(lc.UserName)
select r.PersonKey).FirstOrDefault();
int Key = (int)uid;
Session["userKey"] = Key;
Message msg = new Message("Welcome, " + lc.UserName + ". You can now Donate or apply for a assistance.");
return(RedirectToAction("Result", msg));
}
Message message = new Message("Invalid Login");
return(View("Result", message));
}
// get the fields from the forms and bind them to the class
public ActionResult Index([Bind(Include = "UserName,Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int logingResult = db.usp_Login(lc.Username, lc.Password);
if (logingResult != -1)
{
var uid = (from p in db.People
where p.PersonEmail.Equals(lc.Username)
select p.PersonKey).FirstOrDefault();
int rKey = (int)uid;
Session["userKey"] = rKey;
Session["Username"] = lc.Username;
Message msg = new Message("Thank you " + lc.Username + " for logging in. You can now donate or apply for assitance");
return(RedirectToAction("Result", msg));
}
Message msge = new Message("Invalid Login! Please try again.");
return(View("Result", msge));
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
int results = db.usp_Login(lc.UserName, lc.Password);
int perKey = 0;
Message msg = new Message();
if (results != -1)
{
var pkey = (from p in db.People
where p.PersonEmail.Equals(lc.UserName)
select p.PersonKey).FirstOrDefault();
perKey = (int)pkey;
Session["PersonKey"] = perKey;
msg.MessageText = "Welcome, " + lc.UserName;
}
else
{
msg.MessageText = "Invalid Login";
}
return(View("Result", msg));
}
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc)
{
int results = db.usp_Login(lc.Email, lc.Password);
int revKey = 0;
Message msg = null;
if (results != -1)
{
var pkey = (from e in db.People
where e.PersonEmail.Equals(lc.Email)
select e.PersonKey).FirstOrDefault();
revKey = (int)pkey;
Session["PersonKey"] = revKey;
//msg.MessageText = "Welcome" + lc.Email;
}
else
{
msg.MessageText = "Invalid Login";
}
return(View("result", msg));
}
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginResult = db.usp_Login(lc.Email, lc.Password);
if (loginResult != -1)
{
var uid = (from r in db.People
where r.PersonEmail.Equals(lc.Email)
select r.PersonKey).FirstOrDefault();
int rKey = (int)uid;
Session["reviewerKey"] = rKey;
MessageClass msg = new MessageClass();
msg.MessageText = "Thank You! You are now logged in as '" + lc.Email + "'.";
return(RedirectToAction("Result", msg));
}
MessageClass message = new MessageClass();
message.MessageText = "Invalid Login";
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "userName, password")] PersonLogin pl)
{
int res = db.usp_Login(pl.userName, pl.password);
int personKey = 0;
Message message = new Message();
if (res == -1)
{
message.messageText = "Invalid login.";
Response.AddHeader("Refresh", "3;url=login");
}
else
{
var pkey = (from r in db.People where r.PersonEmail.Equals(pl.userName) select r.PersonKey).FirstOrDefault();
var firstName = (from r in db.People where r.PersonEmail.Equals(pl.userName) select r.PersonFirstName).FirstOrDefault();
personKey = (int)pkey;
Session["PersonKey"] = personKey;
message.messageText = "Welcome " + (string)firstName;
}
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "UserName,Password")] LoginClass loginclass)
{
CommunityAssist2017Entities br = new CommunityAssist2017Entities();
int result = br.usp_Login(loginclass.UserName, loginclass.Password);
int pk = 0;
Message n = new Message();
if (result != -1)
{
var pkey = (from r in br.People
where r.PersonEmail.Equals(loginclass.UserName)
select r.PersonKey).FirstOrDefault();
pk = (int)pkey;
Session["PersonKey"] = pk;
n.Messagetext = "Welcome";
}
else
{
n.Messagetext = "invalid login";
}
return(View("Result", n));
}
public ActionResult Index([Bind(Include = "Email, Password, UserKey")] LoginClass loginClass)
{
//make connection to Ado Entity model classes
CommunityAssist2017Entities user = new CommunityAssist2017Entities();
//Assign user key a value of 0
loginClass.UserKey = 0;
//pass the values to the stored procedure and get result (-1 = failure)
int result = user.usp_Login(loginClass.Email, loginClass.Password);
//test the results
if (result != -1)
{
//run a query to get the UserKey
var ukey = (from r in user.People
where r.PersonEmail.Equals(loginClass.Email)
select r.PersonKey).FirstOrDefault();
loginClass.UserKey = (int)ukey;
Session["personKey"] = loginClass.UserKey;
}
//return the class to the Result view
return(View("Result", loginClass));
}
public ActionResult Index(
//bind form values to the class preceeding square brackets
[Bind(Include = "ClientEmail, ClientPassword")]
AuthenticateClient authClient)
{
Message argMessage = new Message();
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
/*Logging In
*For the login validation we will use the built in stored procedure
*usp_login which takes a username (email) and a password.*/
int verifyAuthentication = db.usp_Login( authClient.ClientEmail,
authClient.ClientPassword );
/*If the validation fails (the stored procedure returns a -1 if it
*fails), the Result page should say something like Validation
*failed, please try again or register if you have not done so yet.*/
if ( verifyAuthentication != -1 )
{
var personKey = ( from r in db.People
where r.PersonEmail.Equals
( authClient.ClientEmail )
select r.PersonKey ).FirstOrDefault();
int clientKey = (int)personKey;
Session["sessClientKey"] = clientKey;
argMessage.MessageText = "Thank you for verifying creditials " +
"of e-mail account: " + authClient.ClientEmail + ".";
return RedirectToAction("Result", argMessage);
}
argMessage.MessageText = "Invaild authentication credentials " +
"please try again or register if you have not done so yet.";
return View("Result", argMessage);
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
int loginResult = db.usp_Login(lc.UserName, lc.Password);
if (loginResult != -1)
{
var uid = (from u in db.People
where u.PersonEmail.Equals(lc.UserName)
select u.PersonKey).FirstOrDefault();
int uKey = (int)uid;
Session["personKey"] = uKey;
Message msg = new Message();
msg.MessageText = "Thank You, " + lc.UserName + " for logging in. You can now donate or apply for assistance";
return(RedirectToAction("Result", msg));
}
Message loginFailed = new Message();
loginFailed.MessageText = "Login Failed";
return(View("Result", loginFailed));
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass login)
{
CommunityAssist2017Entities db = new CommunityAssist2017Entities();
int loginResult = db.usp_Login(login.UserName, login.Password);
if (loginResult != -1)
{
var uid = (from r in db.People
where r.PersonEmail.Equals(login.UserName)
select r.PersonKey).FirstOrDefault();
int personKey = (int)uid;
Session["personKey"] = personKey;
Message loginOkay = new Message();
loginOkay.MessageText = "Thank you, " + login.UserName + " login successful!";
return(RedirectToAction("Result", loginOkay));
}
Message loginFail = new Message();
loginFail.MessageText = "Invalid credentials! Try again or register.";
return(View("Result", loginFail));
}
