internal static List <MediaItem> getItems(SqliteConnection conn, string where = "") { List <MediaItem> iList = new List <MediaItem>(); SqliteCommand cmd = new SqliteCommand( string.Format("select id, name, type, checked_to_patron_id, " + "checkout_date, due_date from mediaitem {0} order by name", where), conn); SqliteDataReader rdr = cmd.ExecuteReader(); while (rdr.NextResult()) { OurMediaItem i = new OurMediaItem(conn, rdr.GetInt32(0)); i.name = rdr.GetString(1); i.type = (MediaType)rdr.GetInt32(2); if (!rdr.IsDBNull(3)) { i.checked_to_patron_id = rdr.GetInt32(3); } if (!rdr.IsDBNull(4)) { i.checkout_date = DateTime.Parse(rdr.GetString(4)); } if (!rdr.IsDBNull(5)) { i.due_date = DateTime.Parse(rdr.GetString(5)); } iList.Add(i); } return(iList); }
public List <MediaItem> GetCheckedOutMedia(Patron p = null) { return(OurMediaItem.getCheckedOutItems(conn, p)); }
public List <MediaItem> GetMediaItems() { return(OurMediaItem.getItems(conn)); }
internal static List<MediaItem> getItems(SqliteConnection conn, string where = "") { List<MediaItem> iList = new List<MediaItem>(); SqliteCommand cmd = new SqliteCommand( string.Format("select id, name, type, checked_to_patron_id, " + "checkout_date, due_date from mediaitem {0} order by name", where), conn); SqliteDataReader rdr = cmd.ExecuteReader(); while (rdr.NextResult()) { OurMediaItem i = new OurMediaItem(conn, rdr.GetInt32(0)); i.name = rdr.GetString(1); i.type = (MediaType)rdr.GetInt32(2); if (!rdr.IsDBNull(3)) { i.checked_to_patron_id = rdr.GetInt32(3); } if (!rdr.IsDBNull(4)) { i.checkout_date = DateTime.Parse(rdr.GetString(4)); } if (!rdr.IsDBNull(5)) { i.due_date = DateTime.Parse(rdr.GetString(5)); } iList.Add(i); } return iList; }