private void BindGridControlsOnSearch()
{
gridStudent.DataSource = null;
gridFine.DataSource = null;
studentFineModel = new StudentFineViewModel();
fineSettings = new FineSettings();
studentFineModel.ClassID = Convert.ToInt16(ddlCurrentClass.SelectedValue);
studentFineModel.SectionID = Convert.ToInt16(ddlCurrentSection.SelectedValue);
studentFineModel.FineDate = Common.Convert_String_To_Date(datePickerReport.Text);
// DateTime.ParseExact(datePickerReport.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
studentFineModel.FineTypeID = Convert.ToInt16(ddlFeeType.SelectedValue);
studentFineModel = fineSettings.GetStudentFineDetails(studentFineModel, out ISBillPaid);
BindStudentGrid(studentFineModel.ListStudent);
BindFineGrid(studentFineModel.ListStudentFine);
if (ISBillPaid == 1)
{
btnSave.Enabled = false;
btnMoveLeft.Enabled = false;
btnMoveRight.Enabled = false;
lblError.Visible = true;
}
else
{
btnSave.Enabled = true;
btnMoveLeft.Enabled = true;
btnMoveRight.Enabled = true;
lblError.Visible = false;
}
}
public StudentFineViewModel GetStudentFineDetails(StudentFineViewModel studentFine, out short isBillPaid)
{
StudentFineViewModel studentFineViewModel;
using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings))
{
sqlService.AddParameter("@ClassID", SqlDbType.SmallInt, studentFine.ClassID);
sqlService.AddParameter("@SectionID", SqlDbType.SmallInt, studentFine.SectionID);
sqlService.AddParameter("@FineDate", SqlDbType.Date, studentFine.FineDate);
sqlService.AddParameter("@FineTypeID", SqlDbType.SmallInt, studentFine.FineTypeID);
sqlService.AddOutputParameter("@ISBillPaid", SqlDbType.SmallInt);
using (SqlDataReader sqlDataReader = sqlService.ExecuteSPReader("dbo.USP_GetStudentFineDetails"))
{
this._studentFineViewModel = new StudentFineViewModel();
this._studentFineViewModel.ListStudent = sqlDataReader.MapToList <StudentFineViewModel>();
sqlDataReader.NextResult();
this._studentFineViewModel.ListStudentFine = sqlDataReader.MapToList <StudentFineViewModel>();
sqlDataReader.NextResult();
isBillPaid = (short)sqlService.Parameters["@ISBillPaid"].Value;
studentFineViewModel = this._studentFineViewModel;
}
}
return(studentFineViewModel);
}
