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(); }