private void btnupdate_Click(object sender, EventArgs e)
{
decimal sub1 = decimal.Parse(txtsubject1.Text);
decimal sub2 = decimal.Parse(txtsubject2.Text);
decimal sub3 = decimal.Parse(txtsubject3.Text);
decimal eng = decimal.Parse(txtenglish.Text);
decimal git = decimal.Parse(txtgit.Text);
decimal tot = decimal.Parse(txttotal.Text);
decimal avg = decimal.Parse(txtaverage.Text);
model_results.subject_1 = sub1;
model_results.subject_2 = sub2;
model_results.subject_3 = sub3;
model_results.English = eng;
model_results.git = git;
model_results.total_marks = tot;
model_results.average_marks = avg;
model_results.avg_state = txtavgstate.Text;
model_results.regid = txtstudentid.Text;
model_results.exam = cmbexam.Text;
model_results.batch = txtbatch.Text;
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
if (cmbexam.Text != null)
{
model_examschedule.exam = cmbexam.Text;
model_examschedule = db.basicdate_schedule.Where(x => x.exam == model_examschedule.exam).FirstOrDefault();
model_results.exam_date = model_examschedule.start_date;
}
else
{
message_popup_ok("Pleae fill all data fields!");
}
if (db.data_examresults.Where(data => data.regid == txtstudentid.Text && data.exam == cmbexam.Text).Any())//Insert
{
db.Entry(model_results).State = EntityState.Modified;
}
else //Update
{
db.data_examresults.Add(model_results);
}
db.SaveChangesAsync();
message_popup_ok("Data Record Saved!");
}
populate_all_student_exam_marks_data();
}
private void dgvExamSchedule_DoubleClick(object sender, EventArgs e)
{
if (dgvExamSchedule.CurrentRow.Index != -1)
{
model_examschedule.id = Convert.ToInt32(dgvExamSchedule.CurrentRow.Cells["id"].Value);
using (proadmin_v1Entities db = new proadmin_v1Entities())
{
model_examschedule = db.basicdate_schedule.Where(x => x.id == model_examschedule.id).FirstOrDefault();
txtexam.Text = model_examschedule.exam;
dtpstartdate.Text = model_examschedule.start_date;
dtpenddate.Text = model_examschedule.end_date;
cmbstate.Text = model_examschedule.state;
cmbexamtype.Text = model_examschedule.exam_type;
cmbbatch.Text = model_examschedule.batch;
}
btnsubsave.Text = "Update";
btnsubdelete.Enabled = true;
}
}
