public Boolean UpdateMicro_Iteration(Micro_IterationDTO micro_IterationDTO) { var result = true; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new Micro_IterationCommandFactory(); using (var command = cmd.UpdateMicro_Iteration(connection)) { command.Parameters["@CreateBy"].Value = micro_IterationDTO.CreateBy; command.Parameters["@CreateDate"].Value = micro_IterationDTO.CreateDate; command.Parameters["@EndDate"].Value = micro_IterationDTO.EndDate; command.Parameters["@IterationId"].Value = micro_IterationDTO.IterationId; command.Parameters["@MicroIterationId"].Value = micro_IterationDTO.MicroIterationId; command.Parameters["@MicroIterationTypeCode"].Value = micro_IterationDTO.MicroIterationTypeCode; command.Parameters["@ModBy"].Value = micro_IterationDTO.ModBy; command.Parameters["@ModDate"].Value = micro_IterationDTO.ModDate; command.Parameters["@StartDate"].Value = micro_IterationDTO.StartDate; try { command.ExecuteNonQuery(); } catch (Exception exception) { result = false; } finally { } } } return(result); }
public Boolean DeleteMicro_Iteration(int micro_IterationId) { var rowsAffected = 0; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var transaction = connection.BeginTransaction(); try { var cmd = new Micro_IterationCommandFactory(); using (var command = cmd.DeleteMicro_Iteration(connection)) { command.Parameters["@Micro_IterationId"].Value = micro_IterationId; command.ExecuteNonQuery(); rowsAffected = (int)command.Parameters["@rowsAffected"].Value; } transaction.Commit(); } catch (Exception exception) { transaction.Rollback(); } finally { transaction = null; } } return(rowsAffected > 0); }
public List <Micro_IterationDTO> GetMicro_Iteration(int micro_IterationIdToLookup) { var items = new List <Micro_IterationDTO>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var cmd = new Micro_IterationCommandFactory(); using (var command = cmd.GetMicro_Iteration(connection)) { command.Parameters["@Micro_IterationId"].Value = micro_IterationIdToLookup; using (var reader = command.ExecuteReader()) { try { while (reader.Read()) { var activities = new List <ActivityDTO>(); 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 iterationId = (int)(reader["Iteration_Id"]); var microIterationId = (int)(reader["Micro_Iteration_Id"]); var microIterationTypeCode = (String)(reader["Micro_Iteration_Type_Code"]); var modBy = (String)(reader["Mod_By"]); var modDate = (DateTime)(reader["Mod_Date"]); var startDate = (DateTime?)(reader["Start_Date"] == DBNull.Value ? null : reader["Start_Date"]); items.Add(new Micro_IterationDTO(activities, createBy, createDate, endDate, iterationId, microIterationId, microIterationTypeCode, modBy, modDate, startDate)); } } finally { reader.Close(); } } } } return(items); }