public int SumaKompletiranih() { using (IDbConnection connection = new System.Data.SQLite.SQLiteConnection(GlobalConfig.CnnString())) { string query = @"select count() From Narudzbenice where Id !="""" AND BrojNarudzbenice !="""" AND DatumNarudzbenice !="""" AND DatumIstekaRokaNarudzbenice !="""" AND OkvirniSporazum !="""" AND Ogranak !="""" AND NazivTrafostanice !="""" AND DatumFakture !="""" AND BrojFakture !="""" AND IznosBezPDV !="""" AND DatumPrijemEPS !="""" AND BrojIzvestaja !="""" AND IzvestajPoslat = 1 AND NarudzbenicaPDF !="""" AND ZapsinikOIzvrsenjuUslugaPDF !="""" AND FakturaPDF !="""" AND PrimopredajniObrazacPDF !="""" AND Korisnik !="""" AND Datum != """";"; //return connection.QuerySingle<int>(query, new { ID = id }); return(connection.ExecuteScalar <int>(query)); } }
public int UkupanBrojUnosaZaKorisnika(string korisnik) { using (IDbConnection connection = new System.Data.SQLite.SQLiteConnection(GlobalConfig.CnnString())) { string query = "select count() from Narudzbenice where Korisnik = '" + korisnik + "';"; //return connection.QuerySingle<int>(query, new { ID = id }); return(connection.ExecuteScalar <int>(query)); } }
/// <summary> /// Parametar nam sluzi da bi birali izmedju poslatih i neposlatih izvestaja /// </summary> /// <param name="i"> 0 ili 1 </param> /// <returns></returns> public int SumaIzvestajPosla(int i) { using (IDbConnection connection = new System.Data.SQLite.SQLiteConnection(GlobalConfig.CnnString())) { string query = "select count() from Narudzbenice where IzvestajPoslat = " + i + ";"; //return connection.QuerySingle<int>(query, new { ID = id }); return(connection.ExecuteScalar <int>(query)); } }
public int UkupanBorjUNosaOvogMeseca(string mesec) { using (IDbConnection connection = new System.Data.SQLite.SQLiteConnection(GlobalConfig.CnnString())) { string query = "SELECT count() FROM Narudzbenice WHERE strftime('%Y %m', Datum) = '" + DateTime.Now.Year.ToString() + " " + mesec + "'"; try { return(connection.ExecuteScalar <int>(query)); } catch (Exception ex) { MessageBox.Show("Doslo je do greske, detaljne informaciju su: " + ex, "Greska sa bazom!", MessageBoxButtons.OK, MessageBoxIcon.Error); return(0); } } }