public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
//make a connection to the Entities
BookReviewDbEntities db = new BookReviewDbEntities();
//use the stored procedure prebuilt in the database
int result = db.usp_ReviewerLogin(lc.UserName, lc.Password);
//if the result is valid
if (result != -1)
{
//look up the users key
var uID = (from r in db.Reviewers
where r.ReviewerUserName.Equals(lc.UserName)
select r.ReviewerKey).FirstOrDefault();
//cast it to an int
int key = (int)uID;
//strore it in a session key
Session["userKey"] = key;
//create a message class and pass the string to the result view
Message msg = new Message("Welcome, " + lc.UserName + ". You can now add and review books.");
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 int BookReviewLogin(string user, string password)
{
int key = 0;
int result = bre.usp_ReviewerLogin(user, password);
if (result != -1)
{
var ky = (from r in bre.Reviewers
where r.ReviewerUserName.Equals(user)
select r.ReviewerKey).FirstOrDefault();
key = (int)ky;
}
return(key);
}
public int Login(string user, string password)
{
//just like the login we did in the last assignment
int key = 0;
int result = db.usp_ReviewerLogin(user, password);
if (result != -1)
{
var userKey = (from k in db.Reviewers
where k.ReviewerUserName.Equals(user)
select k.ReviewerKey).FirstOrDefault();
key = (int)userKey;
}
return(result);
}
public int ReviewerLogin(string password, string username)
{
int result = db.usp_ReviewerLogin(username, password);
if (result != -1)
{
var key = from k in db.Reviewers
where k.ReviewerUserName.Equals(username)
select new { k.ReviewerKey };
foreach (var k in key)
{
result = (int)k.ReviewerKey;
}
}
return(result);
}
protected void LoginButton_Click(object sender, EventArgs e)
{
int key = 0;
BookReviewDbEntities db = new BookReviewDbEntities();
int success = db.usp_ReviewerLogin(UserTextBox.Text, PasswordTextBox.Text);
if (success != -1)
{
var uKey = (from k in db.Reviewers
where k.ReviewerUserName.Equals(UserTextBox.Text)
select k.ReviewerKey).FirstOrDefault();
key = (int)uKey;
Session["userKey"] = key;
Response.Redirect("Author.aspx");
}
else
{
ResultLabel.Text = "Invalid Login";
}
}
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc)
{
BookReviewDbEntities db = new BookReviewDbEntities();
int loginResult = db.usp_ReviewerLogin(lc.UserName, lc.Password);
if (loginResult != -1)
{
var uid = (from r in db.Reviewers
where r.ReviewerUserName.Equals(lc.UserName)
select r.ReviewerKey).FirstOrDefault();
int rKey = (int)uid;
Session["reviewerKey"] = rKey;
MessageClass msg = new MessageClass();
msg.MessageText = "Thank You, " + lc.UserName + " for logging in. You can now donate or apply for assistance.";
return(RedirectToAction("Result", msg));
}
MessageClass message = new MessageClass();
message.MessageText = "Invalid Login";
return(View("Result", message));
}
//overloaded Index method
public ActionResult Index([Bind(Include = "UserName, Password, ReviewerKey")] LoginClass loginClass)
{
//make connection to Ado Entity model classes
BookReviewDbEntities br = new BookReviewDbEntities();
//Assign review key a value of 0
loginClass.ReviewerKey = 0;
//pass the values to the stored procedure and get result (-1 = failure)
int result = br.usp_ReviewerLogin(loginClass.UserName, loginClass.Password);
//test the results
if (result != -1)
{
//run a query to get the ReviewerKey
var ukey = (from r in br.Reviewers
where r.ReviewerUserName.Equals(loginClass.UserName)
select r.ReviewerKey).FirstOrDefault();
loginClass.ReviewerKey = (int)ukey;
}
//return the class to the Result view
return(View("Result", loginClass));
}
protected void loginbutton_Click(object sender, EventArgs e)
{
int key = 0;
BookReviewDbEntities db = new BookReviewDbEntities();
int success = db.usp_ReviewerLogin(usertextbox.Text, passwordtextbox.Text);
if (success != -1)
{
var uKey = (from K in db.Reviewers
where K.ReviewerUserName.Equals(usertextbox.Text)
select K.ReviewerKey).FirstOrDefault();
key = (int)uKey;
Session["userkey"] = key;
ResultLabel.Text = " Helloooo" + key.ToString();
}
else
{
ResultLabel.Text = " Errrrr";
}
}
