public async Task <PostPig.DataAccess.Florp.Task> Update(PostPig.DataAccess.Florp.Task task)
{
using (var connection = new NpgsqlConnection(connectionString))
{
return(task);
}
}
public async Task <PostPig.DataAccess.Florp.Task> Create(PostPig.DataAccess.Florp.Task task)
{
using (var connection = new NpgsqlConnection(connectionString))
{
var command = new NpgsqlCommand(@"INSERT INTO public.task(id, name, description, created, user_id)
VALUES (@id, @name, @description, @created, @userId)
RETURNING id, name, description, created, user_id;", connection);
command.Parameters.AddWithValue("id", task.Id);
command.Parameters.AddWithValue("name", task.Name);
command.Parameters.AddWithValue("description", task.Description);
command.Parameters.AddWithValue("created", task.Created);
command.Parameters.AddWithValue("userId", task.UserId);
using (var reader = await command.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
return(GetCurrent(reader));
}
}
return(null);
}
}
public async Task <PostPig.DataAccess.Florp.Task> Create(PostPig.DataAccess.Florp.Task task)
{
using (var connection = new NpgsqlConnection(connectionString))
{
var command = new NpgsqlCommand(@"INSERT INTO public.task(id)
VALUES(DEFAULT)
RETURNING id;", connection);
using (var reader = await command.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
return(GetCurrent(reader));
}
}
return(null);
}
}
