public List<EventType> SelectEventTypesForAccounting() { const string q = @"SELECT id, event_type, description FROM dbo.EventTypes WHERE accounting = 1 ORDER BY sort_order"; List<EventType> list = new List<EventType>(); using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) using (OpenCbsReader r = c.ExecuteReader()) { if (r.Empty) return list; while (r.Read()) { EventType et = new EventType { Id = r.GetInt("id"), Description = r.GetString("description"), EventCode = r.GetString("event_type") }; list.Add(et); } return list; } }
public EventType SelectEventTypeByEventType(string eventType) { const string q = @"SELECT id, event_type, description FROM EventTypes WHERE event_type = @event_type"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { c.AddParam("@event_type", eventType); using (OpenCbsReader r = c.ExecuteReader()) { if (r == null || r.Empty) return new EventType(); EventType evntType = new EventType(); while (r.Read()) { evntType = new EventType { Id = r.GetInt("id"), Description = r.GetString("description"), EventCode = r.GetString("event_type") }; } return evntType; } } }