public void besucherRegister(string register_info, string retaurant_id)
{
ip = HttpContext.Current.Request.UserHostAddress.ToString();
DataSet2TableAdapters.Ip_registerTableAdapter ip_reg = new DataSet2TableAdapters.Ip_registerTableAdapter();
string jahr = DateTime.Now.Year.ToString();
string monat = DateTime.Now.Month.ToString();
string datum = DateTime.Now.Day.ToString();
string Zeit = DateTime.Now.TimeOfDay.ToString();
//string MIn = DateTime.Now.Minute.ToString();
string Zeit2 = datum + "/" + monat + "/" + jahr + " " + Zeit;
register_info += "@Enter time:" + "enter_time";//enter_time sollte in pageload zusammengestellt werden (sep 2016)
//register_info += "@Exit time:" + Zeit2;
//ip_reg.InsertQueryAll(retaurant_id, register_info, ip);
}
public string besucherRegister(string register_info, string retaurant_id)
{
string antwort = "";
ip = HttpContext.Current.Request.UserHostAddress.ToString();
DataSet2TableAdapters.Ip_registerTableAdapter ip_reg = new DataSet2TableAdapters.Ip_registerTableAdapter();
string jahr = DateTime.Now.Year.ToString();
string monat = DateTime.Now.Month.ToString();
string datum = DateTime.Now.Day.ToString();
string Zeit = DateTime.Now.TimeOfDay.ToString();
//string MIn = DateTime.Now.Minute.ToString();
string Zeit2 = datum + "/" + monat + "/" + jahr + " " + Zeit;
register_info += "@Enter time:" + "enter_time";//enter_time sollte in pageload zusammengestellt werden (sep 2016)
//register_info += "@Exit time:" + Zeit2;
DataSet2TableAdapters.Kunden1TableAdapter ta_k1 = new DataSet2TableAdapters.Kunden1TableAdapter();
try
{
//ip_reg.InsertQueryAll(retaurant_id, register_info, ip);
//ip_reg.InsertQueryAll(register_info, retaurant_id);
//antwort += ip_reg.GetData()[0]["text"].ToString() + "\n";
antwort += "emali(" + ta_k1.GetDataById(101)[0]["javad"].ToString() + ")\n";
antwort += "emali Erfolgreich \n\n\n";
}
catch (Exception exception)
{
antwort += "email Gescheitert \n\n\n";
antwort += exception + "\n\n\n";
};
try
{
//ip_reg.InsertQueryAll(retaurant_id, register_info, ip);
//ip_reg.UpdateQuery_test1("IP_all");
antwort += "101-telefon(" + ta_k1.GetDataById(101)[0]["datum"].ToString() + ")\n"; // ASC
antwort += "28-telefon(" + ta_k1.GetDataById(28)[0]["datum"].ToString() + ")\n"; // ASC
antwort += "39-telefon(" + ta_k1.GetDataById(39)[0]["datum"].ToString() + ")\n"; // ASC
antwort += "43-telefon(" + ta_k1.GetDataById(43)[0]["telefon"].ToString() + ")\n"; // ASC
antwort += "8-telefon(" + ta_k1.GetDataById(8)[0]["telefon"].ToString() + ")\n"; // ASC
antwort += "pwort(" + ta_k1.GetDataById(101)[0]["pwort"].ToString() + ")\n"; //pwort ASC
antwort += "datum2(" + ta_k1.GetDataById(101)[0]["datum2"].ToString() + ")\n"; //pwort ASC
antwort += "222222 Erfolgreich \n";
}
catch (Exception exception)
{
antwort += "222222 Update Gescheitert \n\n\n";
antwort += exception + "\n\n\n";
};
try
{
antwort += ta_k1.GetDataBy_id2_test(101)[0]["telefon"].ToString();
antwort += "3333333 Erfolgreich \n\n\n";
}
catch (Exception exception)
{
antwort += "33333333 insert Gescheitert \n";
antwort += exception + "\n\n\n";
};
try
{
ip_reg.UpdateQuery_test3("pappapa", "kakaka");// .InsertQuery_para_convert("ip", "text", "ip2");
antwort += "444444444 Erfolgreich \n";
}
catch (Exception exception)
{
antwort += "444444444 insert Gescheitert \n";
antwort += exception + "\n\n\n";
};
return(antwort);
}