public void AddCertificates()
{
string line = "";
using (var database = new UsersData())
{
StreamReader reader = new StreamReader(@"c:\users\mykola\documents\visual studio 2012\Projects\Task4\Task4\in.txt");
while ((line = reader.ReadLine()) != null)
{
Certificate certificate = new Certificate { Name = line };
database.Certificates.Add(certificate);
database.SaveChanges();
}
reader.Close();
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
using (var db = new UsersData())
{
for (int i = 0; i < amount; i++)
{
var user = new User { Name = this.dataGridViewUsersInfo.Rows[i].Cells[0].Value.ToString(), Post = this.dataGridViewUsersInfo.Rows[i].Cells[1].Value.ToString() };
db.Users.Add(user);
db.SaveChanges();
string[] arr = this.dataGridViewUsersInfo.Rows[i].Cells[2].Value.ToString().Split(new char[] {' ', ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < arr.Length; j++)
{
var temp = arr[j];
var query = (from c in db.Certificates
where c.Name == temp
select c.ID).ToList()[0];
var relation = new Relation { UserID = user.ID, CertificateID = query};
db.Relations.Add(relation);
db.SaveChanges();
}
}
}
this.dataGridViewUsersInfo.Rows.Clear();
this.dataGridViewUsersInfo.Columns.Clear();
DataGridInit();
}