public void SaveContactperson()
{
try
{
string sql = "INSERT INTO Contactpersonen(Name, FirstName, Gender, Birthdate, Company, Street,City,Phone,Cellphone,Email,ContactpersoontypeID,Number) ";
sql += "VALUES (@Name,@FirstName,@Gender,@Birthdate,@Company,@Street,@City,@Phone,@Cellphone,@Email,@JobRole,@Number)";
DbParameter parName = Database.AddParameter("@Name", SelectedContactperson.Name);
DbParameter parFirstName = Database.AddParameter("@FirstName", SelectedContactperson.FirstName);
DbParameter parGender = Database.AddParameter("@Gender", SelectedContactperson.Gender);
DbParameter parBirthdate = Database.AddParameter("@Birthdate", SelectedContactperson.BirthDate);
DbParameter parCompany = Database.AddParameter("@Company", SelectedContactperson.Company);
DbParameter parStreet = Database.AddParameter("@Street", SelectedContactperson.Street);
DbParameter parCity = Database.AddParameter("@City", SelectedContactperson.City);
DbParameter parPhone = Database.AddParameter("@Phone", SelectedContactperson.Phone);
DbParameter parCellphone = Database.AddParameter("@Cellphone", SelectedContactperson.Cellphone);
DbParameter parEmail = Database.AddParameter("@Email", SelectedContactperson.Email);
DbParameter parNumber = Database.AddParameter("@Number", SelectedContactperson.Number);
DbParameter parJobRole = Database.AddParameter("@JobRole", SelectedContactperson.JobRole.ID);
Database.ModifyData(sql, parName, parFirstName, parGender, parBirthdate, parCompany, parStreet, parCity, parPhone, parCellphone, parEmail, parNumber, parJobRole);
ContactpersonList.Add(SelectedContactperson);
ContactpersonList = Contactperson.GetContactpersons();
MessageBox.Show("Contactpersoon werd succesvol toegevoegd");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void DeleteContactperson()
{
if (SelectedContactperson != null)
{
try
{
string sql = "DELETE FROM contactpersonen WHERE ID=@id";
DbParameter par = Database.AddParameter("@id", SelectedContactperson.ID);
Database.ModifyData(sql, par);
ContactpersonList.Remove(SelectedContactperson);
MessageBox.Show("Contactpersoon werd succesvol verwijderd");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
