private static bool registerContractor(string firstname, string lastname, string email, string phone, string password, string company, string companyAddress, string companyPhone, string companyEmail)
{
connection.Open();
string pswd = PasswordEncryption.CreateHash(password);
SqlCommand cmd = new SqlCommand("insert into UserAccounts ([Email], [Password], [UserType], [Confirmed]) VALUES (@email, @password, @usertype, @confirmed)", connection);
cmd.Parameters.AddWithValue("@email", email.ToLower());
cmd.Parameters.AddWithValue("@password", pswd);
cmd.Parameters.AddWithValue("@usertype", "Contractor");
cmd.Parameters.AddWithValue("@confirmed", 0);
int i = cmd.ExecuteNonQuery();
int j = companyCheck(company, firstname, lastname, email, phone, companyAddress, companyPhone, companyEmail).ExecuteNonQuery();
connection.Close();
confirmationEmail(email, firstname + " " + lastname);
if (i > 0 && j > 0)
{
return(true);
}
else
{
return(false);
}
}
private static bool registerOccupant(string firstname, string lastname, string email, string phone, string password)
{
connection.Open();
string pswd = PasswordEncryption.CreateHash(password);
SqlCommand cmd = new SqlCommand("insert into UserAccounts ([Email], [Password], [UserType], [Confirmed]) VALUES (@email, @password, @usertype, @confirmed)", connection);
cmd.Parameters.AddWithValue("@email", email.ToLower());
cmd.Parameters.AddWithValue("@password", pswd);
cmd.Parameters.AddWithValue("@usertype", "Occupant");
cmd.Parameters.AddWithValue("@confirmed", 0);
int i = cmd.ExecuteNonQuery();
SqlCommand occmd = new SqlCommand("Insert into Customer (First, Last, Email, Phone#) VALUES (@firstname, @lastname, @emailaddress, @phonenumber)", connection);
occmd.Parameters.AddWithValue("@firstname", firstname);
occmd.Parameters.AddWithValue("@lastname", lastname);
occmd.Parameters.AddWithValue("@emailaddress", email.ToLower());
occmd.Parameters.AddWithValue("@phonenumber", phone);
int j = occmd.ExecuteNonQuery();
connection.Close();
confirmationEmail(email, firstname + " " + lastname);
if (i > 0 && j > 0)
{
return(true);
}
else
{
return(false);
}
}