public static int Update(TymZamestnance tz, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, tz);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private void button4_Click(object sender, EventArgs e)
{
string zaznam = TymZamestnanceLB.GetItemText(TymZamestnanceLB.SelectedItem);
string[] casti = zaznam.Split(' ');
int ID_zamestnance = int.Parse(casti[0]);
string zaznam2 = TymyLB.GetItemText(TymyLB.SelectedItem);
string[] casti2 = zaznam2.Split(' ');
int ID_tymu = int.Parse(casti2[0]);
MyDatabase db = new MyDatabase();
db.Connect();
if (TymyLB.Items.Count > 0 && TymyLB.SelectedIndex != -1)
{
zaznam2 = TymyLB.GetItemText(TymyLB.SelectedItem);
casti2 = zaznam2.Split(' ');
ID_tymu = int.Parse(casti2[0]);
if (TymZamestnanceLB.Items.Count > 0 && TymZamestnanceLB.SelectedIndex != -1)
{
zaznam = TymyLB.GetItemText(TymyLB.SelectedItem);
casti = zaznam2.Split(' ');
ID_zamestnance = int.Parse(casti2[0]);
TymZamestnance tz = new TymZamestnance();
tz.ID_zamestnance = ID_zamestnance;
tz.ID_tym = ID_tymu;
TymZamestnanceTable.DeleteJednohoZamestnance(ID_zamestnance, ID_tymu, db);
DateTime DatumTymu = DateTime.Parse(casti2[2]);
NacistVhodneZamestnance(ID_tymu, DatumTymu);
NacistZamestnanceZTymu(ID_tymu);
db.Close();
}
else
{
MessageBox.Show("Nebyl vybrán zaměstnanec, kterého chcete odstranit z týmu");
db.Close();
return;
}
}
else
{
MessageBox.Show("Nebyl vybrán tým, na kterém chcete odebrat zaměstnance");
db.Close();
return;
}
}
private static Collection <TymZamestnance> ReadZamestnance(SqlDataReader reader)
{
Collection <TymZamestnance> tzC = new Collection <TymZamestnance>();
while (reader.Read())
{
int i = -1;
TymZamestnance tz = new TymZamestnance();
tz.ID_zamestnance = reader.GetInt32(++i);
tzC.Add(tz);
}
return(tzC);
}
public static TymZamestnance Select(int id, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@ID_tymZamestnance", id);
SqlDataReader reader = db.Select(command);
Collection <TymZamestnance> tzC = Read(reader);
TymZamestnance tz = null;
if (tzC.Count == 1)
{
tz = tzC[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
if (tz == null)
{
Console.WriteLine("Tym zamestnance neexistuje");
}
return(tz);
}
private static void PrepareCommand(SqlCommand command, TymZamestnance tz)
{
command.Parameters.AddWithValue("@ID_tymZamestnance", tz.ID_tymZamestnance);
command.Parameters.AddWithValue("@ID_zamestnance", tz.ID_zamestnance);
command.Parameters.AddWithValue("@ID_tym", tz.ID_tym);
}
