private void GetMarks()
{
site = new DBSite();
ExamMarksBll eBll = new ExamMarksBll();
try
{
int studentId = -1;
if (txtSearch.Text.Length > 0)
{
studentId = int.Parse(txtSearch.Text);
}
List <ExamMarksBll.ExamMarksEntity> marksList = eBll.GetExamMarks(site, int.Parse(ddlClass.SelectedValue), int.Parse(ddlSection.SelectedValue), int.Parse(ddlExam.SelectedValue), ddlSubject.SelectedValue.ToString(), studentId, isNewExamMarksEntry);
total_records = marksList.Count;
gridView1.DataSource = marksList;
gridView1.DataBind();
}
catch (Exception exception)
{
util.HandleExpception(exception, Response);
}
finally
{
site.Close();
}
}
private void GetAttendance(bool onlyAbsentees)
{
site = new DBSite();
AttendanceBll aBll = new AttendanceBll();
aBll.ProcessMachineAttendance(site, int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), int.Parse(ddlDay.SelectedValue), 0);
try
{
List <AttendanceBll.AttendanceEntity> attdlist = aBll.GetAttendance(site, int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), int.Parse(ddlDay.SelectedValue), int.Parse(ddlClass.SelectedValue), onlyAbsentees);
total_records = attdlist.Count;
gridView1.DataSource = attdlist;
gridView1.DataBind();
}
catch (Exception exception)
{
util.HandleExpception(exception, Response);
}
finally
{
site.Close();
}
}
protected void SaveStudent()
{
StudentBll st_bll = null;
st_bll = new StudentBll();
StudentBll.StudenEntity student = new StudentBll.StudenEntity();
try
{
site = new DBSite();
site.BeginTrans();
student.StudentName = txtStudentName.Text;
student.AdmNo = txtAdmNo.Text;
student.PresentClass = util.CheckNullInt(ddlPresentClass.SelectedValue);
student.SectionId = util.CheckNullInt(ddlSection.SelectedValue);
student.IdCardNo = txtIdCardNo.Text;
student.FatherName = txtFatherName.Text;
student.MotherName = txtMotherName.Text;
student.MobileNoF = txtMobileNoF.Text;
student.MobileNoM = txtMobileNoM.Text;
student.DOB = txtDOB.Text;
if (txtMobileNoF.Text.Length != 10)
{
lblError.Text = "Mobile Number should be of 10 digits";
lblError.Visible = true;
txtMobileNoF.Focus();
ClearSuccessMessage();
return;
}
student.Email = txtDOB.Text;
string message = "";
if (this.lblStudentMasterId.Text == "New")
{
//if (IsDuplicateCardNo(site, student.IdCardNo, -1))
//{
// txtIdCardNo.Focus();
// isErr = true;
// return;
//}
st_bll.SaveStudent(site, student);
message = " Successfully Added !";
}
else
{
student.StudentMasterId = util.CheckNullInt(lblStudentMasterId.Text);
//if (IsDuplicateCardNo(site, student.IdCardNo, student.StudentMasterId))
//{
// txtIdCardNo.Focus();
// isErr = true;
// return;
//}
st_bll.UpdateStudent(site, student);
message = " Successfully Updated !";
}
site.Commit();
lblMessage.Text = message;
lblMessage.Visible = true;
isErr = false;
ClearErrorMessage();
}
catch (Exception ex)
{
site.RollBack();
util.HandleExpception(ex, Response);
}
finally
{
site.Close();
}
}
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();
}
}
