public static int Update(Duvod duvod, 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, duvod);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public static int Insert(Duvod duvod, MyDatabase pDB = null)
{
MyDatabase db;
if (pDB == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDB;
}
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, duvod);
int ret = db.ExecuteNonQuery(command);
if (pDB == null)
{
db.Close();
}
return(ret);
}
private static Collection <Duvod> Read(SqlDataReader reader)
{
Collection <Duvod> duvody = new Collection <Duvod>();
while (reader.Read())
{
int i = -1;
Duvod duvod = new Duvod();
duvod.ID_duvodu = reader.GetInt32(++i);
duvod.Nazev = reader.GetString(++i);
duvody.Add(duvod);
}
return(duvody);
}
public static Duvod 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_duvodu", id);
SqlDataReader reader = db.Select(command);
Collection <Duvod> duvody = Read(reader);
Duvod duvod = null;
if (duvody.Count == 1)
{
duvod = duvody[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
if (duvod == null)
{
Console.WriteLine("Duvod neexistuje");
}
return(duvod);
}
private static void PrepareCommand(SqlCommand command, Duvod duvod)
{
command.Parameters.AddWithValue("@ID_duvodu", duvod.ID_duvodu);
command.Parameters.AddWithValue("@Nazev", duvod.Nazev);
}
