public Boolean UpdatePhase(PhaseDTO phaseDTO) { var result = true; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new PhaseCommandFactory(); using (var command = cmd.UpdatePhase(connection)) { command.Parameters["@CreateBy"].Value = phaseDTO.CreateBy; command.Parameters["@CreateDate"].Value = phaseDTO.CreateDate; command.Parameters["@EndDate"].Value = phaseDTO.EndDate; command.Parameters["@EventId"].Value = phaseDTO.EventId; command.Parameters["@ModBy"].Value = phaseDTO.ModBy; command.Parameters["@ModDate"].Value = phaseDTO.ModDate; command.Parameters["@PhaseId"].Value = phaseDTO.PhaseId; command.Parameters["@PhaseName"].Value = phaseDTO.PhaseName; command.Parameters["@StartDate"].Value = phaseDTO.StartDate; try { command.ExecuteNonQuery(); } catch (Exception exception) { result = false; } finally { } } } return(result); }
public Boolean DeletePhase(int phaseId) { var rowsAffected = 0; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var transaction = connection.BeginTransaction(); try { var cmd = new PhaseCommandFactory(); using (var command = cmd.DeletePhase(connection)) { command.Parameters["@PhaseId"].Value = phaseId; command.ExecuteNonQuery(); rowsAffected = (int)command.Parameters["@rowsAffected"].Value; } transaction.Commit(); } catch (Exception exception) { transaction.Rollback(); } finally { transaction = null; } } return(rowsAffected > 0); }
public List <PhaseDTO> GetPhase(int phaseIdToLookup) { var items = new List <PhaseDTO>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new PhaseCommandFactory(); using (var command = cmd.GetPhase(connection)) { command.Parameters["@PhaseId"].Value = phaseIdToLookup; using (var reader = command.ExecuteReader()) { try { while (reader.Read()) { var createBy = (String)(reader["Create_By"]); var createDate = (DateTime)(reader["Create_Date"]); var endDate = (DateTime?)(reader["End_Date"] == DBNull.Value ? null : reader["End_Date"]); var eventId = (int)(reader["Event_Id"]); var modBy = (String)(reader["Mod_By"]); var modDate = (DateTime)(reader["Mod_Date"]); var phaseId = (int)(reader["Phase_Id"]); var phaseName = (String)(reader["Phase_Name"]); var startDate = (DateTime?)(reader["Start_Date"] == DBNull.Value ? null : reader["Start_Date"]); var phaseIterations = new List <IterationDTO>(); items.Add(new PhaseDTO(createBy, createDate, endDate, eventId, modBy, modDate, phaseId, phaseIterations, phaseName, startDate)); } } finally { reader.Close(); } } } } return(items); }