protected void btnRegister_Click(object sender, EventArgs e)
    {
        try{
            BookReviewDbEntities db = new BookReviewDbEntities();
            Reviewer             r  = new Reviewer();
            r.ReviewerFirstName   = txtFirstName.Text;
            r.ReviewerLastName    = txtLastName.Text;
            r.ReviewerEmail       = txtEmail.Text;
            r.ReviewerUserName    = txtUserName.Text;
            r.ReviewPlainPassword = txtPassword.Text;

            KeyCode kc   = new KeyCode();
            int     code = kc.GetKeyCode();
            r.ReviewerKeyCode = code;

            PasswordHash ph     = new PasswordHash();
            Byte[]       hashed = ph.HashIt(txtPassword.Text, code.ToString());
            r.ReviewerHashedPass = hashed;

            r.ReviewerDateEntered = DateTime.Now;

            //save changes
            db.Reviewers.Add(r);
            db.SaveChanges();
            lblErrorSuccess.Text = "Successfully Registered";
        }
        catch (Exception ex) {
            lblErrorSuccess.Text = ex.Message;
        }
    }
 protected void btnRegister_Click(object sender, EventArgs e)
 {
     try
     {
         BookReviewDbEntities db = new BookReviewDbEntities();
         RandomSeed           rs = new RandomSeed();
         int          seed       = rs.GetSeed();
         PasswordHash ph         = new PasswordHash();
         Byte[]       hashed     = ph.HashIt(txtPassword.Text, seed.ToString());
         Reviewer     rev        = new Reviewer();
         rev.ReviewerFirstName   = txtFirstName.Text;
         rev.ReviewerUserName    = txtUserName.Text;
         rev.ReviewerLastName    = txtLastName.Text;
         rev.ReviewerEmail       = txtEmail.Text;
         rev.ReviewerDateEntered = DateTime.Now;
         rev.ReviewPlainPassword = txtPassword.Text;
         rev.ReviewerKeyCode     = seed;
         rev.ReviewerHashedPass  = hashed;
         db.Reviewers.Add(rev);
         db.SaveChanges();
         lblErrorSuccess.Text = "Reviewer Saved";
     }
     catch (Exception ex)
     {
         lblErrorSuccess.Text = ex.Message;
     }
 }
Esempio n. 3
0
        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));
        }
 protected void btnRegister_Click(object sender, EventArgs e)
 {
     try
     {
         BookReviewDbEntities db = new BookReviewDbEntities();
         RandomSeed rs = new RandomSeed();
         int seed = rs.GetSeed();
         PasswordHash ph = new PasswordHash();
         Byte[] hashed = ph.HashIt(txtPassword.Text, seed.ToString());
         Reviewer rev = new Reviewer();
         rev.ReviewerFirstName = txtFirstName.Text;
         rev.ReviewerUserName = txtUserName.Text;
         rev.ReviewerLastName = txtLastName.Text;
         rev.ReviewerEmail = txtEmail.Text;
         rev.ReviewerDateEntered = DateTime.Now;
         rev.ReviewPlainPassword = txtPassword.Text;
         rev.ReviewerKeyCode = seed;
         rev.ReviewerHashedPass = hashed;
         db.Reviewers.Add(rev);
         db.SaveChanges();
         lblErrorSuccess.Text = "Reviewer Saved";
     }
     catch(Exception ex)
     {
         lblErrorSuccess.Text = ex.Message;
     }
 }
Esempio n. 5
0
        public ActionResult Index([Bind(Include = "Title, ISBN, Author")] NewBookClass nb)
        {
            BookReviewDbEntities db = new BookReviewDbEntities();
            Author a = new Author();

            a.AuthorName = nb.Author;
            db.Authors.Add(a);
            db.SaveChanges();
            // for donation get userkey from the session
            Book b = new Book();

            b.BookTitle     = nb.Title;
            b.BookISBN      = nb.ISBN;
            b.BookEntryDate = DateTime.Now;
            Author author = db.Authors.FirstOrDefault
                                (x => x.AuthorName == nb.Author);

            b.Authors.Add(author);

            db.Books.Add(b);
            db.SaveChanges();

            Message m = new Message();

            m.MessageText = "Thank you, the book has been added";

            return(View("Result", m));
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        BookReviewDbEntities db = new BookReviewDbEntities();
        var auths = (from a in db.Authors select a).ToList();

        GridView.DataSource = auths;
        GridView.DataBind();
    }
        public ActionResult Index()
        {
            BookReviewDbEntities db = new BookReviewDbEntities();

            //var bks = (from b in db.Books
            //          select b).ToList();
            return(View(db.Books.ToList()));
        }
        public ActionResult Index()
        {
            // add ref to Entities
            BookReviewDbEntities db = new BookReviewDbEntities();

            //return books as a list
            return(View(db.Books.ToList()));
        }
