public void WriteCustomer(Customer c)
{
string sqlPerson = "Insert into Person (LastName, FirstName) Values (@LastName, @FirstName)";
string sqlVehicle = "Insert into Customer.Vehicle (LicenseNumber, VehicleMake, VehicleYear, PersonKey) " + "Values(@License, @Make, @Year, ident_Current('Person'))";
string sqlRegisteredCustomer = "Insert into Customer.RegisteredCustomer(Email, CustomerPasscode, " + "CustomerPassword, CustomerHashedPassword, PersonKey) " + "Values(@Email, @Passcode, @password, @hashedpass, ident_Current('Person'))";
SqlCommand personCmd = new SqlCommand(sqlPerson, connect);
personCmd.Parameters.AddWithValue("@LastName", c.LastName);
personCmd.Parameters.AddWithValue("@FirstName", c.FirstName);
SqlCommand vehicleCmd = new SqlCommand(sqlVehicle, connect);
vehicleCmd.Parameters.AddWithValue("@License", c.LicenseNumber);
vehicleCmd.Parameters.AddWithValue("@Make", c.VehicleMake);
vehicleCmd.Parameters.AddWithValue("@Year", c.VehicleYear);
PasscodeGenerator pg = new PasscodeGenerator();
PasswordHash ph = new PasswordHash();
int passcode = pg.GetHashCode();
SqlCommand regCustomerCmd = new SqlCommand(sqlRegisteredCustomer, connect);
regCustomerCmd.Parameters.AddWithValue("@Email", c.Email);
regCustomerCmd.Parameters.AddWithValue("@Passcode", passcode);
regCustomerCmd.Parameters.AddWithValue("@Password", c.PlainPassword);
regCustomerCmd.Parameters.AddWithValue("@hashedPass", ph.HashIt(c.PlainPassword, passcode.ToString()));
connect.Open();
personCmd.ExecuteNonQuery();
vehicleCmd.ExecuteNonQuery();
regCustomerCmd.ExecuteNonQuery();
connect.Close();
}
public void WriteCustomer(Customer c)
{
string sqlPerson = "Insert into Person (PersonLastName, PersonFirstName, PersonUsername, Personpasskey, PersonPlainPassword, " +
"PersonUserPassword) Values (@LastName, @FirstName, @Email, @Passcode, @password, @hashedpass)";
PasscodeGenerator pg = new PasscodeGenerator();
PasswordHash ph = new PasswordHash();
int passcode = pg.GetHashCode();
SqlCommand personCmd = new SqlCommand(sqlPerson, connect);
personCmd.Parameters.AddWithValue("@LastName", c.LastName);
personCmd.Parameters.AddWithValue("@FirstName", c.FirstName);
personCmd.Parameters.AddWithValue("@Email", c.Email);
personCmd.Parameters.AddWithValue("@Passcode", passcode);
personCmd.Parameters.AddWithValue("@Password", c.PlainPassword);
personCmd.Parameters.AddWithValue("@hashedPass", ph.HashIt(c.PlainPassword, passcode.ToString()));
connect.Open();
personCmd.ExecuteNonQuery();
connect.Close();
}
