public Student_Admission_Fee_View_Model Get_Admission_Fee_Details_By_Student_ID(long Student_ID) { Student_Admission_Fee_View_Model result; using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Student_ID", SqlDbType.BigInt, Student_ID); using (SqlDataReader sqlDataReader = sqlService.ExecuteSPReader("dbo.USP_Get_Admission_Fee_Details_By_Student_ID")) { Student_Admission_Fee_View_Model student_Admission_Fee_View_Model = new Student_Admission_Fee_View_Model(); student_Admission_Fee_View_Model.List_Admission_Fee = sqlDataReader.MapToList <AdmissionFeeModel>(); sqlDataReader.NextResult(); student_Admission_Fee_View_Model.Student_Fee_Info = sqlDataReader.MapToSingle <Student_Fee_Info_Model>(); sqlDataReader.NextResult(); result = student_Admission_Fee_View_Model; } } return(result); }
private void Get_Admission_Fee_Details_By_Student_ID(long Student_ID) { AdmissionFee _admissionFee = new AdmissionFee(); Student_Admission_Fee_View_Model _model = _admissionFee.Get_Admission_Fee_Details_By_Student_ID(Student_ID); if (_model != null) { if (_model.List_Admission_Fee != null && _model.List_Admission_Fee.Count > 0) { ConstructGrid(_model.List_Admission_Fee); } if (_model.Student_Fee_Info != null) { if (_model.Student_Fee_Info.Academic_Year != null) { txtMaskedDate.Text = String.Format("{0:dd.MM.yyyy}", _model.Student_Fee_Info.Updated_Date); ddlAcademicYear.SelectedValue = _model.Student_Fee_Info.Academic_Year; } #region CheckBox Sequence_No_Student_Fee_Info = _model.Student_Fee_Info.Sequence_No; if (_model.Student_Fee_Info.April == 1) { chkApril.Checked = true; } else { chkApril.Checked = false; } if (_model.Student_Fee_Info.May == 1) { chkMay.Checked = true; } else { chkMay.Checked = false; } if (_model.Student_Fee_Info.June == 1) { chkJune.Checked = true; } else { chkJune.Checked = false; } if (_model.Student_Fee_Info.July == 1) { chkJuly.Checked = true; } else { chkJuly.Checked = false; } if (_model.Student_Fee_Info.August == 1) { chkAugust.Checked = true; } else { chkAugust.Checked = false; } if (_model.Student_Fee_Info.September == 1) { chkSeptember.Checked = true; } else { chkSeptember.Checked = false; } if (_model.Student_Fee_Info.October == 1) { chkOctober.Checked = true; } else { chkOctober.Checked = false; } if (_model.Student_Fee_Info.November == 1) { chkNovember.Checked = true; } else { chkNovember.Checked = false; } if (_model.Student_Fee_Info.December == 1) { chkDecember.Checked = true; } else { chkDecember.Checked = false; } if (_model.Student_Fee_Info.January == 1) { chkJanuary.Checked = true; } else { chkJanuary.Checked = false; } if (_model.Student_Fee_Info.February == 1) { chkFebruary.Checked = true; } else { chkFebruary.Checked = false; } if (_model.Student_Fee_Info.March == 1) { chkMarch.Checked = true; } else { chkMarch.Checked = false; } if (Sequence_No_Student_Fee_Info != null) { btnPrint.Enabled = true; } else { btnPrint.Enabled = false; } panelMonths.Enabled = true; BindMonths(Convert.ToInt32(ddlAcademicYear.SelectedValue)); #endregion } } }