/** * Select the record. **/ public Historie_mezd Select(DateTime datum_od, DateTime datum_do, int id_zamestnanec) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_SELECT_SPECIFIC); command.Parameters.Add(new SqlParameter("@datum_od", SqlDbType.Date)); command.Parameters["@datum_od"].Value = datum_od; command.Parameters.Add(new SqlParameter("@datum_do", SqlDbType.Date)); command.Parameters["@datum_do"].Value = datum_do; command.Parameters.Add(new SqlParameter("@id_zamestnanec", SqlDbType.Int)); command.Parameters["@id_zamestnanec"].Value = id_zamestnanec; SqlDataReader reader = db.Select(command); Collection <Historie_mezd> hi_mzdy = Read(reader, false); Historie_mezd hi_mzda = null; if (hi_mzdy.Count == 1) { hi_mzda = hi_mzdy[0]; } reader.Close(); db.Close(); return(hi_mzda); }
/** * Insert the record. **/ /*public int Insert(Historie_mezd hi_mezd) * { * Database db = new Database(); * db.Connect(); * SqlCommand command = db.CreateCommand(SQL_INSERT); * PrepareCommand(command, hi_mezd); * int ret = db.ExecuteNonQuery(command); * db.Close(); * return ret; * }*/ /** * Update the record. **/ /*public int Update(Historie_mezd hi_mezd) * { * Database db = new Database(); * db.Connect(); * SqlCommand command = db.CreateCommand(SQL_UPDATE); * PrepareCommand(command, hi_mezd); * int ret = db.ExecuteNonQuery(command); * db.Close(); * return ret; * }*/ /** * Prepare a command. **/ private void PrepareCommand(SqlCommand command, Historie_mezd hi_mezd) { command.Parameters.Add(new SqlParameter("@datum_od", SqlDbType.Date)); command.Parameters["@datum_od"].Value = hi_mezd.Datum_od; command.Parameters.Add(new SqlParameter("@datum_do", SqlDbType.Date)); command.Parameters["@datum_do"].Value = hi_mezd.Datum_do; command.Parameters.Add(new SqlParameter("@id_zamestnanec", SqlDbType.Int)); command.Parameters["@id_zamestnanec"].Value = hi_mezd.Zamestnanec.Id_zamestnanec; command.Parameters.Add(new SqlParameter("@mzda", SqlDbType.Int)); command.Parameters["@mzda"].Value = hi_mezd.Mzda; }
private Collection <Historie_mezd> Read(SqlDataReader reader, bool complete) { Collection <Historie_mezd> hi_mzdy = new Collection <Historie_mezd>(); while (reader.Read()) { Historie_mezd hi_mzda = new Historie_mezd(); hi_mzda.Datum_od = reader.GetDateTime(0); hi_mzda.Datum_do = reader.GetDateTime(1); hi_mzda.Zamestnanec = new Zamestnanec(); hi_mzda.Zamestnanec.Id_zamestnanec = reader.GetInt32(2); hi_mzda.Mzda = reader.GetInt32(3); //4 je id zamestnance z tab zamestnanec if (complete) { hi_mzda.Zamestnanec.Jmeno = reader.GetString(5); hi_mzda.Zamestnanec.Prijmeni = reader.GetString(6); hi_mzda.Zamestnanec.Typ = reader.GetString(7)[0]; hi_mzda.Zamestnanec.RC = reader.GetString(8); hi_mzda.Zamestnanec.Telefon = reader.GetString(9); hi_mzda.Zamestnanec.Email = reader.GetString(10); hi_mzda.Zamestnanec.Datum_nastupu = reader.GetDateTime(11); if (!reader.IsDBNull(12)) { hi_mzda.Zamestnanec.Datum_do = reader.GetDateTime(12); } hi_mzda.Zamestnanec.Pohybliva_mzda = reader.GetInt32(13); hi_mzda.Zamestnanec.Zakladni_mzda = reader.GetInt32(14); hi_mzda.Zamestnanec.Id_adresa = new Adresa(); hi_mzda.Zamestnanec.Id_adresa.Id_adresa = reader.GetInt32(15); hi_mzda.Zamestnanec.Id_oddeleni = new Oddeleni(); hi_mzda.Zamestnanec.Id_oddeleni.Id_oddeleni = reader.GetInt32(16); } hi_mzdy.Add(hi_mzda); } return(hi_mzdy); }