private IssueViewModel ReadIssueFromSQL(SQLiteDataReader reader) { var issue = new IssueViewModel(); issue.IssueID = Convert.ToInt32(reader[0]); issue.Description = reader[1].ToString(); issue.UserCreated = reader[2].ToString(); issue.UserClosed = reader[3].ToString(); issue.DateCreated = ConvertToNullableDateTime(reader[4]); issue.DateClosed = ConvertToNullableDateTime(reader[5]); issue.PlantContact = reader[6].ToString(); issue.IssueType = Convert.ToInt32(reader[7]); issue.IssueState = Convert.ToInt32(reader[8]); issue.IssueResolution = Convert.ToInt32(reader[9]); issue.Priority = Convert.ToInt32(reader[10]); issue.Severity = Convert.ToInt32(reader[11]); return issue; }
IssueViewModel IDataAccess.GetIssue(int id) { using (conn = new SQLiteConnection(connectionString)) { conn.Open(); var issue = new IssueViewModel(); var reader = new SQLiteCommand(SQLFixedQueries.SelectIssue(id), conn) .ExecuteReader(); while (reader.Read()) issue = ReadIssueFromSQL(reader); return issue; } }