Пример #1
0
 public async Task CreateUserAsync(Guid id, string username)
 {
     using (var connection = await GetOpenConnectionAsync())
         using (var command = new SqlCommand(InsertStatement, connection))
         {
             command.Parameters.AddWithValue("Id", id);
             command.Parameters.AddWithValue("Username", username);
             command.Parameters.AddWithValue("CreateUserId", Auditor.UserId);
             command.Parameters.AddWithValue("CreateDate", Auditor.Now());
             await command.ExecuteNonQueryAsync();
         }
 }
Пример #2
0
        public async Task <int> CreateBlogAsync(Guid id, string name)
        {
            using (var connection = await GetOpenConnectionAsync())
                using (var command = new SqlCommand(InsertStatement, connection))
                {
                    await connection.OpenAsync();

                    command.Parameters.AddWithValue("Id", id);
                    command.Parameters.AddWithValue("Name", name);
                    command.Parameters.AddWithValue("Creator", Auditor.UserId);
                    command.Parameters.AddWithValue("CreatedOn", Auditor.Now());

                    return((int)await command.ExecuteScalarAsync());
                }
        }