//private IQueryable<Person> person;
public void DoAddData(DateTime date, string name)
{
using (PersonDb db = new PersonDb())
{
Person person = new Person {
Id = 1, Date = date, Name = name
};
db.Persons.Add(person);
db.SaveChanges();
}
}
public List <Person> DoShowData()
{
List <Person> temp = new List <Person>();
using (PersonDb db = new PersonDb())
{
//var person = from t in db.Persons where t.Name.Length > 0 select t;
temp = db.Persons.Where(x => x.Name.Length > 0).ToList();
//foreach(Person t in person)
//{
// temp.Add(t);
//}
}
return(temp);
}
public void DoRemoveData(string name)
{
using (PersonDb db = new PersonDb())
{
foreach (Person man in db.Persons)
{
//if(man.Name == name || man.Id == int.Parse(name) || man.Date == name)
if (man.Name == name || man.Id == int.Parse(name))
{
db.Persons.Remove(man);
}
}
db.SaveChanges();
}
}