private Sprint GetFromReader(SqlCeDataReader reader) { var s = new Sprint { ID = Convert.ToInt32(reader.GetValue(0)), Name = reader.GetValue(1).ToString(), Date = Convert.ToDateTime(reader.GetValue(2)), NumberOfDevelopers = Convert.ToInt32(reader.GetValue(3)), Status = reader.GetValue(4).ToString() }; return(s); }
public Sprint GetById(int id) { var connection = Connection; try { var sql = $@" SELECT id, name, date, no_of_developers, status FROM sprint WHERE id = {id}"; var command = new SqlCeCommand(sql, connection); connection.Open(); var reader = command.ExecuteReader(); if (reader.Read()) { var s = new Sprint { ID = Convert.ToInt32(reader.GetValue(0)), Name = Convert.ToString(reader.GetValue(1)) }; return(s); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (connection.State != ConnectionState.Closed) { connection.Close(); } } return(null); }
public Ticket(string summary, string description, int estimation, string priority, string status, Sprint Id) { Summary = summary; Description = description; Estimation = estimation; Priority = priority; Status = status; Sprint = Id; }