using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace QW2021C.Administration { public partial class MergeAthlethen : System.Web.UI.Page { Helper.Log log = new Helper.Log(); protected void Page_Load(object sender, EventArgs e) { { try { if (Session["LoggedIn"].ToString() == "False") { Response.Redirect("~/default.aspx"); return; } } catch { Response.Redirect("~/default.aspx"); return; } SqlDataSource1.SelectParameters["fnkt"].DefaultValue = "0"; if (Session["Admin"] == "True") { SqlDataSource1.SelectParameters["verein"].DefaultValue = "ALL"; } else { SqlDataSource1.SelectParameters["verein"].DefaultValue = Session["Username"].ToString(); } //Grid1.DataBind(); //SqlDataSource1.DataBind(); } //sqldatasource1.selectparameters("UserID").DefaultValue = "whatever you want" } protected void Grid1_ServerCommandButtonClick(object sender, Syncfusion.JavaScript.Web.GridEventArgs e) { Dictionary keyVals = e.Arguments["data"] as Dictionary; int id_athlete = 0; int teilnehemernr = 0; string license = ""; string base_lizenz = ""; foreach (KeyValuePair keyval in keyVals) { if (keyval.Key == "id_athlete") { id_athlete = Convert.ToInt32(keyval.Value); } if (keyval.Key == "Teilnehmernr") { teilnehemernr = Convert.ToInt32(keyval.Value); } if (keyval.Key == "license") { license = keyval.Value.ToString(); } if (keyval.Key == "license") { license = keyval.Value.ToString(); } if (keyval.Key== "base_lizenz") { base_lizenz = keyval.Value.ToString(); } } if (teilnehemernr != 0 && id_athlete != 0 && license != "") { clsDB db = new clsDB(); if (base_lizenz != "") { license = ""; } db.merge_athlete(id_athlete, teilnehemernr, license); if (license !="") { log.insert_entry(1, Convert.ToInt32(Session["UserID"]), "Lizenzenn zusammengeführt:" + teilnehemernr+" / "+license); } else { log.insert_entry(1, Convert.ToInt32(Session["UserID"]), "Lizenzenn Zusaemmenführung aufgehoben:" + teilnehemernr + " / " + license); } } } } }