public void Load()
{
SqlConnection con = new SqlConnection(VERBINDUNG);
string sql = "Select * from responsiblePerson";
con.Open();
SqlCommand com = new SqlCommand(sql, con);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
ResponsiblePerson responsiblePerson = new ResponsiblePerson();
responsiblePerson.PersonID = (int)reader.GetValue(0);
responsiblePerson.Name = reader.GetValue(1).ToString();
responsiblePerson.OfficeNumber = reader.GetValue(2).ToString();
responsiblePerson.Department = reader.GetValue(3).ToString();
Instance.AddResponsiblePerson(responsiblePerson);
}
reader.Close();
com.Dispose();
con.Close();
}
public void Save(ResponsiblePerson responsiblePerson)
{
SqlConnection con = new SqlConnection(VERBINDUNG);
con.Open();
SqlCommand com = new SqlCommand();
string sql = $"Insert into responsiblePerson values ('{responsiblePerson.Name}', '{responsiblePerson.OfficeNumber}', '{responsiblePerson.Department}')";
com = new SqlCommand(sql, con);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = com;
adapter.InsertCommand.ExecuteNonQuery();
com.Dispose();
con.Close();
}
public void Change(ResponsiblePerson r, bool[] geandert)
{
SqlConnection con = new SqlConnection(VERBINDUNG);
con.Open();
string sql = $@"Update responsiblePerson set {(geandert[0] ? $"PersonName = '{r.Name}'" : "")}{((geandert[0] && geandert[1] | geandert[2]) ? "," : "")}" +
$"{(geandert[1] ? $"OfficeNumber = '{r.OfficeNumber}'" : "")}{((geandert[1] && geandert[2]) ? "," : "")}" +
$"{ (geandert[2] ? $"Department = '{r.Department}'" : "")}{((geandert[2]) ? "," : "")} where PersonID = '{r.PersonID}'";
SqlCommand com = new SqlCommand(sql, con);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.UpdateCommand = com;
adapter.UpdateCommand.ExecuteNonQuery();
com.Dispose();
con.Close();
}
public void RemoveResponsiblePerson(ResponsiblePerson responsiblePerson)
{
persons.Remove(responsiblePerson);
}
public void AddResponsiblePerson(ResponsiblePerson responsiblePerson)
{
persons.Add(responsiblePerson);
}