//Een contactpersoon verwijderen
public static int DeleteContactperson(Contactperson cp)
{
try
{
String sSQL = "DELETE FROM Contactperson WHERE Id=@Id";
DbParameter par1 = Database.AddParameter("@Id", cp.Id);
if (par1.Value == null) par1.Value = DBNull.Value;
DbParameter[] pars = new DbParameter[] { par1 };
int affected = Database.ModifyData(sSQL, pars);
return affected;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
}
//Een bestaand contact bewerken
public static int EditContact(Contactperson c)
{
try
{
String sSQL = "Update Contactperson Set Name=@Name,JobRole=@JobRole,Email=@Email,Phone=@Phone WHERE ID=@ID";
DbParameter par1 = Database.AddParameter("@Name", c.Name);
if (par1.Value == null) par1.Value = DBNull.Value;
DbParameter par2 = Database.AddParameter("@JobRole", c.JobRole.Id);
if (par2.Value == null) par2.Value = DBNull.Value;
DbParameter par3 = Database.AddParameter("@ID", c.Id);
if (par3.Value == null) par3.Value = DBNull.Value;
DbParameter par4 = Database.AddParameter("@Email", c.Email);
if (par4.Value == null) par4.Value = DBNull.Value;
DbParameter par5 = Database.AddParameter("@Phone", c.Phone);
if (par5.Value == null) par5.Value = DBNull.Value;
DbParameter[] pars = new DbParameter[] { par1, par2, par3, par4, par5 };
int affected = Database.ModifyData(sSQL, pars);
return affected;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
}
//Een nieuw contactpersoon toevoegen in database
public static int AddContactperson(Contactperson cp)
{
try
{
String sSQL = "INSERT INTO Contactperson(Name, Jobrole, Email, Phone) VALUES(@Name, @JobRole, @Email, @Phone)";
DbParameter par1 = Database.AddParameter("@Name", cp.Name);
if (par1.Value == null) par1.Value = DBNull.Value;
DbParameter par2 = Database.AddParameter("@JobRole", cp.JobRole.Id);
if (par2.Value == null) par2.Value = DBNull.Value;
DbParameter par3 = Database.AddParameter("@Email", cp.Email);
if (par3.Value == null) par3.Value = DBNull.Value;
DbParameter par4 = Database.AddParameter("@Phone", cp.Phone);
if (par4.Value == null) par4.Value = DBNull.Value;
DbParameter[] pars = new DbParameter[] { par1, par2, par3, par4 };
int affected = Database.ModifyData(sSQL, pars);
return affected;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
}