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