public MainWindow()
{
//InitializeComponent();
DataBaseEntities db = new DataBaseEntities();
StreamReader reader = new StreamReader("C:\\Users\\Mikhail\\Desktop\\DigitalSkills2017-авиакомпания\\Сессия 1\\UserData.csv");
while (!reader.EndOfStream)
{
User user = new User();
var data = reader.ReadLine().Split(',');
//user.RoleID = db.Roles.FirstOrDefault(i => i.Title == data[0]).ID;
user.Email = data[1];
user.Password = GetHash(data[2]);
user.FirstName = data[3];
user.LastName = data[4];
user.OfficeID = db.Offices.FirstOrDefault(i => i.Title == data[5]).ID;
db.Users.Add(user);
}
db.SaveChangesAsync();
}