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