public void UpdateContactPerson(Person p)
{
PersonDAO personDAO = new PersonDAO();
p = personDAO.Update(p);
}
//-----------------------------------------------------------------------------------------------------
public PersonalAssistant insert(PersonalAssistant person)
{
PersonDAO personDao = new PersonDAO();
Person pa = personDao.Insert(person); //returns inserted person with the new ID
person.Id = pa.Id;
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "INSERT INTO persoenlicherassistent (paid,aktiv,abgabedatumunterlagen,SV,Dienstvertrag,BestaetigungBH,Grundkurs,DeadLineWeiterbildung,WeiterbildungsStunden) VALUES (@paid,@aktiv,@datumunterlagen,@SV,@Dienstvertrag,@BH,@Grundkurs,@DeadLineWeiterbildung,@WeiterbildungsStunden)";
//command.CommandText = "INSERT INTO persoenlicherassistent (paid,aktiv) VALUES (@paid,@aktiv)";
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Numeric, command, person.Id);
DB.DBConnector.AddToCommand("@aktiv", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Active);
DB.DBConnector.AddToCommand("@datumunterlagen", NpgsqlTypes.NpgsqlDbType.Date, command, person.ClosingDateDocuments);
DB.DBConnector.AddToCommand("@SV", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.SV);
DB.DBConnector.AddToCommand("@Dienstvertrag", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Dienstvertrag);
DB.DBConnector.AddToCommand("@BH", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.BestBH);
DB.DBConnector.AddToCommand("@Grundkurs", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Grundkurs);
DB.DBConnector.AddToCommand("@DeadLineWeiterbildung", NpgsqlTypes.NpgsqlDbType.Date, command, person.deadLineHours);
DB.DBConnector.AddToCommand("@WeiterbildungsStunden", NpgsqlTypes.NpgsqlDbType.Numeric, command, person.consumedHours);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
PersonalAssistant personOld = new PersonalAssistant();
personOld.Id = person.Id;
this.select(personOld);
if (person.EmploymentTimes != null)
{
foreach (Employment e in person.EmploymentTimes)
{
bool needs_insert = true;
e.EmplId = pa.Id;
if (e.EmplEnd.Year == 1)
{
}
if (personOld.EmploymentTimes != null)
{
foreach (Employment e2 in personOld.EmploymentTimes)
{
if (e.EmplBegin == e2.EmplBegin)
{
needs_insert = false;
}
}
}
if (needs_insert)
{
insertEmployment(e);
}
;
}
}
return(person);
}
