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;
}
