private void PrepareCommand(SqlCommand command, Oddeleni oddeleni) { command.Parameters.Add(new SqlParameter("@id_oddeleni", SqlDbType.Int)); command.Parameters["@id_oddeleni"].Value = oddeleni.Id_oddeleni; command.Parameters.Add(new SqlParameter("@nazev", SqlDbType.VarChar, oddeleni.Nazev.Length)); command.Parameters["@nazev"].Value = oddeleni.Nazev; command.Parameters.Add(new SqlParameter("@zakladni_mzda", SqlDbType.Int)); command.Parameters["@zakladni_mzda"].Value = oddeleni.Zakladni_mzda; }
public int Update(Oddeleni oddeleni) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, oddeleni); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private Collection <Oddeleni> Read(SqlDataReader reader) { Collection <Oddeleni> oddeleni = new Collection <Oddeleni>(); while (reader.Read()) { Oddeleni odd = new Oddeleni(); odd.Id_oddeleni = reader.GetInt32(0); odd.Nazev = reader.GetString(1); odd.Zakladni_mzda = reader.GetInt32(2); oddeleni.Add(odd); } return(oddeleni); }
public Oddeleni Select(int id_oddeleni) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_SELECT_ID); command.Parameters.Add(new SqlParameter("@id_oddeleni", SqlDbType.Int)); command.Parameters["@id_oddeleni"].Value = id_oddeleni; SqlDataReader reader = db.Select(command); Collection <Oddeleni> oddeleni = Read(reader); Oddeleni odd = null; if (oddeleni.Count == 1) { odd = oddeleni[0]; } reader.Close(); db.Close(); return(odd); }
public Zamestnanec() { mId_adresa = new Adresa(); mId_oddeleni = new Oddeleni(); }