[AjaxPro.AjaxMethod()] //wird benutzt von jabascript public string update_kunden_adresse(string daten, string rh_kundenId) //07,12,13 { string antwort = "C101 Update erfolgreich"; DataSet2TableAdapters.Kunden1TableAdapter ta_k1 = new DataSet2TableAdapters.Kunden1TableAdapter(); try { ta_k1.UpdateQueryDaten(daten, int.Parse(rh_kundenId)); } catch { antwort = "C108 Update Gescheitert"; }; return(antwort); }
[AjaxPro.AjaxMethod()] //wird benutzt von jabascript public void update_kunden_adresse(string daten, string rh_kundenId) //07,12,13 { DataSet2TableAdapters.Kunden1TableAdapter ta_k1 = new DataSet2TableAdapters.Kunden1TableAdapter(); ta_k1.UpdateQueryDaten(daten, int.Parse(rh_kundenId)); }
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); }