private void btnstudentsearch_Click(object sender, EventArgs e)
{
if (txtstudentid.Text != null)
{
model_students.regid = txtstudentid.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any())
{
model_students = db.basicdata_student.Where(x => x.regid == model_students.regid).FirstOrDefault();
txtstudentname.Text = model_students.Firstname;
txtbatch.Text = model_students.Batch;
txtschool.Text = model_students.Al_school;
cmbexam.Enabled = true;
btnexamsearch.Enabled = true;
get_student_exam_vale_list();
}
else
{
clear();
MessageBox.Show("Invalud Student Registration ID. Please Try Again!");
}
}
}
else
{
MessageBox.Show("Invalud Student Registration ID. Please Try Again!");
clear();
}
populate_all_student_exam_marks_data();
}
private void btnsearch_Click(object sender, EventArgs e)
{
if (txtsearch.Text != null)
{
model_students.regid = txtfind.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
model_students = db.basicdata_student.Where(x => x.regid == model_students.regid).FirstOrDefault();
txtfirstname.Text = model_students.Firstname;
txtlastname.Text = model_students.Lastname;
txtnic.Text = model_students.Nic;
dtpdob.Text = model_students.Dob;
txthomeaddress.Text = model_students.home_address;
txthometell.Text = model_students.Home_tell;
txtstayingaddress.Text = model_students.Staying_address;
txtstayingtell.Text = model_students.Stay_home_tell;
txtfathername.Text = model_students.Father_name;
txtparenttell.Text = model_students.Parents_contact;
cmbolschool.Text = model_students.Ol_School;
cmbalschool.Text = model_students.Al_school;
txtolresult.Text = model_students.Ol_result;
txtjoiningdate.Text = model_students.JoinDate;
cmbbatch.Text = model_students.Batch;
cmbgender.Text = model_students.Gender;
cmbscholership.SelectedItem = model_students.Scholarship;
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
}
}
private void dgvStudent_DoubleClick(object sender, EventArgs e)
{
if (dgvStudent.CurrentRow.Index != -1)
{
model_students.Id = Convert.ToInt32(dgvStudent.CurrentRow.Cells["Id"].Value);
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
model_students = db.basicdata_student.Where(x => x.Id == model_students.Id).FirstOrDefault();
txtfirstname.Text = model_students.Firstname;
txtlastname.Text = model_students.Lastname;
txtnic.Text = model_students.Nic;
dtpdob.Text = model_students.Dob;
txthomeaddress.Text = model_students.home_address;
txthometell.Text = model_students.Home_tell;
txtstayingaddress.Text = model_students.Staying_address;
txtstayingtell.Text = model_students.Stay_home_tell;
txtfathername.Text = model_students.Father_name;
txtparenttell.Text = model_students.Parents_contact;
cmbolschool.Text = model_students.Ol_School;
cmbalschool.Text = model_students.Al_school;
txtolresult.Text = model_students.Ol_result;
txtjoiningdate.Text = model_students.JoinDate;
cmbbatch.Text = model_students.Batch;
cmbgender.Text = model_students.Gender;
cmbscholership.SelectedItem = model_students.Scholarship;
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
if (txtfind.Text != null)
{
groupId.Visible = true;
model_students.regid = txtfind.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.basicdata_student.Where(data => data.regid == txtfind.Text).Any())
{
model_students = db.basicdata_student.Where(x => x.regid == model_students.regid).FirstOrDefault();
lblname.Text = model_students.Firstname;
lblregid.Text = model_students.regid;
lbljoiningdate.Text = model_students.JoinDate;
lblbatch.Text = model_students.Batch;
}
else
{
clear();
MessageBox.Show("Invalud Student Registration ID. Please Try Again!");
}
}
string barCode = model_students.regid;
try
{
if (barCode != null)
{
Zen.Barcode.Code128BarcodeDraw brCode = Zen.Barcode.BarcodeDrawFactory.Code128WithChecksum;
picbatcode.Image = brCode.Draw(barCode, 60);
}
}
catch (Exception)
{
}
txtsavefilename.Text = "StudentIDCard_" + model_students.regid;
}
else
{
MessageBox.Show("Invalud Student Registration ID. Please Try Again!");
clear();
}
}
private void btnstudentsearch_Click(object sender, EventArgs e)
{
populate_all_student_exam_marks_data();
chartAvg.Series["Average"].XValueMember = "exam";
chartAvg.Series["Average"].YValueMembers = "average_marks";
chartAvg.DataSource = dgvStudentResultData.DataSource;
chartAvg.DataBind();
charAvgBar.Series["Average"].XValueMember = "exam";
charAvgBar.Series["Average"].YValueMembers = "average_marks";
charAvgBar.DataSource = dgvStudentResultData.DataSource;
charAvgBar.DataBind();
chartEconomics.Series["Economics"].XValueMember = "exam";
chartEconomics.Series["Economics"].YValueMembers = "subject_1";
chartEconomics.DataSource = dgvStudentResultData.DataSource;
chartEconomics.DataBind();
chartAccounting.Series["Accounting"].XValueMember = "exam";
chartAccounting.Series["Accounting"].YValueMembers = "subject_3";
chartAccounting.DataSource = dgvStudentResultData.DataSource;
chartAccounting.DataBind();
chartBusiness.Series["BusinessStudies"].XValueMember = "exam";
chartBusiness.Series["BusinessStudies"].YValueMembers = "subject_2";
chartBusiness.DataSource = dgvStudentResultData.DataSource;
chartBusiness.DataBind();
model_students.regid = txtstudentid.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any())
{
model_students = db.basicdata_student.Where(x => x.regid == model_students.regid).FirstOrDefault();
txtfirstname.Text = model_students.Firstname;
txtlastname.Text = model_students.Lastname;
txtbatch.Text = model_students.Batch;
txtschool.Text = model_students.Al_school;
}
else
{
MessageBox.Show("Invalud Student Registration ID. Please Try Again!");
}
}
}
private void btnregister_Click(object sender, EventArgs e)
{
if (txtstudentid.Text != null)
{
model_student.regid = txtstudentid.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any())
{
model_student = db.basicdata_student.Where(x => x.regid == model_student.regid).FirstOrDefault();
txtbatch.Text = model_student.Batch;
}
else
{
clear();
lblmessage.Text = "Invalid Class Entry..";
}
}
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
model_attandance.intime = DateTime.Now.ToString();
model_attandance.attandance = "Attend";
if (db.data_attandance.Where(data => data.regid == txtstudentid.Text && data.batch == txtbatch.Text && data.classdate == txttoday.Text).Any())//Update attandance
{
model_attandance = db.data_attandance.Where(x => x.regid == txtstudentid.Text && x.batch == txtbatch.Text && x.classdate == txttoday.Text).FirstOrDefault();
model_attandance.intime = DateTime.Now.ToString();
model_attandance.attandance = "Attend";
db.Entry(model_attandance).State = EntityState.Modified;
db.SaveChanges();
lblmessage.Text = "Welcome : " + model_student.Firstname;
}
else
{
lblmessage.Text = "Invalid Class Entry..";
}
}
txtstudentid.Text = null;
txtbatch.Text = null;
}
}
private void btnregister_Click(object sender, EventArgs e)
{
if (txtstudentid.Text != null)
{
model_student.regid = txtstudentid.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any())
{
model_student = db.basicdata_student.Where(x => x.regid == model_student.regid).FirstOrDefault();
batch = model_student.Batch;
}
else
{
txtstudentid.Text = null;
lblmessage.Text = "Invalid Entry..";
}
model_fee = db.basicdate_fee.Where(data => data.batch_ == batch).FirstOrDefault();
amount = model_fee.amount;
}
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (db.data_feecollection.Where(data => data.regid == txtstudentid.Text && data.batch == batch && data.feeschedule == txtmonth.Text).Any())//Update attandance
{
model_feecollection = db.data_feecollection.Where(data => data.regid == txtstudentid.Text && data.batch == batch && data.feeschedule == txtmonth.Text).FirstOrDefault();
model_feecollection.payment = "Paid";
model_feecollection.payment_date = DateTime.Now.ToString();
model_feecollection.amount = amount;
db.Entry(model_feecollection).State = EntityState.Modified;
db.SaveChanges();
lblmessage.Text = "Payment Colleted for : " + model_student.Firstname;
}
else
{
lblmessage.Text = "Invalid Entry..";
}
}
txtstudentid.Text = null;
}
}