private void LoadTabGroup(FacultyInfo faculty) { Status.Text = "Загрузка вкладок для групп"; Application.DoEvents(); Group.Selected -= Tab_Selected; Group.TabPages.Clear(); Group.Selected += Tab_Selected; var list = new List <GroupInfo>(Model.GetGroupFromFaculty(faculty)); list.Sort(new Model.MyComparerName().Compare); ProgressBar.Value = 0; ProgressBar.Maximum = list.Count; foreach (var i in list) { ProgressBar.PerformStep(); var tabPage = new ExtendedTabPage(i.ToString()) { Tag = i, Name = i.Name, UseVisualStyleBackColor = true }; Group.TabPages.Add(tabPage); } Status.Text = "Готово"; ProgressBar.Value = 0; Application.DoEvents(); }
public static string GetGroupIDPartial(string name, FacultyInfo fac) { var g = (from t in Db.Group where t.Name.ToUpper().StartsWith(name.ToUpper()) && t.ID_Faculty == fac.ID_Faculty select t).FirstOrDefault(); return(g != null ? g.Name : null); }
public static GroupInfo[] GetGroupFromFaculty(FacultyInfo faculy) { var group = from g in Db.Group where g.ID_Faculty == faculy.ID_Faculty select new GroupInfo(g); return(group.ToArray()); }
public static void Faculty(FacultyInfo faculty) { foreach (GroupInfo f in GetGroupFromFaculty(faculty)) { Group(f); } Db.Faculty.RemoveFacultyRow(Db.Faculty.Single(a => a.ID_Faculty == faculty.ID_Faculty)); Db.AcceptChanges(); }
public static void Faculty(FacultyInfo faculty, string newValue) { var fac = (from a in Db.Faculty where a.ID_Faculty == faculty.ID_Faculty select a).Single(); fac.Name = newValue; Db.AcceptChanges(); }
public static void Group(string str, FacultyInfo faculty, EducationInfo edu) { var temp = Db.Group.NewGroupRow(); temp.Name = str; temp.ID_Education = edu.ID_Education; temp.ID_Faculty = faculty.ID_Faculty; Db.Group.AddGroupRow(temp); Db.AcceptChanges(); }
public static GroupInfo[] GetGroupFromFacultyAndKurs(FacultyInfo facultyInfo, int kurs) { GroupInfo[] temp; try { temp = (from a in Db.Group where a.ID_Faculty == facultyInfo.ID_Faculty where Convert.ToInt32(a.Name.Substring(a.Name.Length - 2, 1)) == kurs select new GroupInfo(a)).ToArray(); } catch (Exception) { return(null); } return(temp); }
private void LoadTabGroup(FacultyInfo faculty) { Status.Text = "Загрузка вкладок для групп"; Application.DoEvents(); Group.Selected -= Tab_Selected; Group.TabPages.Clear(); Group.Selected += Tab_Selected; var list = new List<GroupInfo>(Model.GetGroupFromFaculty(faculty)); list.Sort(new Model.MyComparerName().Compare); ProgressBar.Value = 0; ProgressBar.Maximum = list.Count; foreach (var i in list) { ProgressBar.PerformStep(); var tabPage = new ExtendedTabPage(i.ToString()) { Tag = i, Name = i.Name, UseVisualStyleBackColor = true }; Group.TabPages.Add(tabPage); } Status.Text = "Готово"; ProgressBar.Value = 0; Application.DoEvents(); }
public int Compare(FacultyInfo a, FacultyInfo b) { return(a.Name.CompareTo(b.Name)); }