public static long CreateCustomerRecord()
{
IInsertQueryBuilder builder = DatabaseInsert.Into(CustomerTable.TableName)
.AddValue(CustomerTable.FirstName, string.Empty)
.AddValue(CustomerTable.LastName, string.Empty)
.AddValue(CustomerTable.Phone, string.Empty)
.AddValue(CustomerTable.City, string.Empty);
return(Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(builder.Build( )));
}
public static void AddBoatsFor(long customerId)
{
IInsertQueryBuilder builder = DatabaseInsert.Into(BoatTable.TableName)
.AddValue(BoatTable.RegistrationNumber, string.Empty)
.AddValue(BoatTable.Manufacturer, string.Empty)
.AddValue(BoatTable.ModelYear, string.Empty)
.AddValue(BoatTable.Length, string.Empty)
.AddValue(BoatTable.CustomerID, customerId.ToString( ));
Resolve.DependencyFor <IDatabaseGateway>( ).Execute(builder.Build( ), builder.Build( ), builder.Build( ));
}
public static long CreateCustomerRecordWith(string username)
{
IInsertQueryBuilder builder = DatabaseInsert.Into(CustomerTable.TableName)
.AddValue(CustomerTable.FirstName, string.Empty)
.AddValue(CustomerTable.LastName, string.Empty)
.AddValue(CustomerTable.Phone, string.Empty)
.AddValue(CustomerTable.City, string.Empty);
long customerId = Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(builder.Build( ));
IQuery insertToAuthTable = DatabaseInsert.Into(AuthorizationTable.TableName)
.AddValue(AuthorizationTable.UserName, username)
.AddValue(AuthorizationTable.Password, string.Empty)
.Build( );
Resolve.DependencyFor <IDatabaseGateway>( ).Execute(insertToAuthTable);
return(customerId);
}