Esempio n. 9
0
    protected void SubmitButton_Click(object sender, EventArgs e)
    {
        BookReviewDbEntities db = new BookReviewDbEntities();
        Author a = new Author();

        a.AuthorName = AuthorTextBox.Text;
        db.Authors.Add(a);
        db.SaveChanges();

        Response.Redirect("AuthorList.aspx");
    }
Esempio n. 10
0
    //gets the user info from the database
    private void GetUserInfo()
    {
        //declare the ADO Entities
        BookReviewDbEntities brde = new BookReviewDbEntities();
        //query the fields
        var info = from i in brde.Reviewers
                   where i.ReviewerUserName.Equals(username)
                   select new { i.ReviewerKey, i.ReviewerHashedPass, i.ReviewerKeyCode };

        //loop through the results and assign the
        //values to the field variables
        foreach (var u in info)
        {
            seed = u.ReviewerKeyCode;
            dbhash = u.ReviewerHashedPass;
            key = u.ReviewerKey;
        }
    }
Esempio n. 11
0
    //gets the user info from the database
    private void GetUserInfo()
    {
        //declare the ADO Entities
        BookReviewDbEntities brde = new BookReviewDbEntities();
        //query the fields
        var info = from i in brde.Reviewers
                   where i.ReviewerUserName.Equals(username)
                   select new { i.ReviewerKey, i.ReviewerHashedPass, i.ReviewerKeyCode };

        //loop through the results and assign the
        //values to the field variables
        foreach (var u in info)
        {
            seed   = u.ReviewerKeyCode;
            dbhash = u.ReviewerHashedPass;
            key    = u.ReviewerKey;
        }
    }
Esempio n. 12
0
    protected void SubmitButton_Click(object sender, EventArgs e)
    {
        string user     = UserTextBox.Text;
        string first    = FirstNameTextBox.Text;
        string last     = LastNameTextBox.Text;
        string email    = EmailTextBox.Text;
        string password = ConfirmTextBox.Text;

        BookReviewDbEntities db = new BookReviewDbEntities();
        int result = db.usp_NewReviewer(user, first, last, email, password);

        if (result != -1)
        {
            Response.Redirect("Default.aspx");
        }
        else
        {
            ErrorLabel.Text = "Something went terribly wrong";
        }
    }
Esempio n. 13
0
    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";
        }
    }
Esempio n. 14
0
        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));
        }
Esempio n. 16
0
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        try{
            BookReviewDbEntities db = new BookReviewDbEntities();
            Reviewer r = new Reviewer();
            r.ReviewerLastName = txtLastName.Text;
            r.ReviewerFirstName = txtFirstName.Text;
            r.ReviewerEmail = txtEmail.Text;
            r.ReviewerUserName = txtUserName.Text;
            r.ReviewerDateEntered = DateTime.Now;
            r.ReviewPlainPassword = txtPassword.Text;

            KeyCode kc = new KeyCode();
            int code = kc.GetKeyCode();

            PasswordHash ph = new PasswordHash();
            Byte[] hashed = ph.HashIt(txtPassword.Text, code.ToString());

            r.ReviewerKeyCode = code;
            r.ReviewerHashedPass = hashed;

            db.Reviewers.Add(r);

            CheckinLog c = new CheckinLog();
            c.CheckinDateTime = DateTime.Now;
            c.Reviewer = r;
            db.CheckinLogs.Add(c);

            db.SaveChanges();
            lblErrorSuccess.Text = "Reviewer Saved";
            }
        catch(Exception ex)
         {
            lblErrorSuccess.Text = ex.Message;
         }
    }
Esempio n. 17
0
    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";
        }
    }
Esempio n. 18
0
        public ActionResult Index()
        {
            BookReviewDbEntities db = new BookReviewDbEntities();

            return(View(db.Books.ToList()));
        }