public int ReviewerLogin(string userName, string password)
{
int reviewerkey = 0;
int result = db.usp_ReviewerLogin(userName, password);
if (result != -1)
{
var key = (from r in db.Reviewers
where r.ReviewerUserName.Equals(userName)
select new { r.ReviewerKey }).FirstOrDefault();
reviewerkey = key.ReviewerKey;
}
return(reviewerkey);
}
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(key);
}
protected void LoginButton_Click(object sender, EventArgs e)
{
int key = 0; //default key
BookReviewDbEntities1 db = new BookReviewDbEntities1();
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; //Session is a cookie for a users interactions during that visit to the webpage but is stored server side
ResultLabel.Text = "Welcome" + key.ToString();
}
else
{
ResultLabel.Text = "Invalid Login";
}
}
