/// <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);
}
}
}
