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 Loginbtn_Click(object sender, RoutedEventArgs e)
{
try
{
WPFLIBDATABASEEntities dbe = new WPFLIBDATABASEEntities();
if (Admin.Text != string.Empty || AdminPassword.Password != string.Empty)
{
var Admins = dbe.AdminLogins.FirstOrDefault(a => a.AdminID.Equals(Admin.Text));
if (Admins != null)
{
if (Admins.Password.Equals(AdminPassword.Password))
{
AdminPanel adpa = new AdminPanel();
Application.Current.Windows[0].Close();
adpa.ShowDialog();
}
else
{
MessageBox.Show("Password Incorrect");
}
}
else
{
MessageBox.Show("Admin Invalid");
}
}
}catch (Exception ex)
{
MessageBox.Show("" + ex.Message);
}
}
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 loadgrid()
{
WPFLIBDATABASEEntities context = new WPFLIBDATABASEEntities();
var data = from c in context.StudentAnswers
select c; /*new { c.SAno, c.Roll_No, c.Answer, c.Qno , c.Mark_Obtained };*/
studentAnswerDataGrid.ItemsSource = data.ToList();
}
private void loadgrid()
{
WPFLIBDATABASEEntities context = new WPFLIBDATABASEEntities();
var data = from c in context.StudentModelLogins
select new { c.Roll_No, c.Name, c.Gender, c.Total_Mark };
studgrid.ItemsSource = data.ToList();
}
private void loadgrid()
{
WPFLIBDATABASEEntities context = new WPFLIBDATABASEEntities();
var data = from c in context.Questions
select new { c.Qno, c.Question1, c.Mark_Available, c.Picture, c.PostDate };
questionDataGrid.ItemsSource = data.ToList();
}
private void login_Click(object sender, RoutedEventArgs e)
{
if (logidtxt.Text != "" && logpasstxt.Password != "")
{
try
{
WPFLIBDATABASEEntities dbs = new WPFLIBDATABASEEntities();
if (logidtxt.Text != string.Empty || logpasstxt.Password != string.Empty)
{
var studs = dbs.StudentModelLogins.FirstOrDefault(a => a.Roll_No.Equals(logidtxt.Text));
if (studs != null)
{
if (studs.Password.Equals(logpasstxt.Password))
{
roll = studs.Roll_No;
nam = studs.Name;
StudentPanel stpa = new StudentPanel(roll, nam);
Application.Current.Windows[0].Close();
stpa.ShowDialog();
}
else
{
MessageBox.Show("Password Incorrect!");
}
}
else
{
MessageBox.Show("Account not found.");
}
}
else
{
MessageBox.Show("Fill both fields.");
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.Message);
}
}
else
{
MessageBox.Show("Don't leave a blank field.");
}
}