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