/// <summary> /// Fucntion that adds new user into database. This function is called when user register hinself in a program /// </summary> public void AddBook(string titleText, int yearText, string authorText) { using (Books365.AppContext db = new Books365.AppContext()) { Book newBook = new Book { Title = titleText, Year = yearText, Author = authorText, }; db.Books.Add(newBook); db.SaveChanges(); db.ReadingStatuses.Add(new ReadingStatus { UserEmail = db.EmailCurrentUser.FirstOrDefault().Email, BookISBN = db.Books .Where(u => u.Title == titleText) .Where(u => u.Year == yearText) .Where(u => u.Author == authorText) .FirstOrDefault().ISBN, PagesWritten = 0, Rating = 0, StartOfReading = DateTime.Now, BookStatus = "reading", }); db.SaveChanges(); } }
/// <summary> /// Function that checks users input information and allows him to login into MainMenu window /// </summary> public bool Login(TextBox text, PasswordBox password) { using (Books365.AppContext db = new Books365.AppContext()) { var registered_user_email = db.Users .Where(u => u.Email == text.Text.ToString()).FirstOrDefault(); var registered_user_password = db.Users.Where(u => u.Password == password.Password.ToString()).FirstOrDefault(); if (registered_user_email == null || registered_user_password == null) { MessageBox.Show("Wrong password or email", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (registered_user_email != null && registered_user_password != null) { db.EmailCurrentUser.Add(new EmailOfCurrentUser { Email = text.Text.ToString(), }); db.SaveChanges(); return(true); } return(false); } }
/// <summary> /// Function that allows to edit user's profile data. This function can be called only for registered users. /// </summary> public void EditProfile(TextBox firstNameTextBox, TextBox lastNameTextBox, PasswordBox passwordTextBox, PasswordBox confirmPasswordTextBox, TextBox secretPinTextBox) { using (Books365.AppContext db = new Books365.AppContext()) { var currentUserEmail = db.EmailCurrentUser.FirstOrDefault(); var registered_user = db.Users .Where(u => u.Email == currentUserEmail.Email).FirstOrDefault(); firstNameTextBox.Text = registered_user.FirstName; lastNameTextBox.Text = registered_user.LastName; passwordTextBox.Password = registered_user.Password; confirmPasswordTextBox.Password = registered_user.Password; secretPinTextBox.Text = registered_user.SecretPin.ToString(); } }
/// <summary> /// Function that adds new user into database. This function is called when user register hinself in a program /// </summary> public void AddNewUser(TextBox firstNameTextBox, TextBox lastNameTextBox, PasswordBox passwordTextBox, TextBox emailTextBox, TextBox secretPinTextBox) { using (Books365.AppContext db = new Books365.AppContext()) { db.Users.Add(new Books365.User { FirstName = firstNameTextBox.Text.ToString(), LastName = lastNameTextBox.Text.ToString(), Password = passwordTextBox.Password.ToString(), Email = emailTextBox.Text.ToString(), SecretPin = int.Parse(secretPinTextBox.Text.ToString()), }); db.EmailCurrentUser.Add(new EmailOfCurrentUser { Email = emailTextBox.Text.ToString(), }); db.SaveChanges(); } }
/// <summary> /// Function that change password if user enter his email and secret pin corectly. /// </summary> public bool ChangePassword(string email, TextBox secretPinTextBox, TextBox newPasswordTextBox) { using (Books365.AppContext db = new Books365.AppContext()) { var registered_user_email = db.Users .Where(u => u.Email == email).FirstOrDefault(); var registered_user_pin = db.Users.Where(u => u.SecretPin == int.Parse(secretPinTextBox.Text.ToString()) && u.Email == registered_user_email.Email).FirstOrDefault(); if (registered_user_pin == null) { return(false); } else { Books365.User u = db.Users.Single(u => u.Email == email); u.Password = newPasswordTextBox.Text; db.SaveChanges(); return(true); } } }