//Nacitavanie studentov do datagridu private void LoadGrid(StudentSkupina skupina) { try { using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { var students = con.GetTable <Student>().Where(x => x.ID_stud_skupina == skupina.Id).Select(y => new { y.Id, y.Meno, y.Priezvisko, y.ISIC }); if (students.Count() > 0) { StudentGrid.DataSource = students; StudentGrid.Columns["Id"].Visible = false; StudentGrid.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; } else { this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); Logger newLog = new Logger(); newLog.LogError(ex); } }
public Main_Window(StudentSkupina skupina, User user) { MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); try { InitializeComponent(); currentUser = user; studentSkupina = skupina; SendEmailCheck emailCheck = new SendEmailCheck(); emailCheck.AutomatedEmailSending(currentUser); var aTimer = new System.Timers.Timer(60 * 60 * 1000); aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); aTimer.Start(); GetTable(); OnLoadStudent(); CreateBlockedExtensionFile(); } catch (Exception ex) { Logger newLog = new Logger(); newLog.LogError(ex); MessageBox.Show(ex.Message); } }
public FinalGradeForm(User user, StudentSkupina skup) { MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); InitializeComponent(); currentUser = user; group = skup; try { using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { if (con.GetTable <Student>().Where(x => x.ID_stud_skupina == skup.Id).Count() > 0) { CreateFinalGradeOnStart(); LoadGrid(skup); } } } catch (Exception ex) { MessageBox.Show("Uistite sa, že existujú študenti"); Logger logger = new Logger(); logger.LogError(ex); } }
private void CreateBtn_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(GroupNameBox.Text) && GroupNameBox.Text.Length > 3) { using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { var existingGroups = con.GetTable <StudentSkupina>().Where(x => x.Nazov == GroupNameBox.Text && x.Id_User == currentUser.Id); if (existingGroups.Count() > 0) { MessageBox.Show("Skupina s týmto názvom už existuje, prosím zvoľte iný názov skupiny", "Upozornenie", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var newGroup = new StudentSkupina() { Id_User = currentUser.Id, Nazov = GroupNameBox.Text, Forma = (string)FormCombo.SelectedItem }; con.StudentSkupinas.InsertOnSubmit(newGroup); con.SubmitChanges(); } } else { MessageBox.Show("Názov skupiny musí obsahovať viac ako 3 znaky"); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void DeleteWholeGroupData(User currentUser, StudentSkupina currentGroup) { try { UseWaitCursor = true; using (var con = new StudentDBDataContext(conn_str)) { var students = con.GetTable <Student>().Where(x => x.ID_stud_skupina == currentGroup.Id); foreach (var student in students) { var totalAttendance = con.GetTable <TotalAttendance>().Where(x => x.IdStudent == student.Id).FirstOrDefault(); con.TotalAttendances.DeleteOnSubmit(totalAttendance); con.SubmitChanges(); var attendance = con.GetTable <AttendanceStud>().Where(x => x.IDSkupina == group.Id); con.AttendanceStuds.DeleteAllOnSubmit(attendance); con.SubmitChanges(); var tasks = con.GetTable <Task>().Where(x => x.IdStudent == student.Id); con.Tasks.DeleteAllOnSubmit(tasks); con.SubmitChanges(); var activity = con.GetTable <Activity>().Where(x => x.IdStudent == student.Id); con.Activities.DeleteAllOnSubmit(activity); con.SubmitChanges(); var studentId = student.Id; var finalGrade = con.GetTable <FinalGrade>().Where(x => x.IdStudent == studentId); con.FinalGrades.DeleteAllOnSubmit(finalGrade); con.SubmitChanges(); con.Students.DeleteOnSubmit(student); con.SubmitChanges(); } } UseWaitCursor = false; } catch (Exception ex) { MessageBox.Show(ex.ToString()); Logger logger = new Logger(); logger.LogError(ex); } }
public IndividualActivity(User user, StudentSkupina skup) { MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); InitializeComponent(); currUser = user; skupina = skup; GetTableActivity(); }
public Email_Client(User activeUser, StudentSkupina skup) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currentUser = activeUser; group = skup; try { using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { var user = con.GetTable <User>().Where(x => x.Id == currentUser.Id).FirstOrDefault(); var actTempLec = con.GetTable <ActivityTemplate>().Where(x => x.Id == user.PointsForActLec).FirstOrDefault(); var actTempSem = con.GetTable <ActivityTemplate>().Where(x => x.Id == user.PointsForActSem).FirstOrDefault(); ABox.Text = user.AGrade.ToString(); BBox.Text = user.BGrade.ToString(); CBox.Text = user.CGrade.ToString(); DBox.Text = user.DGrade.ToString(); EBox.Text = user.EGrade.ToString(); textBox1.Text = user.ApiKey; textBox2.Text = user.Email; materialMultiLineTextBox1.Text = user.Signature; LoadComboBoxes(activeUser); if (actTempSem != null && comboBox1.Items.Count > 0) { comboBox1.SelectedItem = actTempSem.ActivityName; } if (actTempLec != null && comboBox1.Items.Count > 0) { comboBox2.SelectedItem = actTempLec.ActivityName; } } } catch (Exception ex) { Logger logger = new Logger(); logger.LogError(ex); } }
public Statistics(User user, StudentSkupina skupina) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currentUser = user; currentGroup = skupina; LoadPieCombo(); comboBox1.SelectedIndex = 1; comboBox4.SelectedIndex = 0; }
public AddStudentForm(User user, StudentSkupina skupina) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currUser = user; skup = skupina; try { using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { var students = con.GetTable <Student>().Where(x => x.ID_stud_skupina == skup.Id); if (students.Count() > 0) { var kruzok = from stud in students where stud.ID_stud_skupina == skup.Id select(string) stud.IdGroupForAttendance; kruzok.ToList <string>(); /// Nacitanie existujucich kruzkov do comboboxov foreach (var kruz in kruzok.Distinct()) { if (!GroupAttCombo.Items.Contains(kruz)) { GroupAttCombo.Items.Add(kruz); GroupCombo.Items.Add(kruz); } } } RadioCheck(); } } catch (Exception ex) { Logger logger = new Logger(); logger.LogError(ex); } }
public CreateActivity(User currentUser, StudentSkupina skup) { InitializeComponent(); studentSkup = skup; MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currUser = currentUser; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "HH:mm"; dateTimePicker2.ShowUpDown = true; GetTableActivity(); groupCmbo.SelectedIndex = 0; }
public EmailSendingForm(User user, StudentSkupina skupina) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currentUser = user; currentGroup = skupina; StudentDBDataContext con = new StudentDBDataContext(conn_str); var students = con.GetTable <Student>(); var groups = con.GetTable <StudentSkupina>().Where(x => x.Id == skupina.Id); var skup = from student in students where student.ID_stud_skupina == currentGroup.Id select new { student.Meno, student.Email, student.Priezvisko, student.Email_UCM }; var columnWidth = new int[] { 100, 120 }; autocompleteMenu1.MaximumSize = new System.Drawing.Size(250, 200); foreach (var student in skup) { autocompleteMenu1.AddItem(new MulticolumnAutocompleteItem(new[] { RWS(student.Meno) + " " + RWS(student.Priezvisko), RWS(student.Email) }, RWS(student.Email)) { ColumnWidth = columnWidth }); autocompleteMenu1.AddItem(new MulticolumnAutocompleteItem(new[] { "", RWS(student.Email_UCM) }, RWS(student.Email_UCM)) { ColumnWidth = columnWidth }); } var kruzok = from stud in students where stud.ID_stud_skupina == skupina.Id select(string) stud.ID_Kruzok; kruzok.ToList <string>(); foreach (var kruz in kruzok.Distinct()) { GroupComboEmail.Items.Add(kruz); } autocompleteMenu1.Enabled = true; autocompleteMenu1.AllowsTabKey = true; }
public GradeActivityForm(StudentSkupina grp, Student stud, Activity activ) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); currGroup = grp; currStud = stud; currActivity = activ; NewActivityTab(currActivity); NewTaskTab(currActivity, currStud); var width = MaterialTabCOntrol.Controls.Count * 50; Drawer.Size = new Size(250, width); }
// Otvorenie inej skupiny v rámci skupín používateľa private void Open_Btn_Click(object sender, EventArgs e) { try { var choose = new Choose_Group(currentUser); DialogResult result = choose.ShowDialog(); if (result == DialogResult.Yes) { studentSkupina = choose.GetGroup(); } Student_Grid.DataSource = null; Activity_Grid.DataSource = null; GetTable(); GetActivities(); } catch (Exception ex) { Logger logger = new Logger(); logger.LogError(ex); } }
public Dochádzka(StudentSkupina studentSkupina) { InitializeComponent(); MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.EnforceBackcolorOnAllComponents = false; skinManager.AddFormToManage(this); skinManager.Theme = MaterialSkin.MaterialSkinManager.Themes.LIGHT; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Primary.BlueGrey500, MaterialSkin.Accent.Blue400, MaterialSkin.TextShade.WHITE); StudentSkup = studentSkupina; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "HH:mm"; dateTimePicker2.ShowUpDown = true; //Pritomnost comboBox2.Items.Add("Prítomný"); comboBox2.Items.Add("Neprítomný"); comboBox2.Items.Add("Ospravedlnené"); comboBox2.Items.Add("Zrušené"); //Filter combobox comboBox4.Items.Add("Posledný deň"); comboBox4.Items.Add("Všetka dochádzka"); comboBox4.Items.Add("Dátum"); comboBox4.Items.Add("Status"); comboBox4.Items.Add("Krúžok"); comboBox4.Items.Add("Študent"); comboBox2.DropDownStyle = ComboBoxStyle.DropDownList; comboBox2.SelectedItem = comboBox2.Items[0]; comboBox1.DropDownStyle = ComboBoxStyle.DropDownList; comboBox4.SelectedItem = comboBox4.Items[0]; using (StudentDBDataContext con = new StudentDBDataContext(conn_str)) { var students = con.GetTable <Student>(); var groups = con.GetTable <StudentSkupina>().Where(x => x.Id == StudentSkup.Id); var skup = from student in students where student.ID_stud_skupina == StudentSkup.Id select new { student.Meno, student.Priezvisko, student.Id }; var kruzok = from stud in students where stud.ID_stud_skupina == StudentSkup.Id select(string) stud.ID_Kruzok; foreach (var stud in students.Where(x => x.ID_stud_skupina == StudentSkup.Id)) { comboBox3.Items.Add(RWS(stud.Meno) + " " + RWS(stud.Priezvisko)); studentsManual.Add(RWS(stud.Meno) + " " + RWS(stud.Priezvisko), stud.Id); } //Pridanie kruzkov do comboboxu var studs = con.GetTable <Student>(); kruzok.ToList <string>(); comboBox1.Items.Add("Všetky"); foreach (var kruz in kruzok.Distinct()) { comboBox1.Items.Add(kruz); } } comboBox1.SelectedItem = comboBox1.Items[0]; Filter(); }
public void Querys(StudentSkupina skupina) { try { group = skupina; var path = SelectPath(); if (path != "Cancel") { if ((File.GetAttributes(path) & FileAttributes.ReadOnly) > 0) { MessageBox.Show("Excel súbor je iba na čítanie"); return; } string constr = ExcelConnection(path); var excelCon = new OleDbConnection(constr); OleDbCommand Ecom = new OleDbCommand(query, excelCon); excelCon.Open(); DataSet excelDataSet = new DataSet(); OleDbDataAdapter adapter = new OleDbDataAdapter(query, excelCon); adapter.Fill(excelDataSet); excelCon.Close(); DataTable excelDataTable = excelDataSet.Tables[0]; for (int i = excelDataTable.Rows.Count - 1; i >= 0; i--) { if ((string)excelDataTable.Rows[i].ItemArray[5] == "A") { didntHappened = true; notAddedStuds.Add(i + 7); excelDataTable.Rows[i].Delete(); } } excelDataTable.AcceptChanges(); using (var con = new StudentDBDataContext(conn)) { for (int i = 0; i <= excelDataTable.Rows.Count - 1; i++) { var form = (string)excelDataTable.Rows[i].ItemArray[2]; if (form.ElementAt(form.Length - 3) == 'D' && !skupina.Forma.Contains("Denná") || form.ElementAt(form.Length - 3) == 'E' && !skupina.Forma.Contains("Externá")) { didntHappened = false; warnUser = true; continue; } string isic = null; if (!string.IsNullOrEmpty((string)excelDataTable.Rows[i].ItemArray[5])) { isic = excelDataTable.Rows[i].ItemArray[5].ToString().Remove(0, 5); } Student students = new Student { Meno = excelDataTable.Rows[i].ItemArray[0].ToString(), Priezvisko = excelDataTable.Rows[i].ItemArray[1].ToString(), Stud_program = excelDataTable.Rows[i].ItemArray[2].ToString(), ID_stud_skupina = skupina.Id, ID_Kruzok = excelDataTable.Rows[i].ItemArray[3].ToString(), IdGroupForAttendance = excelDataTable.Rows[i].ItemArray[3].ToString(), Email = excelDataTable.Rows[i].ItemArray[8].ToString(), Email_UCM = excelDataTable.Rows[i].ItemArray[7].ToString(), Rocnik = Convert.ToInt32(excelDataTable.Rows[i].ItemArray[6]), ISIC = isic, Forma = skupina.Forma }; if (!Exists(students)) { con.Students.InsertOnSubmit(students); con.SubmitChanges(); } else { continue; } } ; if (warnUser == true) { MessageBox.Show("Nie je možné pridávať študentov externej formy do skupiny určenej pre denných študentov.", "Upozornenie"); } if (notAddedStuds.Count >= 1 && didntHappened == true) { string warning = $"Študenti z tabuľky na pozíciach" + " " + string.Join(string.Empty, notAddedStuds.ToArray()) + " " + "neboli pridaný"; MessageBox.Show(warning); } } } else { return; } } catch (Exception ex) { if (ex.Message == "External table is not in the expected format.") { MessageBox.Show("Otvorte súbor manuálne a skúste znovu importovať. Ak sa chyba opakuje, je nutné súbor znovu uložiť ako .xlsx", "Chyba pri načítaní súboru", MessageBoxButtons.OK); return; } else { Logger logger = new Logger(); logger.LogError(ex); MessageBox.Show("Vybrali ste nesprávny súbor alebo štruktúra súboru je chybná", "Chyba pri načítaní súboru", MessageBoxButtons.OK); } } }