private bool PersonCanBeAdded(Person person)
{
if ((!checkBox1.Checked)&&(HasDublicate(person))) return false;
else return true;
}
private bool HasDublicate(Person p)
{
foreach (var item in PersonList)
{
if (item.Equals(p)) return true;
}
return false;
}
public virtual void Insert(Person person)
{
string insert_query = getInsertQuery(person);
ExecuteSqlWithoutResponse(insert_query);
}
public virtual void Delete(Person person)
{
string delete_query = getDeleteQuery(person);
ExecuteSqlWithoutResponse(delete_query);
}
private string getInsertQuery(Person person)
{
string first = person.FirstName;
string last = person.LastName;
int age = person.Age;
return INSERT_FIRTS_PART + ConstructSecondInsertQueryPart(first, last, age);
}
private string getDeleteQuery(Person person)
{
string first = person.FirstName;
string last = person.LastName;
int age = person.Age;
return "DELETE FROM People WHERE first_name='"+first+"' AND last_name='"+last+"' AND age="+age+";";
}
