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); }