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+";"; }