public getCustomerCountResponse getCustomerCount(getCustomerCountRequest request)
{
getCustomerCountResponse res = new getCustomerCountResponse();
Int32 anzahlAdressen;
anzahlAdressen = 0;
try
{
using (DBConnect myConnect = new DBConnect())
{
String sqlCommand;
sqlCommand = "SELECT count(kontonr)";
sqlCommand += " FROM bungert.adresse";
sqlCommand += " WHERE adresse.aktiv = 1";
OdbcCommand cmd = new OdbcCommand(sqlCommand, myConnect.conn);
myConnect.Connect();
OdbcDataReader reader;
//DataReader Objekt wird initialisiert
using (reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
anzahlAdressen = reader.GetInt32(0);
}
reader.Close();
}
}
res.@return = anzahlAdressen;
}
catch (System.Exception ex)
{
Trace.WriteLine(DateTime.Now.ToString() + " - " + ex.Message, "SmitService");
res.@return = -1;
}
//Test Anzahl Adressen auf 1 beschränkt US 16.01.2014
//res.@return = 1;
return res;
}
public getCustomerCountResponse getChangedCustomerCount(getCustomerCountRequest request)
{
getCustomerCountResponse res = new getCustomerCountResponse();
Int32 anzahlAdressen;
anzahlAdressen = 0;
SmitConfig sc = new SmitConfig();
sc = ReadXML();
using (DBConnect myConnect = new DBConnect())
{
String sqlCommand;
sqlCommand = "SELECT count(kontonr)";
sqlCommand += " FROM bungert.adresse a LEFT OUTER JOIN bungert.marketingkontakt b";
sqlCommand += " ON a.adressid = b.adressid WHERE a.aktiv = 1";
sqlCommand += " AND (a.modifieddate >= '" + sc.changedCustomerDate + "' OR b.modifieddate >= '" + sc.changedCustomerDate + "')";
OdbcCommand cmd = new OdbcCommand(sqlCommand, myConnect.conn);
myConnect.Connect();
OdbcDataReader reader;
//DataReader Objekt wird initialisiert
using (reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
anzahlAdressen = reader.GetInt32(0);
}
reader.Close();
}
}
res.@return = anzahlAdressen;
//Test Anzahl Adressen auf 1 beschränkt US 16.01.2014
//res.@return = 1;
return res;
}
