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();
}
}
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("Id");
UslugaIliProizvod = dr.GetString("UslugaIliProizvod");
JedinicaMjere = dr.GetString("JedinicaMjere");
Kolicina = dr.GetInt32("Kolicina");
Cijena = dr.GetDouble("Cijena");
Iznos = dr.GetDouble("Iznos");
Rabat = dr.GetInt32("Rabat");
RacunId = dr.GetInt32("RacunId");
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("Id");
NazivObrta = dr.GetString("NazivObrta");
Vlasnik = dr.GetString("Vlasnik");
Adresa = dr.GetString("Adresa");
Oib = dr.GetString("Oib");
Iban = dr.GetString("Iban");
Banka = dr.GetString("Banka");
Djelatnost = dr.GetString("Djelatnost");
Logo = (byte[])dr["Logo"];
}
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);
}
}
}
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("Id");
KupacNaziv = dr.GetString("KupacNaziv");
Adresa = dr.GetString("Adresa");
Mjesto = dr.GetString("Mjesto");
OibKupca = dr.GetString("OibKupca");
NadnevakIzdavanjaRacuna = dr.GetDateTime("NadnevakIzdavanjaRacuna").ToString("dd-MM-yyyy");
DatumPredvideneIsporuke = dr.GetDateTime("DatumPredvideneIsporuke");
VrijemeIzrade = dr.GetDateTime("VrijemeIzrade");
DospijecePlacanja = dr.GetDateTime("DospijecePlacanja");
Napomena = dr.GetString("Napomena");
IznosNaplacenGotovinom = dr.GetDecimal("IznosNaplacenGotovinom");
IznosNaplacenVirmanski = dr.GetDecimal("IznosNaplacenVirmanski");
BrojIzvodaUplatnice = dr.GetInt32("BrojIzvodaUplatnice");
NadnevakDatumUplate = dr.GetDateTime("NadnevakDatumUplate");
Ukupno = IznosNaplacenGotovinom + IznosNaplacenVirmanski;
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("Id");
Naziv = dr.GetString("Naziv");
Napomena = dr.GetString("Napomena");
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("ROWID");
Username = dr.GetString("Username");
Password = dr.GetString("Password");
}
public void GetDataReader(Helpers.SafeDataReader dr)
{
Id = dr.GetInt32("Id");
Naziv = dr.GetString("Naziv");
Kategorija = dr.GetString("Kategorija");
}
