private void Signup_Click(object sender, RoutedEventArgs e) { try { WPFLIBDATABASEEntities dbe = new WPFLIBDATABASEEntities(); if (signidtxt.Text != string.Empty || signpasstxt.Password != string.Empty || signconpasstxt.Password != string.Empty) { var studentsid = dbe.StudentModelLogins.FirstOrDefault(a => a.Roll_No.Equals(signidtxt.Text)); if (studentsid != null) { if (studentsid.Password == null) { if (signpasstxt.Password != "") { if (signpasstxt.Password == signconpasstxt.Password) { using (dbe) { var query = (from StudentModelLogin in dbe.StudentModelLogins where StudentModelLogin.Roll_No == signidtxt.Text select StudentModelLogin).First(); query.Password = signpasstxt.Password; dbe.Entry(query).State = EntityState.Modified; dbe.SaveChanges(); signidtxt.Clear(); signpasstxt.Clear(); signconpasstxt.Clear(); MessageBox.Show("Account Created."); } } else { MessageBox.Show("Password fields does not match."); } } else { MessageBox.Show("Don't leave a field blank."); } } else { MessageBox.Show("You already have a account."); } } else { MessageBox.Show("Invalid ID"); } } else { MessageBox.Show("Don't leave a field blank."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void postbtn_Click(object sender, RoutedEventArgs e) { try { //Using ADO.Net Entities for insertion operation WPFLIBDATABASEEntities entities = new WPFLIBDATABASEEntities(); Question question = new Question(); question.Question1 = qstntxt.Text; question.PostDate = expdt.SelectedDate.Value; question.Mark_Available = Convert.ToInt32(mrkalottxt.Text); if (MyImage.Source != null) { //Begin Convert Image from Source to Byte FileStream stream = new FileStream(filename, FileMode.Open, FileAccess.Read); StreamReader reader = new StreamReader(stream); Byte[] ImgData = new Byte[stream.Length - 1]; stream.Read(ImgData, 0, (int)stream.Length - 1); //End question.Picture = ImgData; } entities.Questions.Add(question); entities.SaveChanges(); //cleaning up components after insertion qstntxt.Clear(); mrkalottxt.Clear(); MyImage.Source = null; expdt.SelectedDate = null; } catch (Exception) { MessageBox.Show("Please Check All Fields", "Error"); } }
private void discsubmit_Click(object sender, RoutedEventArgs e) { using (context) { DisciplineModel objdiscipline = new DisciplineModel(); objdiscipline.Roll_No = studcombo.SelectedValue.ToString(); objdiscipline.Deduction = Convert.ToInt32(disciplinetxt.Text); objdiscipline.Remarks = remarktxt.Text; objdiscipline.Date = DateTime.Now; context.DisciplineModels.Add(objdiscipline); context.SaveChanges(); disciplinetxt.Clear(); remarktxt.Clear(); } status.Text = "Changes Updated!"; dispatcherTimer.Interval = new TimeSpan(0, 0, 1); dispatcherTimer.Start(); }
private void updatetot_Click(object sender, RoutedEventArgs e) { var mi = from sl in dbm.StudentModelLogins join tm in dbm.View_TotalMarks on sl.Roll_No equals tm.Roll_No select new { sl, tm }; foreach (var item in mi) { item.sl.Total_Mark = item.tm.TotalMark; } var di = from sl in dbm.StudentModelLogins join de in dbm.View_DisciplinedMarks on sl.Roll_No equals de.Roll_No select new { sl, de }; foreach (var item in di) { item.sl.Total_Mark = item.sl.Total_Mark - (item.de.Deduction); } dbm.SaveChanges(); }
private void submitbtn_Click(object sender, RoutedEventArgs e) { try { StudentAnswer sa = new StudentAnswer(); sa.Roll_No = Roll; sa.Qno = Convert.ToInt32(qnolist.SelectedValue.ToString()); sa.Answer = answertxt.Text; dbq.StudentAnswers.Add(sa); dbq.SaveChanges(); answertxt.Clear(); qntxt.Clear(); img.Source = null; Render(); } catch (Exception ex) { MessageBox.Show("Invalid Case", "Error"); } }
private void submitcorrectionbtn_Click(object sender, RoutedEventArgs e) { try { int y = Convert.ToInt32(listquest.SelectedValue.ToString()); int x = Convert.ToInt32(txtmrkscor.Text); var queryStudentAnswers = from StudentAnswers in dbc.StudentAnswers where StudentAnswers.Qno == y && StudentAnswers.Roll_No == listroll.SelectedValue.ToString() select StudentAnswers; foreach (var StudentAnswers in queryStudentAnswers) { StudentAnswers.Mark_Obtained = x; } //Inserting total marks from view to studentlogin table var mi = from sl in dbc.StudentModelLogins join tm in dbc.View_TotalMarks on sl.Roll_No equals tm.Roll_No select new { sl, tm }; foreach (var item in mi) { item.sl.Total_Mark = item.tm.TotalMark; } //saving changes to database dbc.SaveChanges(); Clearfunc(); Render(); } catch (Exception) { MessageBox.Show("Check all fields."); } }
private void adminframe_ContentRendered(object sender, EventArgs e) { var mi = from sl in entities.StudentModelLogins join tm in entities.View_TotalMarks on sl.Roll_No equals tm.Roll_No select new { sl, tm }; foreach (var item in mi) { item.sl.Total_Mark = item.tm.TotalMark; } var di = from sl in entities.StudentModelLogins join de in entities.View_DisciplinedMarks on sl.Roll_No equals de.Roll_No select new { sl, de }; foreach (var item in di) { item.sl.Total_Mark = item.sl.Total_Mark - (item.de.Deduction); } entities.SaveChanges(); switch (status) { case 1: postq.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 2: correc.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 3: ranki.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 4: answr.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 5: stulist.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 6: quelist.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 7: misc.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); discipline.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; case 8: discipline.Background = new SolidColorBrush(Color.FromArgb(221, 221, 221, 100)); postq.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); correc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); ranki.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); answr.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); stulist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); quelist.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); misc.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#4CDDDDDD")); break; } }