public static int UpdateOrg(Team t, int oID, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
int count = 0;
try
{
count = OrganisationTable.SelectTeamCountGame(oID, t.Game_Id.Id);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(-1);
}
if (count > 0)
{
Console.WriteLine("Organizace uz ma tym pro tuto hru");
return(-1);
}
OracleCommand command = db.CreateCommand(SQL_UPDATE_ORG);
command.Parameters.AddWithValue(":id", t.Id);
command.Parameters.AddWithValue(":voID", oID);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int Update(Organisation o, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, o);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int Delete(int id, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_DELETE_ID);
command.Parameters.AddWithValue(":id", id);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int Insert(Game game, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, game);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int UpdateGame(int tID, int gID, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_UPDATE_GAME);
command.Parameters.AddWithValue(":team", gID);
command.Parameters.AddWithValue(":game", tID);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int PridatAkci(Event e, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
int event_id = 0;
if (e.Prizepool == null)
{
e.Prizepool = 0;
}
if (SelectAllFromOrganiser(e.Organiser).Count > 500)
{
Console.WriteLine("Prekrocen maximalni pocet akci");
return(-1);
}
event_id = SelectLast();
e.Id = ++event_id;
OracleCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, e);
int ret = 0;
try
{
ret = db.ExecuteNonQuery(command);
}
catch (Exception er)
{
Console.WriteLine(er.Message);
}
db.Close();
return(ret);
}
public static int Delete(int id, DatabaseT pDb = null)
{
DatabaseT db = new DatabaseT();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_DELETE_ID);
Person p = PersonTable.SelectOne(id);
if (p.Role == "Coach")
{
Team ot = TeamTable.SelectOne(p.Team_Id.Id);
ot.Person_Id = null;
TeamTable.Update(ot);
}
command.Parameters.AddWithValue(":id", id);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}