You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

104 lines
3.2 KiB

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<string, object> keyVals = e.Arguments["data"] as Dictionary<string, object>;
int id_athlete = 0;
int teilnehemernr = 0;
string license = "";
string base_lizenz = "";
foreach (KeyValuePair<string, object> 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);
}
}
}
}
}