public static ContactpersonType VerwerkRij(IDataRecord rij)
{
ContactpersonType type = new ContactpersonType();
type.ID = Convert.ToInt32(rij["ID"].ToString());
type.Name = rij["Name"].ToString();
return type;
}
public static ContactpersonType GetContactPersonTypeByID(int i)
{
ContactpersonType nieuw = new ContactpersonType();
string sql = "SELECT * FROM ContactPersonType WHERE ID like @ID";
DbParameter paramID = Database.AddParameter("@ID", i);
DbDataReader reader = Database.GetData(sql,paramID);
while (reader.Read())
{
nieuw = VerwerkRijSpecial(reader);
}
return nieuw;
}
public static void DeleteType(ContactpersonType SelectedContactPerson)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", SelectedContactPerson.Name);
Database.ModifyData("DELETE FROM ContactPersonType WHERE Name = @Name", paramName);
}
catch (Exception e)
{
throw e;
}
}
public static void AddType(ContactpersonType SelectedContactPerson)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", SelectedContactPerson.Name);
Database.ModifyData("INSERT INTO ContactPersonType (Name) values (@Name)", paramName);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
//ContactpersonType methods
private void AddContactPersonType()
{
ContactpersonType NewType = new ContactpersonType();
ContactPersonTypes.Add(NewType);
SelectedContactPerson = NewType;
}
public static void Editct(ContactpersonType type)
{
try
{
string sql = "UPDATE ContactPersonType SET Name=@name WHERE ID=@ID;";
DbParameter par1 = Database.AddParameter("@name", type.Name);
DbParameter parID = Database.AddParameter("@ID", Convert.ToInt32(type.ID));
Database.ModifyData(sql, par1, parID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
