private void PrepareCommand(SqlCommand command, Neschopenka neschopenka) { command.Parameters.AddWithValue("@id_neschopenka", neschopenka.RecordId); command.Parameters.AddWithValue("@text", neschopenka.Text); command.Parameters.AddWithValue("@datum", neschopenka.Datum); command.Parameters.AddWithValue("@nepritomnost", neschopenka.Nepritomnost); }
private Collection <T> Read(SqlDataReader reader, bool withItemsCount = false) { Collection <T> neschopenkas = new Collection <T>(); while (reader.Read()) { Neschopenka neschopenka = new Neschopenka(); int i = -1; neschopenka.RecordId = reader.GetInt32(++i); neschopenka.Datum = reader.GetDateTime(++i); neschopenka.Nepritomnost = reader.GetInt32(++i); neschopenka.Text = reader.GetString(++i); neschopenkas.Add((T)neschopenka); } return(neschopenkas); }