public int getUserID(string email, string password)
{
string clause = "WHERE email = '" + email + "' AND password = '******';";
DataTable dt = DatabaseHandler.Select("Users", clause);
return(int.Parse(dt.Rows[0][0].ToString()));
}
public bool addItem(string name, string category, string picture, string description, string date, string location)
{
itemID = DatabaseHandler.Select("Item", "").Rows.Count + 1;
this.name = name;
this.category = category;
this.pictureString = picture;
this.description = description;
this.date = date;
this.location = location;
if (Login.loginUser)
{
userID = Login.loginUserID;
}
if (SignUp.signUpUser)
{
userID = SignUp.signUpUserID;
}
bool success;
try
{
DatabaseHandler.Insert("Item", new string[]
{
itemID.ToString(),
name,
category,
picture,
description,
date,
location,
userID.ToString()
});
success = true;
}
catch (Exception e)
{
Console.WriteLine("Exception thrown");
success = false;
throw e;
}
if (success)
{
return(true);
}
else
{
return(false);
}
}
public bool login(string email, string password)
{
User user = new User();
string clause = "WHERE email = '" + email + "' AND password = '******';";
DataTable dt = DatabaseHandler.Select("Users", clause);
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
public bool addUser(string firstName, string lastName, string email, string mobileNumber, string gender, int age, string password)
{
userID = DatabaseHandler.Select("Users", "").Rows.Count + 1;
this.firstName = firstName;
this.lastName = lastName;
this.email = email;
this.mobileNumber = mobileNumber;
this.gender = gender;
this.age = age;
this.password = password;
string clause = "WHERE email = '" + email + "';";
DataTable dt = DatabaseHandler.Select("Users", clause);
if (dt.Rows.Count == 0)
{
try
{
int count = DatabaseHandler.Select("Users", "").Rows.Count + 1;
DatabaseHandler.Insert("Users", new string[]
{
count.ToString(),
firstName,
lastName,
email,
mobileNumber.ToString(),
age.ToString(),
gender.ToString(),
password,
});
return(true);
}
catch (Exception e)
{
Console.WriteLine("Exception thrown");
throw e;
}
}
else
{
return(false);
}
}
public User getUser(string email, string password)
{
User user = new User();
string clause = "WHERE email = '" + email + "' AND password = '******';";
try
{
DataTable dt = DatabaseHandler.Select("Users", clause);
user.userID = int.Parse(dt.Rows[0][0].ToString());
user.firstName = dt.Rows[0][1].ToString();
user.lastName = dt.Rows[0][2].ToString();
user.email = dt.Rows[0][3].ToString();
user.mobileNumber = dt.Rows[0][4].ToString();
user.age = int.Parse(dt.Rows[0][5].ToString());
user.gender = dt.Rows[0][6].ToString();
user.password = dt.Rows[0][7].ToString();
return(user);
}
catch (Exception e)
{
Console.WriteLine("Couldn't select User");
throw e;
}
}
private void LoginButtonClicked(object sender, RoutedEventArgs e)
{
EmailTextBox.Text.ToLower();
if (EmailTextBox.Text == "" || PasswordTextBox.Password == "")
{
MessageBox.Show("Please enter your Email or Password \nEmail & Password can't be empty", "Error", MessageBoxButton.OK);
}
else
{
bool login = new User().login(EmailTextBox.Text, PasswordTextBox.Password);
if (login)
{
loginUser = true;
SignUp.signUpUser = false;
DataTable dt = DatabaseHandler.Select("Users", new string[] { "userID" }, $"WHERE email = '{EmailTextBox.Text}';");
loginUserID = int.Parse(dt.Rows[0][0].ToString());
NavigationService.Navigate(new Uri("Home.xaml", UriKind.RelativeOrAbsolute));
}
else
{
MessageBox.Show("Please SignUp \nthe email you entered isn't registered", "Error", MessageBoxButton.OK);
}
}
}
private void SignUpClicked(object sender, RoutedEventArgs e)
{
if (FirstNameTextBox.Text != "" || LastNameTextBox.Text != "" || EmailTextBox.Text != "" || MobileNumberTextBox.Text != "" ||
AgeTextBox.Text != "" || GenderTextBox.Text != "" || PasswordTextBox.Password != "" || ConfirmPasswordTextBox.Password != "")
{
if (notContainsAlphabet(AgeTextBox.Text))
{
if (MobileNumberTextBox.Text.Length == 11 && notContainsAlphabet(MobileNumberTextBox.Text))
{
if (PasswordTextBox.Password == ConfirmPasswordTextBox.Password)
{
string clause = "WHERE email = '" + EmailTextBox.Text + "';";
DataTable dt = DatabaseHandler.Select("Users", clause);
if (dt.Rows.Count == 0)
{
if (new User().addUser(
FirstNameTextBox.Text,
LastNameTextBox.Text,
EmailTextBox.Text,
MobileNumberTextBox.Text,
GenderTextBox.Text,
int.Parse(AgeTextBox.Text),
PasswordTextBox.Password))
{
DataTable dt2 = DatabaseHandler.Select("Users", new string[] { "userID" }, $"WHERE email = '{EmailTextBox.Text}';");
signUpUserID = int.Parse(dt2.Rows[0][0].ToString());
signUpUser = true;
Login.loginUser = false;
MessageBox.Show("Signed up Successfully", "Done!", MessageBoxButton.OK);
NavigationService.Navigate(new Uri("Home.xaml", UriKind.RelativeOrAbsolute));
}
else
{
MessageBox.Show("An unknown error occured /nPlease try again", "Error", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("This email already exists, please login", "Error", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("The passwords don't match", "Error", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("Please enter your mobile number correctly", "Error", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("Please enter your age correctly", "Error", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("Please make sure that you entered all the fields correctly", "Error", MessageBoxButton.OK);
}
}