public static int update(Prostor Prostor)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, Prostor);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
private static Collection <Prostor> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <Prostor> prostory = new Collection <Prostor>();
while (reader.Read())
{
Prostor prostor = new Prostor();
int i = -1;
prostor.idSpr = reader.GetInt32(++i);
prostor.vzdalenost = reader.GetDouble(++i);
prostory.Add(prostor);
}
return(prostory);
}
public static Prostor select(int idSpr)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@idSpr", idSpr);
SqlDataReader reader = db.Select(command);
Collection <Prostor> prostory = Read(reader);
Prostor prostor = null;
if (prostory.Count == 1)
{
prostor = prostory[0];
}
reader.Close();
db.Close();
return(prostor);
}
static void SprTest()
{
Prostor spr = new Prostor
{
idSpr = 1,
vzdalenost = 10
};
Console.WriteLine("Testovani funkce prostoru Insert - Vypis poctu prvku - update - select - delete - Vypis poctu prvku.\n"
+ spr.vzdalenost);
ProstorTable.insert(spr);
int count = ProstorTable.select().Count;
spr.vzdalenost = 50;
ProstorTable.update(spr);
spr.vzdalenost = 0;
Console.WriteLine("#C: " + count);
spr = ProstorTable.select(1);
Console.WriteLine(spr.vzdalenost);
ProstorTable.delete(1);
count = ProstorTable.select().Count;
ProstorTable.insert(spr);
Console.WriteLine("#C: " + count + "\n" + "Test pro tabulku Prostor ukoncen, stisknutim libovolne klavesy pokracujte k dalsimu testu.");
Console.ReadKey();
}
private static void PrepareCommand(SqlCommand command, Prostor Prostor)
{
command.Parameters.AddWithValue("@idSpr", Prostor.idSpr);
command.Parameters.AddWithValue("@vzdalenost", Prostor.vzdalenost);
}