private void courses_Load(object sender, EventArgs e)
{
StudentLinqDataContext dc = new StudentLinqDataContext();
comboBox1.DisplayMember = "CourseName";
comboBox1.DataSource = dc.Courses.ToList <Course>();
}
private void button4_Click(object sender, EventArgs e)
{
try
{
using (StudentLinqDataContext data = new StudentLinqDataContext())
{
studentinfo lg = data.studentinfos.Single(Student_Info => Student_Info.StudentName == textBox1.Text);
Password = lg.CreatePassword;
name = lg.StudentName;
path = @"C:\Users\Tomal\Documents\Visual Studio 2013\Projects\Info\AllInfo\studentpropic\" + name + ".jpg";
}
if (Password == textBox2.Text)
{
MessageBox.Show("login successfull ");
textBox1.Text = null;
textBox2.Text = null;
}
StudentHomepage st = new StudentHomepage(name, path);
st.Show();
this.Hide();
}
catch
{
MessageBox.Show("Invalid username or password");
textBox1.Text = null;
textBox2.Text = null;
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
using (StudentLinqDataContext supdate = new StudentLinqDataContext())
{
StudentLinqDataContext sup = new StudentLinqDataContext();
int id = int.Parse(label6.Text);
studentinfo sobj = supdate.studentinfos.Single(Student_Info => Student_Info.id == id);
sobj.StudentName = textBox1.Text;
sobj.Email = textBox2.Text;
sobj.Mobile = textBox3.Text;
sobj.AdmissionYear = textBox4.Text;
sobj.Department = textBox5.Text;
supdate.SubmitChanges();
MessageBox.Show("Data Updated");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
/// textBox1.Text = null;
}
}
private void button1_Click(object sender, EventArgs e)
{
StudentLinqDataContext quest = new StudentLinqDataContext();
exam exm = new exam();
exm.ques = textBox1.Text;
exm.ans = ans;
exm.marks = 1;
quest.exams.InsertOnSubmit(exm);
quest.SubmitChanges();
MessageBox.Show("Question added successfully");
textBox1.Text = null;
}
private void button7_Click(object sender, EventArgs e)
{
{
StudentLinqDataContext sdelete = new StudentLinqDataContext();
studentinfo sinfo = sdelete.studentinfos.Single(Student_Info => Student_Info.StudentName == textBox1.Text);
sdelete.studentinfos.DeleteOnSubmit(sinfo);
sdelete.SubmitChanges();
MessageBox.Show("Data ddeleted");
}
}
private void StudentSearch_Load(object sender, EventArgs e)
{
{
using (StudentLinqDataContext Ssearch = new StudentLinqDataContext())
{
// Student_Info sinfo = Ssearch.Student_Infos.Single(Student_Info => Student_Info.Id.ToString() == textBox1.Text);
/// DCDataContext db = new DCDataContext();
// dataGridView1.DataSource = Ssearch.Student_Infos.Select(Student_Info => Student_Info.StudentName <= DateTime.);
// textBox1.Text = sinfo.Student;
// dataGridView1.DataSource = sinfo;
// dataGridView1.DataBindings()
dataGridView1.DataSource = Ssearch.studentinfos;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
StudentLinqDataContext db = new StudentLinqDataContext();
Course fac = new Course();
fac.CourseName = textBox1.Text;
fac.Seat = textBox2.Text;
db.Courses.InsertOnSubmit(fac);
db.SubmitChanges();
MessageBox.Show("Data Inserted");
}
catch (Exception ex)
{
MessageBox.Show("Data Not Inserted");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
StudentLinqDataContext db = new StudentLinqDataContext();
Co fac = new Co();
fac.CourseAdded = comboBox1.Text;
fac.StudentName = studentname;
db.Cos.InsertOnSubmit(fac);
db.SubmitChanges();
MessageBox.Show("Course Added");
}
catch (Exception ex)
{
MessageBox.Show("Data Not Inserted");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
StudentLinqDataContext dbc = new StudentLinqDataContext();
studentinfo st = new studentinfo();
st.StudentName = textBox1.Text;
st.FatherName = textBox2.Text;
st.Email = textBox3.Text;
st.Mobile = textBox4.Text;
st.Age = textBox5.Text;
st.Sex = textBox6.Text;
st.Religion = textBox7.Text;
st.AdmissionYear = textBox8.Text;
st.CreatePassword = textBox10.Text;
st.Department = textBox11.Text;
dbc.studentinfos.InsertOnSubmit(st);
dbc.SubmitChanges();
File.Copy(temp1, @"C:\Users\Tomal\Documents\Visual Studio 2013\Projects\Info\AllInfo\studentpropic\" + textBox1.Text + ".jpg");
MessageBox.Show("Data Inserted");
textBox1.Text = null;
textBox2.Text = null;
textBox3.Text = null;
textBox4.Text = null;
textBox5.Text = null;
textBox6.Text = null;
textBox7.Text = null;
textBox8.Text = null;
textBox9.Text = null;
textBox10.Text = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}
private void button1_Click(object sender, EventArgs e)
{
groupBox1.Show();
//Random rnd = new Random();
//int val = rnd.Next(1, 10);
val++;
// MessageBox.Show(val.ToString());
try
{
totalmark = totalmark + 1;
{
using (StudentLinqDataContext ques = new StudentLinqDataContext())
{
exam xm = ques.exams.Single(quiz => quiz.id == val);
label1.Text = (xm.ques);
if (xm.ans == answer)
{
achivedmark = achivedmark + 1;
}
else
{
achivedmark = achivedmark + 0;
}
// MessageBox.Show(val.ToString());
//label1.Show();
// MessageBox.Show("ques "+xm.question);
}
}
}
catch
{
MessageBox.Show("Exam is over your mark is" + achivedmark.ToString() + "out of" + totalmark.ToString());
this.Dispose();
//this.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (StudentLinqDataContext Ssearch = new StudentLinqDataContext())
{
studentinfo sinfo = Ssearch.studentinfos.Single(Student_Info => Student_Info.StudentName == textBox1.Text);
textBox1.Text = sinfo.StudentName;
textBox2.Text = sinfo.Email;
textBox3.Text = sinfo.Mobile;
textBox4.Text = sinfo.AdmissionYear;
textBox5.Text = sinfo.Department;
MessageBox.Show("Data Found");
}
}
catch
{
MessageBox.Show("Data Not Found ");
textBox1.Text = null;
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
using (StudentLinqDataContext Ssearch = new StudentLinqDataContext())
{
studentinfo sinfo = Ssearch.studentinfos.Single(Student_Info => Student_Info.StudentName == textBox1.Text);
label3.Text = sinfo.StudentName;
label4.Text = sinfo.Email;
label12.Text = sinfo.Mobile;
label6.Text = sinfo.AdmissionYear;
label8.Text = sinfo.Department;
MessageBox.Show("Data Found");
label3.Show();
label4.Show();
label5.Show();
label6.Show();
label7.Show();
label8.Show();
label9.Show();
label10.Show();
label11.Show();
label12.Show();
label13.Show();
textBox1.Text = null;
}
}
catch
{
MessageBox.Show("Data Not Found ");
textBox1.Text = null;
}
}