public void cfy_daten_update (string signalquelle_id, string type, string kategorie, string cluster_id, string ort, int region, string plz,
string strasse, string hnr, string gestatt_name, string gestatt_vertragsnr, int objekt_id, int soll_we, int subscriber,
int subscriber_int, int subscriber_tel, string status, string cmts, string gps_langengrad, string gps_breitengrad,
string signallieferant)
{
string query = "UPDATE " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " SET " +
"signalquelle_id='" + signalquelle_id + "'," +
"type ='" + type + "'," +
"kategorie ='" + kategorie + "'," +
"cluster_id ='" + cluster_id + "'," +
"ort ='" + ort + "'," +
"region =" + region + "," +
"plz ='" + plz + "'," +
"strasse='" + strasse + "'," +
"hnr='" + hnr + "'," +
"gestatt_name='" + gestatt_name + "'," +
"gestatt_vertragsnr='" + gestatt_vertragsnr + "'," +
"objekt_id=" + objekt_id + "," +
"soll_we=" + soll_we + "," +
"subscriber=" + subscriber + "," +
"subscriber_int=" + subscriber_int + "," +
"subscriber_tel=" + subscriber_tel + "," +
"status='" + status + "'," +
"cmts='" + cmts + "'," +
"gps_langengrad='" + gps_langengrad + "'," +
"gps_breitengrad='" + gps_breitengrad + "'," +
"signallieferant='" + signallieferant + "'" +
" WHERE objekt_id = " + objekt_id + ";";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_daten_insert (string signalquelle_id, string type, string kategorie, string cluster_id, string ort, int region, string plz,
string strasse, string hnr, string gestatt_name, string gestatt_vertragsnr, int objekt_id, int soll_we, int subscriber,
int subscriber_int, int subscriber_tel, string status, string cmts, string gps_langengrad, string gps_breitengrad,
string signallieferant)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"signalquelle_id," +
"type," +
"kategorie," +
"cluster_id," +
"ort," +
"region," +
"plz," +
"strasse," +
"hnr," +
"gestatt_name," +
"gestatt_vertragsnr," +
"objekt_id," +
"soll_we," +
"subscriber," +
"subscriber_int," +
"subscriber_tel," +
"status," +
"cmts," +
"gps_langengrad," +
"gps_breitengrad," +
"signallieferant) " +
"VALUES ('" +
signalquelle_id + "','" +
type + "','" +
kategorie + "','" +
cluster_id + "','" +
ort + "','" +
region + "','" +
plz + "','" +
strasse + "','" +
hnr + "','" +
gestatt_name + "','" +
gestatt_vertragsnr + "','" +
objekt_id + "','" +
soll_we + "','" +
subscriber + "','" +
subscriber_int + "','" +
subscriber_tel + "','" +
status + "','" +
cmts + "','" +
gps_langengrad + "','" +
gps_breitengrad + "','" +
signallieferant + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_gestattungsgeber_name (string name, byte status)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"name," +
"status)" +
"VALUES ('+" +
name + "','" +
status + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_cluster (string cluster_id, byte status)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"cluster_id," +
"status)" +
"VALUES ('+" +
cluster_id + "','" +
status + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_gps (string langengrad, string breitengrad, byte status)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"langengrad," +
"breitengrad," +
"status) " +
"VALUES ('+" +
langengrad + "','" +
breitengrad + "','" +
status + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_erstellt (string tabelle, int tabelle_id, int objekt_id, int unix_zeitpunkt)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"tabelle," +
"tabelle_id," +
"objekt_id, " +
"unix_zeitpunkt," +
"VALUES ('+" +
tabelle + "','" +
tabelle_id + "','" +
objekt_id + "','" +
unix_zeitpunkt + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}
public void cfy_kunden (int soll_we, int subscriber, int internet, int telefon, byte status, int objekt_id)
{
string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
"soll_we," +
"subscriber," +
"internet," +
"telefon," +
"status," +
"objekt_id) " +
"VALUES ('+" +
soll_we + "','" +
subscriber + "','" +
internet + "','" +
telefon + "','" +
status + "','" +
objekt_id + "');";
MySQLQueries execute = new MySQLQueries ();
execute.ExecuteInsertQuery (query);
}