private void ExecuteFetch(SQLiteConnection cn, object criteria)
{
using (SQLiteCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT * FROM Racuni";
if (criteria != null)
{
cm.CommandText += " WHERE " + criteria;
}
using (Helpers.SafeDataReader dr = new Helpers.SafeDataReader(cm.ExecuteReader()))
{
InnerList.Clear();
while (dr.Read())
{
Prihodi item = new Prihodi();
item.GetDataReader(dr);
InnerList.Add(item);
item.PropertyChanged += new PropertyChangedEventHandler(List_PropertyChanged);
}
dr.NextResult();
}
}
}
private void ExecuteFetch(SQLiteConnection cn, object criteria)
{
using (SQLiteCommand cm = cn.CreateCommand())
{
cm.CommandText = String.Format("SELECT * FROM Racuni WHERE Id={0}", (int)criteria);
cm.CommandType = CommandType.Text;
using (Helpers.SafeDataReader dr = new Helpers.SafeDataReader(cm.ExecuteReader()))
{
while (dr.Read())
{
GetDataReader(dr);
}
}
}
}
