public Boolean UpdateIteration(IterationDTO iterationDTO) { var result = true; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new IterationCommandFactory(); using (var command = cmd.UpdateIteration(connection)) { command.Parameters["@Comment"].Value = iterationDTO.Comment; command.Parameters["@CreateBy"].Value = iterationDTO.CreateBy; command.Parameters["@CreateDate"].Value = iterationDTO.CreateDate; command.Parameters["@Description"].Value = iterationDTO.Description; command.Parameters["@EndDate"].Value = iterationDTO.EndDate; command.Parameters["@IterationId"].Value = iterationDTO.IterationId; command.Parameters["@ModBy"].Value = iterationDTO.ModBy; command.Parameters["@ModDate"].Value = iterationDTO.ModDate; command.Parameters["@PhaseId"].Value = iterationDTO.PhaseId; command.Parameters["@StartDate"].Value = iterationDTO.StartDate; try { command.ExecuteNonQuery(); } catch (Exception exception) { result = false; } finally { } } } return(result); }
public Boolean DeleteIteration(int iterationId) { var rowsAffected = 0; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var transaction = connection.BeginTransaction(); try { var cmd = new IterationCommandFactory(); using (var command = cmd.DeleteIteration(connection)) { command.Parameters["@IterationId"].Value = iterationId; command.ExecuteNonQuery(); rowsAffected = (int)command.Parameters["@rowsAffected"].Value; } transaction.Commit(); } catch (Exception exception) { transaction.Rollback(); } finally { transaction = null; } } return(rowsAffected > 0); }
public List <IterationDTO> GetIteration(int iterationIdToLookup) { var items = new List <IterationDTO>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new IterationCommandFactory(); using (var command = cmd.GetIteration(connection)) { command.Parameters["@IterationId"].Value = iterationIdToLookup; using (var reader = command.ExecuteReader()) { try { while (reader.Read()) { var comment = (String)(reader["Comment"]); var createBy = (String)(reader["Create_By"]); var createDate = (DateTime)(reader["Create_Date"]); var description = (String)(reader["Description"]); var endDate = (DateTime)(reader["End_Date"]); var iterationId = (int)(reader["Iteration_Id"]); var modBy = (String)(reader["Mod_By"]); var modDate = (DateTime)(reader["Mod_Date"]); var phaseId = (int)(reader["Phase_Id"]); var startDate = (DateTime)(reader["Start_Date"]); var microIterations = new List <Micro_IterationDTO>(); items.Add(new IterationDTO(comment, createBy, createDate, description, endDate, iterationId, microIterations, modBy, modDate, phaseId, startDate)); } } finally { reader.Close(); } } } } return(items); }