public void Create(Task task)
{
var performerDb = new PerformerDb().GetAllPerformers();
if (performerDb != null)
{
var sql = string.Format("INSERT INTO Tasks " +
"(Title, WorkLoad, StartDate, EndDate, Status, Performer) " +
"VALUES(@Title, @WorkLoad, @StartDate, @EndDate, @Status, @Performer)");
using (var connection = new SqlConnection())
{
connection.ConnectionString = ConnectionString;
connection.Open();
using (var command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@Title", task.Title);
command.Parameters.AddWithValue("@WorkLoad", task.WorkLoad);
command.Parameters.AddWithValue("@StartDate", task.StartDate);
command.Parameters.AddWithValue("@EndDate", task.EndDate);
command.Parameters.AddWithValue("@Status", task.Status);
command.Parameters.AddWithValue("@Performer", task.Performer);
command.ExecuteNonQuery();
}
connection.Close();
}
}
}
public IEnumerable<Task> GetAllTasks()
{
var allTasks = new List<Task>();
using (var connection = new SqlConnection())
{
connection.ConnectionString = ConnectionString;
connection.Open();
const string strSql = "SELECT * FROM Tasks";
var command = new SqlCommand(strSql, connection);
var dataReader = command.ExecuteReader(CommandBehavior.CloseConnection);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
var task = new Task()
{
Id = dataReader.GetInt32(0),
Title = dataReader.GetString(1),
WorkLoad = dataReader.GetInt32(2),
StartDate = dataReader.GetDateTime(3),
EndDate = dataReader.GetDateTime(4),
Status = dataReader.GetString(5),
Performer = dataReader.GetInt32(6)
};
allTasks.Add(task);
}
}
else
{
connection.Close();
return null;
}
connection.Close();
}
return allTasks;
}
public void Update(Task task)
{
var sql = "UPDATE Tasks SET Title = @Title, WorkLoad = @WorkLoad, StartDate = @StartDate, " +
"EndDate = @EndDate, Status = @Status, Performer = @Performer WHERE Id = @id";
using (var connection = new SqlConnection())
{
connection.ConnectionString = ConnectionString;
connection.Open();
using (var command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@Title", task.Title);
command.Parameters.AddWithValue("@WorkLoad", task.WorkLoad);
command.Parameters.AddWithValue("@StartDate", task.StartDate);
command.Parameters.AddWithValue("@EndDate", task.EndDate);
command.Parameters.AddWithValue("@Status", task.Status);
command.Parameters.AddWithValue("@Performer", task.Performer);
command.Parameters.AddWithValue("@id", task.Id);
command.ExecuteNonQuery();
}
connection.Close();
}
}
