public static DataTable FindD(int _id)
{
DataTable dt = new DataTable();
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "SELECT * FROM Zapasy z WHERE z.z_id = @p_z_id";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_z_id", _id);
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
}
}
}
catch { }
return(dt);
}
public static int getLastID()
{
DataTable dt = new DataTable();
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "SELECT MAX(h_id) FROM Hraci";
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
}
}
return(Convert.ToInt32(dt.Rows[0][0].ToString()));
}
catch { return(-1); }
}
public DataTable FindD()
{
DataTable dt = new DataTable();
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "SELECT * FROM Zapasy";
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
}
}
}
catch { }
return(dt);
}
public void Upravit()
{
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "UPDATE Hraci SET jmeno = @p_jmeno, prijmeno = @p_prijmeni, datumZalozeni = @p_datum, zeme = @p_zeme, tym_id = @p_tym_id WHERE h_id = @p_id";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_id", this.ID);
command.Parameters.AddWithValue("@p_jmeno", this.jmeno);
command.Parameters.AddWithValue("@p_prijmeni", this.prijmeni);
command.Parameters.AddWithValue("@p_datum", this.datumZalozeni);
command.Parameters.AddWithValue("@p_zeme", this.zeme);
command.Parameters.AddWithValue("@p_tym_id", this.tym.ID);
command.ExecuteNonQuery();
}
}
}
catch (Exception e) {
;
}
}
public void Pridat()
{
this.ID = Hrac.getLastID() + 1;
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "INSERT INTO Hraci VALUES(@p_id, @p_jmeno, @p_prijmeni, @p_datum, @p_zeme, @p_tym_id)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_id", this.ID);
command.Parameters.AddWithValue("@p_jmeno", this.jmeno);
command.Parameters.AddWithValue("@p_prijmeni", this.prijmeni);
command.Parameters.AddWithValue("@p_datum", this.datumZalozeni);
command.Parameters.AddWithValue("@p_zeme", this.zeme);
command.Parameters.AddWithValue("@p_tym_id", this.tym.ID);
command.ExecuteNonQuery();
}
}
}
catch (Exception e) {; }
}
public static string PrihlasitDoTurnaje(int _id_turnaje)
{
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand("PrihlasitDoTurnaje", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_trener_id", Global.IdTrener);
cmd.Parameters.AddWithValue("@p_turnaj_id", _id_turnaje);
var error = cmd.Parameters.Add("@o_error", SqlDbType.Bit);
var error_msg = cmd.Parameters.Add("@o_error_msg", SqlDbType.VarChar, 50);
error.Direction = ParameterDirection.Output;
error_msg.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (Convert.ToBoolean(error.Value))
{
return(error_msg.Value.ToString());
}
}
return(null);
}
catch (Exception e) {
return(e.Message);
}
}
public static DataTable FindByCoachD(int _id)
{
DataTable dt = new DataTable();
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "SELECT * FROM Tymy t JOIN treneri tr on tr.ty_id = t.tym_id WHERE tr.ty_id = @p_tr_id";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_tr_id", _id);
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
}
}
}
catch { }
return(dt);
}
public static string getTymSnejviceBody()
{
try
{
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
string tym;
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand("getTymSnejviceBody", connection))
{
command.CommandType = CommandType.StoredProcedure;
var returnTym = command.Parameters.Add("@tym", SqlDbType.VarChar, 20);
returnTym.Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
tym = returnTym.Value.ToString();
}
}
return(tym);
}
catch (Exception e)
{
return("chyba");
}
}
public static void PripsatBody()
{
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand("PripsatBody", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
}
}
public void Smazat()
{
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "DELETE FROM Hraci WHERE h_id = @p_id";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_id", this.ID);
command.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
;
}
}