public static int UpdateNeschvalena(Ziadosti ziadosti, int v_id_ziadost_neschvalena, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE_SCHVALENA);
command.Parameters.AddWithValue("v_id_ziadost_neschvalena", v_id_ziadost_neschvalena);
PrepareCommand(command, ziadosti);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static Collection <Ziadosti> Read(SqlDataReader reader)
{
Collection <Ziadosti> ziadosti = new Collection <Ziadosti>();
while (reader.Read())
{
int i = -1;
Ziadosti ziadost = new Ziadosti();
ziadost.id_ziadost = reader.GetInt32(++i);
ziadost.id_zamestnanec = reader.GetString(++i);
ziadost.id_veduci = reader.GetInt32(++i);
ziadost.id_ukolu = reader.GetInt32(++i);
ziadost.id_letu = reader.GetInt32(++i);
if (!reader.IsDBNull(++i))
{
ziadost.akceptovane = reader.GetInt32(i);
}
else
{
ziadost.akceptovane = 0;
}
ziadost.info = reader.GetString(++i);
ziadost.pozadovany_datum = reader.GetDateTime(++i);
ziadost.pozadovana_smena = reader.GetInt32(++i);
ziadosti.Add(ziadost);
}
return(ziadosti);
}
public static int Insert(Ziadosti ziadosti, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, ziadosti);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static void PrepareCommand(SqlCommand command, Ziadosti ziadosti)
{
command.Parameters.AddWithValue("@id_ziadost", ziadosti.id_ziadost);
command.Parameters.AddWithValue("@id_zamestnanec", ziadosti.id_zamestnanec);
command.Parameters.AddWithValue("@id_veduci", ziadosti.id_veduci);
command.Parameters.AddWithValue("@id_ukolu", ziadosti.id_ukolu);
command.Parameters.AddWithValue("@id_letu", ziadosti.id_letu);
command.Parameters.AddWithValue("@akceptovane", ziadosti.akceptovane == null ? DBNull.Value : (object)ziadosti.akceptovane);
command.Parameters.AddWithValue("@info", ziadosti.info);
command.Parameters.AddWithValue("@pozadovany_datum", ziadosti.pozadovany_datum);
command.Parameters.AddWithValue("@pozadovana_smena", ziadosti.pozadovana_smena);
}
