/**
* 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();
}
