private void занестиВБДToolStripMenuItem_Click(object sender, EventArgs e) { dbBRSEntities ContextDB = new dbBRSEntities(); List <string> Disciplins = new List <string>(); List <string> Prepods = new List <string>(); Dictionary <string, string> Students = new Dictionary <string, string>(); List <string> Grupps = new List <string>(); List <string> Facultets = new List <string>(); List <string> Profiles = new List <string>(); progressBar1.Value = 0; progressBar1.Minimum = 0; progressBar1.Maximum = c1FlexGridItogTable.Rows.Count; //получение даннхы из таблицы for (int i = 0; i < c1FlexGridItogTable.Rows.Count; i++) { if (Facultets.Contains(c1FlexGridItogTable[i, 0].ToString())) { } else { Facultets.Add(c1FlexGridItogTable[i, 0].ToString()); } if (Profiles.Contains(c1FlexGridItogTable[i, 9].ToString())) { } else { Profiles.Add(c1FlexGridItogTable[i, 9].ToString()); } if (Grupps.Contains(c1FlexGridItogTable[i, 1].ToString())) { } else { Grupps.Add(c1FlexGridItogTable[i, 1].ToString()); } if (Disciplins.Contains(c1FlexGridItogTable[i, 2].ToString())) { } else { Disciplins.Add(c1FlexGridItogTable[i, 2].ToString()); } if (Prepods.Contains(c1FlexGridItogTable[i, 6].ToString())) { } else { Prepods.Add(c1FlexGridItogTable[i, 6].ToString()); } if (Students.ContainsKey(c1FlexGridItogTable[i, 7].ToString())) { } else { Students.Add(c1FlexGridItogTable[i, 7].ToString(), c1FlexGridItogTable[i, 8].ToString()); } progressBar1.Value++; } progressBar1.Value = 0; progressBar1.Maximum = 100; //занесение данных ContextDB.tableRoles.Add(new tableRoles { Name = "Admin" }); ContextDB.tableRoles.Add(new tableRoles { Name = "Teacher" }); ContextDB.tableRoles.Add(new tableRoles { Name = "Student" }); ContextDB.SaveChanges(); foreach (var f in Facultets) { ContextDB.tableFacultet.Add(new tableFacultet { Name = f.ToString() }); } try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 10; foreach (var p in Profiles) { ContextDB.tableProfile.Add(new tableProfile { Name = p.ToString() }); } try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 20; foreach (var g in Grupps) { string facultName = ""; for (int i = 0; i < c1FlexGridItogTable.Rows.Count; i++) { if (c1FlexGridItogTable[i, 1].ToString() == g.ToString()) { facultName = c1FlexGridItogTable[i, 0].ToString(); break; } } string profileName = ""; for (int i = 0; i < c1FlexGridItogTable.Rows.Count; i++) { if (c1FlexGridItogTable[i, 1].ToString() == g.ToString()) { profileName = c1FlexGridItogTable[i, 9].ToString(); break; } } int FacultID = (from f in ContextDB.tableFacultet where f.Name == facultName select f.ID).First(); int ProfileID = (from f in ContextDB.tableProfile where f.Name == profileName select f.ID).First(); ContextDB.tableGrupp.Add(new tableGrupp { Name = g.ToString(), IDFacultet = FacultID, IDProfile = ProfileID }); } progressBar1.Value = 30; try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 40; foreach (var d in Disciplins) { ContextDB.tableDisciplin.Add(new tableDisciplin { Name = d.ToString() }); } try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 50; foreach (var s in Students) { string gruppName = ""; for (int i = 0; i < c1FlexGridItogTable.Rows.Count; i++) { if (c1FlexGridItogTable[i, 8].ToString() == s.Value.ToString()) { gruppName = c1FlexGridItogTable[i, 1].ToString(); break; } } int gruppID = (from g in ContextDB.tableGrupp where g.Name == gruppName select g.ID).First(); string nomerZachetki = s.Key; ContextDB.tableStudents.Add(new tableStudents { Name = s.Value, NomerZachetki = nomerZachetki, ID_Gruppi = gruppID, DopuskKSessii = 1 }); } ContextDB.SaveChanges(); progressBar1.Value = 60; foreach (var p in Prepods) { ContextDB.tablePrepods.Add(new tablePrepods { Name = p.ToString() }); } try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 70; //принадлежность дисциплин var pdis = from pd in ContextDB.tableDisciplin select pd; progressBar1.Value = 0; progressBar1.Maximum = pdis.Count(); foreach (var pd in pdis) { foreach (var grup in Grupps) { for (int i = 0; i < c1FlexGridItogTable.Rows.Count; i++) { if (c1FlexGridItogTable[i, 2].ToString() == pd.Name && grup == c1FlexGridItogTable[i, 1].ToString()) { ModelGruppi gruppaID = (from g in ContextDB.tableGrupp where g.Name == grup select new ModelGruppi { GruppaID = g.ID, FacultetID = g.IDFacultet, GruppaName = g.Name }).First(); string gr2 = c1FlexGridItogTable[i, 6].ToString(); int idPrepod = (from p in ContextDB.tablePrepods where p.Name == gr2 select p.ID).First(); int otchetnost = int.Parse(c1FlexGridItogTable[i, 3].ToString()); int KR_KP = int.Parse(c1FlexGridItogTable[i, 4].ToString()); int chasiDisciplini = int.Parse(c1FlexGridItogTable[i, 5].ToString()); ContextDB.tablePrinadlegnistDisciplin.Add(new tablePrinadlegnistDisciplin { ID_Facultet = gruppaID.FacultetID, ID_Gruppi = gruppaID.GruppaID, ID_Disciplini = pd.ID, ID_Prepoda = idPrepod, Otchetnost = otchetnost, KR_KP = KR_KP, ChasiDisciplini = chasiDisciplini }); break; } } } progressBar1.Value++; } progressBar1.Maximum = 100; progressBar1.Value = 80; try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 90; //баллы var balli = from s in ContextDB.tableStudents from pd in ContextDB.tablePrinadlegnistDisciplin where s.ID_Gruppi == pd.ID_Gruppi select new modelBalli { ID_Gruppi = s.ID_Gruppi, ID_Disciplini = pd.ID_Disciplini, ID_prepoda = pd.ID_Prepoda, ID_Studenta = s.ID }; progressBar1.Maximum = balli.Count(); progressBar1.Value = 0; foreach (var tb in balli) { ContextDB.tableBalli.Add(new tableBalli { ID_Gruppi = tb.ID_Gruppi, ID_Disciplini = tb.ID_Disciplini, ID_prepoda = tb.ID_prepoda, ID_Studenta = tb.ID_Studenta, Pos1 = 0, Tek1 = 0, Rub1 = 0, Pos2 = 0, Tek2 = 0, Rub2 = 0, Samost = 0, Dosdacha = 0, Premial = 0, Itog = 0 }); progressBar1.Value++; } progressBar1.Value = 90; progressBar1.Maximum = 100; try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 95; // учетки преподов var prepods = from p in ContextDB.tablePrepods select p; Translit trans = new Translit(); foreach (var p in prepods) { string Login = trans.TranslitFileName(p.Name); string Parol = trans.GenPassword(p.Name).Substring(trans.GenPassword(p.Name).Length / 2); if (Login.Length > 16) { Login = Login.Substring(0, 16); } if (Parol.Length > 8) { Parol = Parol.Substring(0, 8); } int Rol = 2; ContextDB.teachersAccounts.Add(new teachersAccounts { Role_ID = Rol, ID_Prepoda = p.ID, Login = Login, Password = Parol }); } try { ContextDB.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } progressBar1.Value = 100; MessageBox.Show("Занесение данных успешно закончено!"); }
private void удалитьВсеЗаписиToolStripMenuItem_Click(object sender, EventArgs e) { dbBRSEntities contextDB = new dbBRSEntities(); progressBar1.Value = 0; progressBar1.Maximum = 100; //удаление студентов var balli = from s in contextDB.tableBalli select s; foreach (var s in balli) { contextDB.tableBalli.Remove(s); } contextDB.SaveChanges(); progressBar1.Value = 10; var pos = from p in contextDB.tablePoseshenie select p; foreach (var p in contextDB.tablePoseshenie) { contextDB.tablePoseshenie.Remove(p); } contextDB.SaveChanges(); progressBar1.Value = 20; var zan = from z in contextDB.tableZanyatiy select z; foreach (var z in contextDB.tableZanyatiy) { contextDB.tableZanyatiy.Remove(z); } contextDB.SaveChanges(); progressBar1.Value = 30; //удаление студентов var students = from s in contextDB.tableStudents select s; foreach (var s in students) { contextDB.tableStudents.Remove(s); } contextDB.SaveChanges(); progressBar1.Value = 40; // var pd = from p in contextDB.tablePrinadlegnistDisciplin select p; foreach (var p in pd) { contextDB.tablePrinadlegnistDisciplin.Remove(p); } contextDB.SaveChanges(); progressBar1.Value = 50; //удаление групп var grupps = from g in contextDB.tableGrupp select g; foreach (var g in grupps) { contextDB.tableGrupp.Remove(g); } contextDB.SaveChanges(); progressBar1.Value = 60; //удаление профилей var prof = from f in contextDB.tableProfile select f; foreach (var f in prof) { contextDB.tableProfile.Remove(f); } contextDB.SaveChanges(); //----- progressBar1.Value = 70; //------- var admins = from f in contextDB.tableAdmins select f; foreach (var f in admins) { contextDB.tableAdmins.Remove(f); } contextDB.SaveChanges(); // //------ progressBar1.Value = 80; //удаление var fac = from f in contextDB.tableFacultet select f; foreach (var f in fac) { contextDB.tableFacultet.Remove(f); } contextDB.SaveChanges(); // progressBar1.Value = 90; //удаление var techac = from t in contextDB.teachersAccounts select t; foreach (var t in techac) { contextDB.teachersAccounts.Remove(t); } contextDB.SaveChanges(); progressBar1.Value = 95; var prep = from p in contextDB.tablePrepods select p; foreach (var p in prep) { contextDB.tablePrepods.Remove(p); } contextDB.SaveChanges(); progressBar1.Value = 98; //удаление var dis = from d in contextDB.tableDisciplin select d; foreach (var d in dis) { contextDB.tableDisciplin.Remove(d); } contextDB.SaveChanges(); progressBar1.Value = 100; progressBar1.Value = 0; }