/** * Update the record. **/ public int Update(Zamestnanec zamestnanec) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, zamestnanec); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private Collection <Zamestnanec> Read(SqlDataReader reader, bool complete) { Collection <Zamestnanec> zamestnanci = new Collection <Zamestnanec>(); while (reader.Read()) { Zamestnanec zamestnanec = new Zamestnanec(); zamestnanec.Id_zamestnanec = reader.GetInt32(0); zamestnanec.Jmeno = reader.GetString(1); zamestnanec.Prijmeni = reader.GetString(2); zamestnanec.Typ = reader.GetString(3)[0]; zamestnanec.RC = reader.GetString(4); zamestnanec.Telefon = reader.GetString(5); zamestnanec.Email = reader.GetString(6); zamestnanec.Datum_nastupu = reader.GetDateTime(7); if (!reader.IsDBNull(8)) { zamestnanec.Datum_do = reader.GetDateTime(8); } zamestnanec.Pohybliva_mzda = reader.GetInt32(9); zamestnanec.Zakladni_mzda = reader.GetInt32(10); zamestnanec.Id_adresa = new Adresa(); zamestnanec.Id_adresa.Id_adresa = reader.GetInt32(11); zamestnanec.Id_oddeleni = new Oddeleni(); zamestnanec.Id_oddeleni.Id_oddeleni = reader.GetInt32(12); //Kdyby jsme potrebovali konkretni adresu a oddeleni k zamestnanci //Vetsinou nam budou stacit ID if (complete) { //13 je zase id adresa zamestnanec.Id_adresa.Mesto = reader.GetString(14); zamestnanec.Id_adresa.Ulice = reader.GetString(15); zamestnanec.Id_adresa.Stat = reader.GetString(16); zamestnanec.Id_adresa.PSC = reader.GetString(17); zamestnanec.Id_adresa.Pocet_klientu = reader.GetInt32(18); //19 zase id oddeleni zamestnanec.Id_oddeleni.Nazev = reader.GetString(20); zamestnanec.Id_oddeleni.Zakladni_mzda = reader.GetInt32(21); } zamestnanci.Add(zamestnanec); } return(zamestnanci); }
private void btnNajdiZ_Click(object sender, EventArgs e) { try { z = zt.Select(Int32.Parse(tbIDZ.Text)); if (k == null) { MessageBox.Show("Zamestnanec s ID " + tbIDZ.Text + " neexistuje", "Varovani", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("Zamestnanec s ID " + tbIDZ.Text + " existuje", "Informace", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { MessageBox.Show("Zadejte spravne ID zaměstnance", "Varovani", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/** * Prepare a command. **/ private void PrepareCommand(SqlCommand command, Zamestnanec zamestnanec) { command.Parameters.Add(new SqlParameter("@id_zamestnanec", SqlDbType.Int)); command.Parameters["@id_zamestnanec"].Value = zamestnanec.Id_zamestnanec; command.Parameters.Add(new SqlParameter("@jmeno", SqlDbType.VarChar, zamestnanec.Jmeno.Length)); command.Parameters["@jmeno"].Value = zamestnanec.Jmeno; command.Parameters.Add(new SqlParameter("@prijmeni", SqlDbType.VarChar, zamestnanec.Prijmeni.Length)); command.Parameters["@prijmeni"].Value = zamestnanec.Prijmeni; command.Parameters.Add(new SqlParameter("@typ", SqlDbType.Char, Zamestnanec.LEN_ATTR_typ)); command.Parameters["@typ"].Value = zamestnanec.Typ; command.Parameters.Add(new SqlParameter("@rc", SqlDbType.VarChar, zamestnanec.RC.Length)); command.Parameters["@rc"].Value = zamestnanec.RC; command.Parameters.Add(new SqlParameter("@telefon", SqlDbType.VarChar, zamestnanec.Telefon.Length)); command.Parameters["@telefon"].Value = zamestnanec.Telefon; command.Parameters.Add(new SqlParameter("@email", SqlDbType.VarChar, zamestnanec.Email.Length)); command.Parameters["@email"].Value = zamestnanec.Email; command.Parameters.Add(new SqlParameter("@datum_nastupu", SqlDbType.Date)); command.Parameters["@datum_nastupu"].Value = zamestnanec.Datum_nastupu; command.Parameters.Add(new SqlParameter("@datum_do", SqlDbType.Date)); command.Parameters["@datum_do"].Value = zamestnanec.Datum_do; command.Parameters.Add(new SqlParameter("@pohybliva_mzda", SqlDbType.Int)); command.Parameters["@pohybliva_mzda"].Value = zamestnanec.Pohybliva_mzda; command.Parameters.Add(new SqlParameter("@zakladni_mzda", SqlDbType.Int)); command.Parameters["@zakladni_mzda"].Value = zamestnanec.Zakladni_mzda; command.Parameters.Add(new SqlParameter("@id_adresa", SqlDbType.Int)); command.Parameters["@id_adresa"].Value = zamestnanec.Id_adresa.Id_adresa; command.Parameters.Add(new SqlParameter("@id_oddeleni", SqlDbType.Int)); command.Parameters["@id_oddeleni"].Value = zamestnanec.Id_oddeleni.Id_oddeleni; }
public Zamestnanec SelectComplete(int id) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_SELECT_ID); command.Parameters.Add(new SqlParameter("@id_zamestnanec", SqlDbType.Int)); command.Parameters["@id_zamestnanec"].Value = id; SqlDataReader reader = db.Select(command); Collection <Zamestnanec> zamestnanci = Read(reader, true); Zamestnanec zamestnanec = null; if (zamestnanci.Count == 1) { zamestnanec = zamestnanci[0]; } reader.Close(); db.Close(); return(zamestnanec); }
public Historie_mezd() { mZamestnanec = new Zamestnanec(); }
public Oprava() { mId_zamestnanec = new Zamestnanec(); mSPZ = new Auto(); }