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