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