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; }
    }
}