private async void UIset(Student fst) { lblName.Text = fst.FullName; lblSchoolAndNo.Text = $"{fst.School} - {fst.SchoolCode}"; //EschoolKe Secondary - 20154245 lblMOL.Text = $"Mode of Learning - {fst.LearningMode}"; //Mode of Learning - Bording lblRegno.Text = $"Reg NO - {fst.Regno}"; //Reg NO - 17052 //look for data on discpline Disciplinary mDis = null; List <Disciplinary> studdis = await Task.Factory.StartNew(() => { using (var context = new SmartdbEntities()) { return(context.Disciplinaries .Where(x => x.Regno == fst.Regno) .ToList()); } }); //latest case mDis = studdis.OrderBy(x => x.Id).LastOrDefault(); if (mDis != null) { tbLegalInfo.Text = mDis.Details; SetUpDrops(mDis); } UpdateCharts(studdis); //charts consume this data }
private void btnSave_Click(object sender, EventArgs e) { if (this.gData.Rows.Count == -1) { alert.Show("No data to save ....", alert.AlertType.info); } alert.Show("Saving ....", alert.AlertType.info); using (var context = new SmartdbEntities()) { for (int i = 0; i < this.gData.Rows.Count - 1; i++) { DataGridViewRow dr = gData.Rows[i]; if (dr != null && (dr.Cells["RegNo"].Value != null) && (dr.Cells["FullName"].Value != null)) { try { context.Students.Add(new Student { //check for duplicate Admin number Regno = dr.Cells["RegNo"].Value.ToString(), FullName = dr.Cells["FullName"].Value.ToString(), School = dr.Cells["School"].Value.ToString(), SchoolCode = dr.Cells["SchoolCode"].Value.ToString(), LearningMode = dr.Cells["LearningMode"].Value.ToString(), }); } catch (Exception) { MessageBox.Show("Check all entries are correct and retry", "Error"); // throw; } } else { MetroMessageBox.Show(this, "Critical error contact developer immediately \n :( :( :( :( :( :(:( :( ", "Read Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } try { context.SaveChanges(); alert.Show("Saved Successfully", alert.AlertType.success); } catch (Exception) { } } this.Close(); }
private async void Home_Load(object sender, EventArgs e) { SetToolTip(tbLegalInfo, $"Info: \n Keywords like Good, bad, improving, indisciplined, positive, questionable \n are being tracked to determine overall discipline"); List <Student> studs = await Task.Factory.StartNew(() => { using (var context = new SmartdbEntities()) { return(context.Students.OrderBy(c => c.Regno) .ToList()); } }); //first student in db default currentStudent = studs.FirstOrDefault(); //chart updates auto UIset(currentStudent); }
private async Task <Student> StudFoundAsync(string regno) { var studentList = await Task.Factory.StartNew(() => { using (var context = new SmartdbEntities()) { return(context.Students.ToList()); } }); foreach (var stud in studentList.Where(a => a.Regno.Equals(regno))) { if (regno == stud.Regno) { return(stud); } } return(null); }
private void button1_Click(object sender, EventArgs e) { //verification if (currentStudent == null) { alert.Show("Required info \n Search for Student", alert.AlertType.warnig); return; } if (disAction == 0 & disLevel == 0) { alert.Show("Required info \n Select provided options", alert.AlertType.warnig); return; } //save the current student info using (var context = new SmartdbEntities()) { Disciplinary dd = new Disciplinary(); dd.Regno = currentStudent.Regno; dd.Action = dropAction.selectedValue.ToString(); dd.Details = tbLegalInfo.Text; dd.level = (disAction + disLevel); try { context.Disciplinaries.Add(dd); context.SaveChanges(); alert.Show("Saved Successfully", alert.AlertType.success); //set ui again UIset(currentStudent); } catch (Exception) { throw; } } }
private async void tab2_Click(object sender, EventArgs e) { //prompt add student FrmAddStud ff = new FrmAddStud(); if (ff.ShowDialog() == DialogResult.OK) { List <Student> studs = await Task.Factory.StartNew(() => { using (var context = new SmartdbEntities()) { return(context.Students.OrderBy(c => c.Regno) .ToList()); } }); //first student in db default currentStudent = studs.LastOrDefault(); //chart updates auto UIset(currentStudent); } }