public ActionResult Index()
{
BookReviewDbEntities1 db = new BookReviewDbEntities1();
//var bks = (from b in db.Books
//select b).ToList();
return(View(db.Books.ToList()));
}
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";
}
}