protected void gridView1_SelectedIndexChanged(object sender, EventArgs e) { ClearAll(); edit_mode = true; site = new DBSite(); GridViewRow row = gridView1.SelectedRow; lblExamMasterId.Text = row.Cells[3].Text; SubjectMasterBLL sBll = new SubjectMasterBLL(); ExamMasterBll exBll = new ExamMasterBll(); ExamMasterBll.ExamMasterEntity exam = exBll.GetExamList(site, Util_BLL.User.UserId, lblExamMasterId.Text)[0]; lblExamMasterId.Text = util.CheckNull(exam.ExamMasterId); txtExamName.Text = exam.ExamName; txtExamCode.Text = exam.ExamCode; ///txtExamDate.Text = exam.ExamDate; txtMaxMarks.Text = util.CheckNull(exam.MaxMarks); txtPassMarks.Text = util.CheckNull(exam.PassMarks); ddlClass.SelectedValue = util.CheckNull(exam.ClassMasterID); ddlSection.SelectedValue = util.CheckNull(exam.SectionMasterID); ddlTerm.SelectedValue = util.CheckNull(exam.TermId); }
void SaveExam() { exmBll = new ExamMasterBll(); ExamMasterBll.ExamMasterEntity exam = new ExamMasterBll.ExamMasterEntity(); try { string message = ""; exam.ExamName = this.txtExamName.Text; exam.ExamCode = this.txtExamCode.Text; exam.ExamDate = util.CheckNullDate(DateTime.Today); exam.ClassMasterID = util.CheckNullInt(ddlClass.SelectedValue); exam.SectionMasterID = util.CheckNullInt(ddlSection.SelectedValue); exam.TermId = util.CheckNullInt(ddlTerm.SelectedValue); exam.MaxMarks = util.CheckNullInt(txtMaxMarks.Text); exam.PassMarks = util.CheckNullInt(txtPassMarks.Text); exam.ExamOrder = util.CheckNullInt(txtExamOrder.Text); site = new DBSite(); // save or updare site.BeginTrans(); if (lblExamMasterId.Text == "New") { exmBll.SaveExam(site, exam); message = "\t '" + exam.ExamName + "' Successfully Added !"; } else { exam.ExamMasterId = util.CheckNullInt(lblExamMasterId.Text); exmBll.UpdateExam(site, exam); message = "\t '" + exam.ExamName + "' Successfully Updated !"; } site.Commit(); lblMessage.Text = message; lblMessage.Visible = true; ClearErrorMessage(); } catch (Exception ex) { site.RollBack(); if (ex.Message.Contains("UNQ_ExamName")) { lblMessage.Text = "\t '" + exam.ExamName + "' is already present !"; lblMessage.Visible = true; } else { util.HandleExpception(ex, Response); } } finally { site.Close(); } }