public int getNumberOfTransactions(string _sOrganisationsNr, string _sSequenceType, string _sDatumAbrechnung = "NULL")
{
if (_sDatumAbrechnung == "NULL")
{
query = @"SELECT COUNT(*)
FROM dbo.Lastschriften
WHERE OrganisationsNr = " + "'" + _sOrganisationsNr + "' " + "and SequenceType = " + "'" + _sSequenceType + "' " + "and DatumAbrechnung is NULL";
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("OrganisationsNr", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_sOrganisationsNr);
sqlParameters[1] = new SqlParameter("SequenceType", SqlDbType.VarChar);
sqlParameters[1].Value = Convert.ToString(_sSequenceType);
return(conn.executeCountQuery(query, sqlParameters));
}
else
{
query = @"SELECT COUNT(*)
FROM dbo.Lastschriften
WHERE OrganisationsNr = " + "'" + _sOrganisationsNr + "' " + "and SequenceType = " + "'" + _sSequenceType + "' " + "and DatumAbrechnung = " + "'" + _sDatumAbrechnung + "' ";
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("OrganisationsNr", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_sOrganisationsNr);
sqlParameters[1] = new SqlParameter("SequenceType", SqlDbType.VarChar);
sqlParameters[1].Value = Convert.ToString(_sSequenceType);
sqlParameters[2] = new SqlParameter("DatumAbrechnung", SqlDbType.VarChar);
sqlParameters[2].Value = Convert.ToString(_sDatumAbrechnung);
return(conn.executeCountQuery(query, sqlParameters));
}
}
public int getNumberOfTransactions()
{
string query = @"SELECT COUNT(*) FROM DELL.Mitgliederverwaltung.dbo.DTA";
return(conn.executeCountQuery(query, null));
}
public int AnzahlOrganisationen()
{
string query = "select distinct count(Organisationen) from dbo.Organisationen";
return(conn.executeCountQuery(query, null));
}
