public static int Update(SmenaTymu st, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, st);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static Collection <SmenaTymu> Read(SqlDataReader reader)
{
Collection <SmenaTymu> stC = new Collection <SmenaTymu>();
while (reader.Read())
{
int i = -1;
SmenaTymu st = new SmenaTymu();
st.ID_smeny = reader.GetInt32(++i);
st.ID_tym = reader.GetInt32(++i);
stC.Add(st);
}
return(stC);
}
public static SmenaTymu Select(int id, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@ID_smenyTymu", id);
SqlDataReader reader = db.Select(command);
Collection <SmenaTymu> stC = Read(reader);
SmenaTymu st = null;
if (stC.Count == 1)
{
st = stC[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
if (st == null)
{
Console.WriteLine("Smena tymu neexistuje");
}
return(st);
}
private static void PrepareCommand(SqlCommand command, SmenaTymu st)
{
command.Parameters.AddWithValue("@ID_smenyTymu", st.ID_smenyTymu);
command.Parameters.AddWithValue("@ID_smeny", st.ID_smeny);
command.Parameters.AddWithValue("@ID_tym", st.ID_tym);
}
