Exemple #1
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            #region LOGIN
            //conditions for entered data
            if (username_textbox.Text == "" && password_textbox.Text == "")
            {
                login_label.Visible = true;
                login_label.Text    = "No Data entered";
            }
            else if (username_textbox.Text == "")
            {
                login_label.Visible = true; login_label.Text = "No Username Entered";
            }
            else if (password_textbox.Text == "")
            {
                login_label.Visible = true; login_label.Text = "No Password Entered";
            }

            else
            {
                //start a Model Entity Object
                soen341dBEntities soen341dB_context = new soen341dBEntities();
                //dB table constructor
                registration newuser  = new registration();
                string       username = username_textbox.Text;
                string       password = globalvariables.EncodePassword(password_textbox.Text);
                try
                {
                    //get the retrived_user
                    var retrieved_user = (from person in soen341dB_context.registrations
                                          where person.Password == password
                                          where person.Username == username
                                          select person).FirstOrDefault();

                    //check to see if a record of it exists
                    if (retrieved_user == null)
                    {
                        login_label.Text = "Account Information Incorrect"; login_label.Visible = true;
                    }
                    else
                    {
                        login_label.Visible = true;
                        login_label.Text    = "Login Validated";
                        //encrypt url so people cannot change it to get other people's data;
                        //Query the username to another page by using question mark variable name =
                        Response.Redirect("LoggedIn.aspx?Username="******"Database Exception Occured :" + error.ToString();
                }
            }
            #endregion
        }
Exemple #2
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            #region REGISTER
            //check passwords match
            if (password_textbox1.Text != password_text2box.Text)
            {
                register_label.Visible = true;
                register_label.Text    = "Passwords do not match";
            }
            //check its not empty the password
            else if (password_text2box.Text == "" || password_textbox1.Text == "")
            {
                register_label.Visible = true;
                register_label.Text    = "Don't leave passwords blank stupid";
            }

            else
            {
                soen341dBEntities soen341dB_context = new soen341dBEntities();
                registration      newuser           = new registration();
                //checking if either the user or email is already registered
                var username_in_dB = (from a_username in soen341dB_context.registrations
                                      where a_username.Username == username_textbox.Text
                                      select a_username).FirstOrDefault();

                var email_in_dB = (from an_email in soen341dB_context.registrations
                                   where an_email.email == email_textbox.Text
                                   select an_email).FirstOrDefault();
                var studentid_in_dB = (from a_student_id in soen341dB_context.registrations
                                       where a_student_id.StudentId == studentid_textbox.Text
                                       select a_student_id).FirstOrDefault();


                if (email_in_dB != null)
                {
                    register_label.Text = "Email already registered"; register_label.Visible = true;
                }
                if (username_in_dB != null)
                {
                    register_label.Text = "Username already Exists"; register_label.Visible = true;
                }
                if (studentid_in_dB != null)
                {
                    register_label.Text = "Student ID Already taken"; register_label.Visible = true;
                }

                //if it doesnt retrieve records make a new record
                if (email_in_dB == null && username_in_dB == null)
                {
                    try
                    {
                        newuser.Username  = username_textbox.Text;
                        newuser.Password  = globalvariables.EncodePassword(password_textbox1.Text);
                        newuser.email     = email_textbox.Text;
                        newuser.StudentId = studentid_textbox.Text;
                        soen341dB_context.registrations.Add(newuser);
                        soen341dB_context.SaveChanges();
                    }
                    catch (Exception error)
                    {
                        register_label.Visible = true;
                        register_label.Text    = "Database Exception Occured: " + error.ToString();
                    }
                    finally
                    {
                        register_label.Visible = true;
                        register_label.Text    = "Thank You for registering, You should have recieved an email from us!";

                        MailMessage mail = new MailMessage();
                        mail.To.Add(email_textbox.Text);
                        mail.From       = new MailAddress("*****@*****.**");
                        mail.Subject    = "mYScheduler Registration Confirmation";
                        mail.Body       = "Thank You for registering to the Concordia University mYScheduler. Your username is: " + username_textbox.Text + " Please report bugs and suggestions to [email protected]";
                        mail.IsBodyHtml = true;
                        SmtpClient smtp = new SmtpClient();
                        smtp.Host = "mail.atsebak.com";
                        smtp.Port = 587;
                        smtp.UseDefaultCredentials = true;
                        smtp.Credentials           = new NetworkCredential("*****@*****.**", "softwareprocess");
                        smtp.EnableSsl             = false;
                        smtp.Send(mail);
                    }
                }
            }

            #endregion
        }