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