public virtual void Info()
{
Console.WriteLine("Код выдачи: {0} , Дата:\n", ID_Delivery, Data);
EmployeeDelivery.Info();
Reader1.Info();
Exemplar1.Info();
}
protected void button_Click(object sender, EventArgs e)
{
using (SqlConnection conexion = Conexion.ObtenerConexion())
{
conexion.Open();
string query = "select * from helix_usuario where NOMBRE_USUARIO ='" + txt_user.Text + "' and PASSWORD ='******'";
SqlCommand cmd = new SqlCommand(query, conexion);
SqlDataReader Reader1;
Reader1 = cmd.ExecuteReader();
if (Reader1.Read())
{
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Hola desde el grid');", true);
//getInt32 para obtener los valores numericos para comparacion y getValue para obtener el valor de la celda y no comparar
if (Reader1.GetInt32(1) == 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Bienvenido');", true);
perfil = Convert.ToString(Reader1.GetValue(1));
Response.Redirect("/View/Tickets.aspx", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Incorrecto');", true);
}
}
}
public int catchDB(DateTime date, string category)
{
string datedb = date.ToString("yyyy-MM-dd");
int result;
MySqlConnection con = null;
MySqlCommand command, command2;
con = new MySqlConnection(conectabanco);
command = new MySqlCommand("SELECT SUM(Tempo) FROM `concurso` WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con);
command2 = new MySqlCommand("SELECT count(DataRevisao) FROM concurso WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con);
con.Open();
MySqlDataReader Reader1, Reader2;
Reader2 = command2.ExecuteReader();
Reader2.Read();
string valid = Reader2.GetString(0);
Reader2.Close();
if (Convert.ToInt32(valid) > 0)
{
Reader1 = command.ExecuteReader();
Reader1.Read();
result = Convert.ToInt32(Reader1.GetString(0));
Reader1.Close();
return(result);
}
else
{
return(0);
}
}
private void Project_Advisor_Load(object sender, EventArgs e)
{
String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True";
String query = "select Id from Advisor";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader Reader;
con.Open();
Reader = cmd.ExecuteReader();
while (Reader.Read())
{
comboBox2.Items.Add(Reader.GetInt32(0));
}
String query1 = "select Title from Project";
SqlConnection con1 = new SqlConnection(str);
SqlCommand cmd1 = new SqlCommand(query1, con1);
SqlDataReader Reader1;
con1.Open();
Reader1 = cmd1.ExecuteReader();
while (Reader1.Read())
{
comboBox1.Items.Add(Reader1.GetString(0));
}
}
public (string, string, string, string, string) ConnectDataBase(string Data, int nextresult)
{
string name, path, cate, time, revision;
name = "0"; path = "0"; cate = "0"; time = "0";
try
{
con = new MySqlConnection(conectabanco);
command2 = new MySqlCommand("SELECT count(Data) FROM concurso where DataRevisao='" + Data + "'", con);
command = new MySqlCommand("SELECT * FROM concurso where DataRevisao='" + Data + "'", con);
con.Open();
MySqlDataReader Reader1, Reader2;
Reader2 = command2.ExecuteReader();
Reader2.Read();
string v = Reader2.GetString(0);
int tam = Convert.ToInt32(v);
string[] namestr, pathstr, catestr, timestr, revistr;
namestr = new string[tam];
pathstr = new string[tam];
catestr = new string[tam];
timestr = new string[tam];
revistr = new string[tam];
Reader2.Close();
Reader1 = command.ExecuteReader();
int valid = Convert.ToInt32(v) - nextresult;
if (Convert.ToInt32(valid) > 0)
{
while (Reader1.HasRows)
{
int aux = 0;
while (Reader1.Read())
{
namestr[aux] = Reader1.GetString(0);
pathstr[aux] = Reader1.GetString(1);
catestr[aux] = Reader1.GetString(2);
revistr[aux] = Reader1.GetString(5);
timestr[aux] = Reader1.GetString(6);
aux++;
}
Reader1.NextResult();
}
name = namestr[nextresult];
path = pathstr[nextresult];
cate = catestr[nextresult];
time = timestr[nextresult];
revision = revistr[nextresult];
}
else
{
name = "0"; path = "0"; cate = "0"; time = "0"; revision = "0";
}
}
catch (Exception erro)
{
name = "ERRO"; path = "ERRO"; cate = "ERRO"; time = "ERRO"; revision = "ERRO";
MessageBox.Show(Convert.ToString(erro));
}
return(name, path, cate, time, revision);
}
private void button1_Click(object sender, EventArgs e)
{
if (Wettbewerb_combobox.Text.Length == 0)
{
label2.Text = "Wettbewerb auswählen";
return;
}
//mysql tables string erzeugen
string abcd = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`Spieler` VARCHAR(50) NOT NULL,
`Team` VARCHAR(50) NOT NULL,
`Opp` VARCHAR(50) NOT NULL,
`Pos` VARCHAR(50) NOT NULL,
`Min` VARCHAR(50) NOT NULL,
`G` VARCHAR(50) NOT NULL,
`A` VARCHAR(50) NOT NULL,
`S` VARCHAR(50) NOT NULL,
`SOG` VARCHAR(50) NOT NULL,
`CC` VARCHAR(50) NOT NULL,
`P` VARCHAR(50) NOT NULL,
`AP` VARCHAR(50) NOT NULL,
`CR` VARCHAR(50) NOT NULL,
`ACR` VARCHAR(50) NOT NULL,
`AW` VARCHAR(50) NOT NULL,
`DR` VARCHAR(50) NOT NULL,
`DSP` VARCHAR(50) NOT NULL,
`INTT` VARCHAR(50) NOT NULL,
`TKL` VARCHAR(50) NOT NULL,
`TKLW` VARCHAR(50) NOT NULL,
`BLK` VARCHAR(50) NOT NULL,
`CL` VARCHAR(50) NOT NULL,
`CS` VARCHAR(50) NOT NULL,
`GC` VARCHAR(50) NOT NULL,
`SV` VARCHAR(50) NOT NULL,
`FS` VARCHAR(50) NOT NULL,
`FC` VARCHAR(50) NOT NULL,
`Y` VARCHAR(50) NOT NULL,
`R` VARCHAR(50) NOT NULL,
`Wettbewerb` VARCHAR(50) NOT NULL,
`Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0',
`Datum` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `Spielerid` (`Spielerid`))
ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "Rotowire");
//mysql connection erzeugen
MySqlConnection con = new MySqlConnection("server=buqhvbltjab1w9h2bks9-mysql.services.clever-cloud.com;port =20444; database=buqhvbltjab1w9h2bks9;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F");
con.Open();
//mysql DB erzeugen
var cmda = new MySql.Data.MySqlClient.MySqlCommand(abcd, con);
cmda.ExecuteNonQuery();
con.Close();
//db auslesen
//liste Datum erzeugen
string datum2 = System.DateTime.Now.ToShortDateString();
List <string> dbListe1 = new List <string>();
MySqlCommand command1 = con.CreateCommand();
command1.CommandText = "SELECT Wettbewerb FROM Rotowire WHERE Datum = '" + datum2 + "'";
MySqlDataReader Reader1;
con.Open();
Reader1 = command1.ExecuteReader();
while (Reader1.Read())
{
string row1 = "";
for (int i = 0; i < Reader1.FieldCount; i++)
{
row1 += Reader1.GetValue(i).ToString();
dbListe1.Add(row1);
}
}
dbListe1 = dbListe1.Distinct().ToList();
con.Close();
//CSV in Array speichern
string whole_file;
string link = String.Join(",", listBox1.Items.OfType <Object>().Select(i => i.ToString()).ToArray());
whole_file = System.IO.File.ReadAllText(@link);
whole_file = whole_file.Replace('\n', '\r');
string[] lines = whole_file.Split(new char[] { '\r' },
StringSplitOptions.RemoveEmptyEntries);
int num_rows = lines.Length;
int num_cols = lines[0].Split(',').Length;
string[,] Tabelle = new string[num_rows, 10];
string[,] values = new string[num_rows, num_cols];
for (int r = 0; r < num_rows; r++)
{
string[] line_r = lines[r].Split(',');
for (int c = 0; c < num_cols; c++)
{
values[r, c] = line_r[c];
}
}
//MYSQL Table erzeugen und Connection erstellen
//mysql tables string erzeugen
string createTableQuery = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`Spieler` VARCHAR(50) NOT NULL,
`Team` VARCHAR(50) NOT NULL,
`Opp` VARCHAR(50) NOT NULL,
`Pos` VARCHAR(50) NOT NULL,
`Min` VARCHAR(50) NOT NULL,
`G` VARCHAR(50) NOT NULL,
`A` VARCHAR(50) NOT NULL,
`S` VARCHAR(50) NOT NULL,
`SOG` VARCHAR(50) NOT NULL,
`CC` VARCHAR(50) NOT NULL,
`P` VARCHAR(50) NOT NULL,
`AP` VARCHAR(50) NOT NULL,
`CR` VARCHAR(50) NOT NULL,
`ACR` VARCHAR(50) NOT NULL,
`AW` VARCHAR(50) NOT NULL,
`DR` VARCHAR(50) NOT NULL,
`DSP` VARCHAR(50) NOT NULL,
`INTT` VARCHAR(50) NOT NULL,
`TKL` VARCHAR(50) NOT NULL,
`TKLW` VARCHAR(50) NOT NULL,
`BLK` VARCHAR(50) NOT NULL,
`CL` VARCHAR(50) NOT NULL,
`CS` VARCHAR(50) NOT NULL,
`GC` VARCHAR(50) NOT NULL,
`SV` VARCHAR(50) NOT NULL,
`FS` VARCHAR(50) NOT NULL,
`FC` VARCHAR(50) NOT NULL,
`Y` VARCHAR(50) NOT NULL,
`R` VARCHAR(50) NOT NULL,
`Wettbewerb` VARCHAR(50) NOT NULL,
`Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0',
`Datum` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `Spielerid` (`Spielerid`))
ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "Rotowire");
//mysql connection erzeugen
MySqlConnection connection = new MySqlConnection("server=buqhvbltjab1w9h2bks9-mysql.services.clever-cloud.com;port =20444; database=buqhvbltjab1w9h2bks9;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F");
connection.Open();
//mysql DB erzeugen
var cmd = new MySql.Data.MySqlClient.MySqlCommand(createTableQuery, connection);
cmd.ExecuteNonQuery();
connection.Close();
//letzte db id auslesen
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM Rotowire";
MySqlDataReader Reader;
connection.Open();
Reader = command.ExecuteReader();
label2.Text = "";
while (Reader.Read())
{
string row = "";
//Komplette dB auslesen
//for (int i = 0; i < Reader.FieldCount; i++)
//letzte id auslesen
for (int i = 0; i < 1; i++)
{
row += Reader.GetValue(i).ToString();
}
label2.Text = row;
}
connection.Close();
//daten in db
connection.Open();
int h;
if (label2.Text.Length == 0)
{
h = 1;
}
else
{
h = Int32.Parse(label2.Text) + 1;
}
int k;
string st2;
string st3;
string datum = System.DateTime.Now.ToShortDateString();
for (int i = 2; i < num_rows; i++)
{
k = 0;
cmd.CommandText = "INSERT INTO Rotowire(id, Spieler, Team, Opp, Pos, Min, G, A, S, SOG, CC, P, AP, CR, ACR, AW, DR, DSP, INTT, TKL, TKLW, BLK, CL, CS, GC, SV, FS, FC, Y, R, Wettbewerb, Spielerid, Datum) VALUES(@id, @Spieler, @Team, @Opp, @Pos, @Min, @G, @A, @S, @SOG, @CC, @P, @AP, @CR, @ACR, @AW, @DR, @DSP, @INTT, @TKL, @TKLW, @BLK, @CL, @CS, @GC, @SV, @FS, @FC, @Y, @R, @Wettbewerb, @Spielerid, @Datum)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@id", h + i);
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Spieler", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Team", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Opp", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Pos", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Min", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@G", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@A", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@S", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@SOG", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@CC", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@P", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@AP", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@CR", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@ACR", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@AW", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@DR", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@DSP", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@INTT", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@TKL", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@TKLW", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@BLK", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@CL", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@CS", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@GC", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@SV", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@FS", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@FC", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Y", st3);
k = k + 1;
st2 = values[i, k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@R", st3);
cmd.Parameters.AddWithValue("@Spielerid", k);
cmd.Parameters.AddWithValue("@Wettbewerb", Wettbewerb_combobox.Text);
cmd.Parameters.AddWithValue("@Datum", datum);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
connection.Close();
label2.Text = "Finish";
}
private void button1_Click(object sender, EventArgs e)
{
//Prüfen ob alle Einträge gemacht sind!!
if (FanteamUrl_input.Text.Length == 0)
{
status_lbl.Text = "URL eingeben";
return;
}
if (AnzahlSeiten_input.Text.Length == 0)
{
status_lbl.Text = "Anzahl Seiten eingeben";
return;
}
if (TurnierID_eingabe.Text.Length == 0)
{
status_lbl.Text = "TurnierID eingeben";
return;
}
if (Wettbewerb_combobox.Text.Length == 0)
{
status_lbl.Text = "Wettbewerb auswählen";
return;
}
if (FanteamUrl_input.Text.Length != 0 && AnzahlSeiten_input.Text.Length != 0 && TurnierID_eingabe.Text.Length != 0 && Wettbewerb_combobox.Text.Length != 0)
{
//mysql tables string erzeugen
string abcd = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`Wettbewerb` VARCHAR(50) NOT NULL,
`Spieler` VARCHAR(50) NOT NULL,
`Position` VARCHAR(50) NOT NULL,
`home` VARCHAR(50) NOT NULL,
`away` VARCHAR(50) NOT NULL,
`Form` VARCHAR(50) NOT NULL,
`Punkte` VARCHAR(50) NOT NULL,
`Preis` VARCHAR(50) NOT NULL,
`Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0',
`Datum` VARCHAR(50) NOT NULL,
`TurnierID` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `Spielerid` (`Spielerid`))
ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "FanteamPreise");
//mysql connection erzeugen
MySqlConnection con = new MySqlConnection("server=bddiyuk2rbzdbj9pfb9r-mysql.services.clever-cloud.com;database=bddiyuk2rbzdbj9pfb9r;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F");
con.Open();
//mysql DB erzeugen
var cmda = new MySql.Data.MySqlClient.MySqlCommand(abcd, con);
cmda.ExecuteNonQuery();
con.Close();
//db auslesen
//liste Wettbewerb erzeugen
List <string> dbListe1 = new List <string>();
MySqlCommand command1 = con.CreateCommand();
command1.CommandText = "SELECT TurnierID FROM FanteamPreise";
MySqlDataReader Reader1;
con.Open();
Reader1 = command1.ExecuteReader();
while (Reader1.Read())
{
string row1 = "";
for (int i = 0; i < Reader1.FieldCount; i++)
{
row1 += Reader1.GetValue(i).ToString();
dbListe1.Add(row1);
}
}
con.Close();
dbListe1 = dbListe1.Distinct().ToList();
int abb = 0;
for (int i = 0; i < dbListe1.Count(); i++)
{
if (dbListe1[i] == TurnierID_eingabe.Text)
{
abb = 1;
}
}
if (abb != 0)
{
status_lbl.Text = "Turnier bereits in DB geladen.";
return;
}
if (abb == 0)
{
//Spielerliste erzeugen
List <string> Spielerliste = new List <string>();
//Firefox öffnen
IWebDriver driver = new FirefoxDriver();
//URL öffnen
driver.Url = FanteamUrl_input.Text;
//10 sec warten
System.Threading.Thread.Sleep(10000);
//javaScript einbinden
IJavaScriptExecutor js = driver as IJavaScriptExecutor;
//Anzahl Seiten auslesen
int x = Int32.Parse(AnzahlSeiten_input.Text);
//Daten scrappen
for (int j = 0; j < x; j++)
{
//Tabelle in Webelement speichern
IWebElement table = (IWebElement)js.ExecuteScript("return document.querySelector('.ft-view-port').shadowRoot.querySelector('.not-safari').shadowRoot.querySelector('.choices')");
//Webelement in String speichern
string table_str = table.Text;
//String vereinzeln und in array speichern
string[] Spieler_ar = table_str.Split(new Char[] { '\n' });
//Spieler in Liste eintragen
for (int i = 5; i < Spieler_ar.Length; i++)
{
Spielerliste.Add(Spieler_ar[i]);
}
//nächste Seite
js.ExecuteScript("return document.querySelector('.ft-view-port').shadowRoot.querySelector('.not-safari').shadowRoot.querySelector('.game > aside:nth-child(1) > ft-loading:nth-child(4) > ft-pagination:nth-child(2)').shadowRoot.querySelector('button.pagination__arrow:nth-child(4)').click()");
}
driver.Close();
// Daten in SQL
string createTableQuery = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`Wettbewerb` VARCHAR(50) NOT NULL,
`Spieler` VARCHAR(50) NOT NULL,
`Position` VARCHAR(50) NOT NULL,
`home` VARCHAR(50) NOT NULL,
`away` VARCHAR(50) NOT NULL,
`Form` VARCHAR(50) NOT NULL,
`Punkte` VARCHAR(50) NOT NULL,
`Preis` VARCHAR(50) NOT NULL,
`Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0',
`Datum` VARCHAR(50) NOT NULL,
`TurnierID` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `Spielerid` (`Spielerid`))
ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "FanteamPreise");
//mysql connection erzeugen
MySqlConnection connection = new MySqlConnection("server=bddiyuk2rbzdbj9pfb9r-mysql.services.clever-cloud.com;database=bddiyuk2rbzdbj9pfb9r;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F");
connection.Open();
//mysql DB erzeugen
var cmd = new MySql.Data.MySqlClient.MySqlCommand(createTableQuery, connection);
cmd.ExecuteNonQuery();
connection.Close();
//letzte db id auslesen
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM FanteamPreise";
MySqlDataReader Reader;
connection.Open();
Reader = command.ExecuteReader();
while (Reader.Read())
{
string row = "";
//Komplette dB auslesen
//for (int i = 0; i < Reader.FieldCount; i++)
//letzte id auslesen
for (int i = 0; i < 1; i++)
{
row += Reader.GetValue(i).ToString();
}
status_lbl.Text = row;
}
connection.Close();
//daten in db
connection.Open();
int h;
if (status_lbl.Text.Length == 0)
{
h = 1;
}
else
{
h = Int32.Parse(status_lbl.Text) + 1;
}
int k = 0;
string st2;
string st3;
string datum = System.DateTime.Now.ToShortDateString();
for (int i = 0; i < Spielerliste.Count / 7; i++)
{
cmd.CommandText = "INSERT INTO FanteamPreise(id, Spieler, Position, home, away, Form, Punkte, Preis, Spielerid, Wettbewerb, Datum, TurnierID) VALUES(@id, @Spieler, @Position, @home, @away, @Form, @Punkte, @Preis, @Spielerid, @Wettbewerb, @Datum, @TurnierID)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@id", h + i);
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Position", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Spieler", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@home", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@away", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Form", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Punkte", st3);
k = k + 1;
st2 = Spielerliste[k];
st3 = st2.Trim();
cmd.Parameters.AddWithValue("@Preis", st3);
k = k + 1;
cmd.Parameters.AddWithValue("@Spielerid", k);
cmd.Parameters.AddWithValue("@Wettbewerb", Wettbewerb_combobox.Text);
cmd.Parameters.AddWithValue("@Datum", datum);
cmd.Parameters.AddWithValue("@TurnierID", TurnierID_eingabe.Text);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
connection.Close();
status_lbl.Text = "finished!";
}
}
}
public Form3()
{
InitializeComponent();
string myConnnection = "datasource=localhost; port=3306;username=root;password=Sercan.123; ";
MySqlConnection myConn = new MySqlConnection(myConnnection);
myConn.Open();
MySqlCommand command = new MySqlCommand();
command = myConn.CreateCommand();
command.CommandText = "SELECT schema_name FROM information_schema.schemata where schema_name not like '%_schema' and schema_name not like 'mysql';";
MySqlDataReader Reader1;
Reader1 = command.ExecuteReader();
while (Reader1.Read())
{
string row = "";
for (int i = 0; i < Reader1.FieldCount; i++)
{
row += Reader1.GetValue(i).ToString();
}
trV1.Nodes.Add(row);
}
for (int i = 0; i < trV1.Nodes.Count; i++)
{
trV1.Nodes[i].Nodes.Add("Tables");
trV1.Nodes[i].Nodes.Add("Views");
trV1.Nodes[i].Nodes.Add("Stored Procedure");
trV1.Nodes[i].Nodes.Add("Functions ");
}
Reader1.Close();
Reader1.Dispose();
myConn.Close();
myConn.Open();
MySqlCommand command_table = new MySqlCommand();
command_table = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_table.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_schema ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader2;
Reader2 = command_table.ExecuteReader();
while (Reader2.Read())
{
string table = "";
for (int j = 0; j < Reader2.FieldCount; j++)
{
table += Reader2.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[0].Nodes.Add(table);
}
Reader2.Close();
Reader2.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_view = new MySqlCommand();
command_view = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_view.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_type='VIEW' AND table_schema ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader3;
Reader3 = command_view.ExecuteReader();
while (Reader3.Read())
{
string view = "";
for (int j = 0; j < Reader3.FieldCount; j++)
{
view += Reader3.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[1].Nodes.Add(view);
}
Reader3.Close();
Reader3.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_procedure = new MySqlCommand();
command_procedure = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_procedure.CommandText = "SHOW PROCEDURE STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader4;
Reader4 = command_procedure.ExecuteReader();
while (Reader4.Read())
{
string procedure = "";
for (int j = 0; j < Reader4.FieldCount; j++)
{
procedure += Reader4.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[2].Nodes.Add(procedure);
}
Reader4.Close();
Reader4.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_function = new MySqlCommand();
command_function = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_function.CommandText = "SHOW FUNCTION STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader5;
Reader5 = command_function.ExecuteReader();
while (Reader5.Read())
{
string function = "";
for (int j = 0; j < Reader5.FieldCount; j++)
{
function += Reader5.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[3].Nodes.Add(function);
}
Reader5.Close();
Reader5.Dispose();
}
ContextMenuStrip docMenu = new ContextMenuStrip();
ToolStripMenuItem SelectRows = new ToolStripMenuItem();
SelectRows.Text = "Select Rows";
ToolStripMenuItem AlterTable = new ToolStripMenuItem();
AlterTable.Text = "Alter Table";
ToolStripMenuItem DropTable = new ToolStripMenuItem();
DropTable.Text = "Drop Table";
docMenu.Items.AddRange(new ToolStripMenuItem[] { SelectRows, AlterTable, DropTable });
for (int i = 0; i < trV1.Nodes.Count; i++)
{
for (int j = 0; j < trV1.Nodes[i].Nodes[0].Nodes.Count; j++)
{
trV1.Nodes[i].Nodes[0].Nodes[j].ContextMenuStrip = docMenu;
}
}
SelectRows.Click += SelectRows_Click;
void SelectRows_Click(object sender, System.EventArgs e)
{
MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=Sercan.123");
connection.Open();
try
{
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM " + trV1.SelectedNode.Parent.Parent.Text + "." + trV1.SelectedNode.Text + " ", connection);
DataSet ds = new DataSet();
adapter.Fill(ds, trV1.SelectedNode.Text);
dataGridView1.DataSource = ds.Tables[trV1.SelectedNode.Text];
string a = ds.Tables[0].Columns.ToString();
//MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM blm437.ogrenci ", connection);
//DataSet ds = new DataSet();
//adapter.Fill(ds, "ogrenci");
//dataGridView1.DataSource = ds.Tables["ogrenci"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
