コード例 #1
0
ファイル: mob.aspx.cs プロジェクト: alienpars/Billigerando
    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);
    }
コード例 #2
0
    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);
    }