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