private void buttonFind_Click(object sender, EventArgs e) { listBoxResultFound.Items.Clear(); using (var db = new UsersData()) { var subQuerry1 = (from c in db.Certificates where c.Name==listBoxCertificateFound.Text select c.ID).ToList()[0]; var subQuerry2 = (from r in db.Relations where r.CertificateID == subQuerry1 select r.UserID).ToList(); if (subQuerry2.Count == 0) { MessageBox.Show("Працівників з таким сертифікатом не знайдено."); } else { for (int i = 0; i < subQuerry2.Count; i++) { var temp = subQuerry2[i]; var query = from u in db.Users where u.ID == temp select u.Name; foreach (var item2 in query) { this.listBoxResultFound.Items.Add(item2); } } } } }
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(); } }
public Form2() { InitializeComponent(); using (var db = new UsersData()) { var query = from c in db.Certificates select c.Name; foreach (var item in query) { listBoxCertificateFound.Items.Add(item); } listBoxCertificateFound.Width = 80; listBoxCertificateFound.Height = 80; listBoxResultFound.Width = 80; listBoxResultFound.Height = 80; } }
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(); }
private void textBoxCertificate_TextChanged(object sender, EventArgs e) { if (this.textBoxCertificate.Text != string.Empty) { for (int i = 0; i < listListsBox.Count; i++) { this.Controls.Remove(listListsBox[i]); } listListsBox.Clear(); int x = 20; int y = 200; int inter = 0; for (int i = 0; i < Convert.ToInt32(this.textBoxCertificate.Text); i++) { ListBox newListBox = new ListBox(); if (inter == 5) { y += 80; x = 20; inter = 0; } newListBox.Location = new Point(x + inter * 150, y); inter++; using (var db = new UsersData()) { var query = from c in db.Certificates select c.Name; foreach (var item in query) { newListBox.Items.Add(item); } } newListBox.Width = 80; newListBox.Height = 80; listListsBox.Add(newListBox); this.Controls.Add(newListBox); } } }