public Person GetById(int Id)
{
Person person = null;
using (var db = new HW7DBworkDB())
{
person = db.Persons.FirstOrDefault(p => p.Id == Id);
}
return(person);
}
public List <Person> GetAllPersons()
{
var persons = new List <Person>();
using (var db = new HW7DBworkDB())
{
persons = db.Persons.ToList();
}
return(persons);
}
public Person Edit(int Id, Person newPerson)
{
Person person = null;
using (var db = new HW7DBworkDB())
{
var prs = newPerson;
person = db.Persons.Where(p => p.Id == Id).First();
person.Name = prs.Name;
person.Email = prs.Email;
person.PhoneNumber = prs.PhoneNumber;
db.SaveChanges();
}
return(person);
}
public void ImportFromCSVToDataBase(string fileName)
{
var persons = ImportFromCSV(fileName);
var rnd = new Random();
int offset = rnd.Next(100, 500);
for (int i = 0; i < persons.Count; i += offset)
{
using (var db = new HW7DBworkDB())
{
for (int j = i; j < offset + i; j++)
{
foreach (var person in persons)
{
db.Persons.Add(person);
}
}
db.SaveChanges();
}
}
}
