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.
77 lines
2.8 KiB
77 lines
2.8 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using Syncfusion.JavaScript.Web;
|
|
|
|
namespace QW2021C.Resultate
|
|
{
|
|
public partial class Check_Duplicata : System.Web.UI.Page
|
|
{
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
if (!Page.IsPostBack)
|
|
{
|
|
}
|
|
}
|
|
public void OnClick(object sender, GridEventArgs e)
|
|
{
|
|
string nachname="";
|
|
string vorname="";
|
|
string jahrgang = "";
|
|
string kategorie = "";
|
|
string verein = "";
|
|
string lizenz1 = "";
|
|
string lizenz2 = "";
|
|
|
|
switch (e.Arguments["commandType"].ToString())
|
|
{
|
|
case "UpdateBtn":
|
|
|
|
Dictionary<string, object> keyVals = e.Arguments["data"] as Dictionary<string, object>;
|
|
|
|
foreach (KeyValuePair<string, object> keyval1 in keyVals)
|
|
{
|
|
if (keyval1.Key == "Nachname") nachname = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Vorname") vorname = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Jahrgang") jahrgang = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Kategorie") kategorie = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Verein") verein = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Lizenz1") lizenz1 = keyval1.Value.ToString();
|
|
if (keyval1.Key == "Lizenz2") lizenz2 = keyval1.Value.ToString();
|
|
}
|
|
clsDB db = new clsDB();
|
|
string sql = "";
|
|
sql = "Update res_resultate set lizenz='" + lizenz2 + "' where lizenz='" + lizenz1 + "' and nachname='" + nachname + "'";
|
|
sql = sql + " and vorname='" + vorname + "' and verein='" + verein + "' and jahrgang='" + jahrgang + "' and kategorie='" + kategorie + "'";
|
|
|
|
db.Get_Tabledata(sql, false, true);
|
|
this.Diszplingrid.DataBind();
|
|
break;
|
|
case "SelectW2":
|
|
break;
|
|
case "SelectW3":
|
|
break;
|
|
case "SelectW4":
|
|
break;
|
|
default:
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
public class athlete {
|
|
public string nachname { get; set; }
|
|
public string vorname { get; set; }
|
|
public string jahrgang { get; set; }
|
|
public string kategorie { get; set; }
|
|
public string verein { get; set; }
|
|
public string lizenz1 { get; set; }
|
|
public string lizenz2 { get; set; }
|
|
}
|
|
}
|
|
|
|
|