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;
}
}
