public DTO.LABURNUM.COM.StudentFeeModel SearchAdmissionFeeReceiptDataByDetailId(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByID(model.StudentFeeDetailId);
DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeModel()
{
StudentId = dbstudentfeeDetails.StudentId,
ClassId = dbstudentfeeDetails.ClassId,
SectionId = dbstudentfeeDetails.SectionId
})).MapSingle();
studentFeeModel.PendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
studentFeeModel.CashPaidAmount = dbstudentfeeDetails.CashPaidAmount.GetValueOrDefault();
studentFeeModel.ChequePaidAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault();
studentFeeModel.ChequeNumber = dbstudentfeeDetails.ChequeNumber;
studentFeeModel.ChequeDate = dbstudentfeeDetails.ChequeDate;
return(studentFeeModel);
}
else
{
return(null);
}
}
public DTO.LABURNUM.COM.StudentFeeModel SearchAdmissionFeeReceiptData(DTO.LABURNUM.COM.StudentFeeModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeById(model.StudentFeeId)).MapSingle();
API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new FrontEndApi.StudentFeeDetailApi().GetFeePaidDetailDuringAdmission(studentFeeModel.StudentId, studentFeeModel.ClassId, studentFeeModel.SectionId, studentFeeModel.AcademicYearId);
studentFeeModel.PendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
studentFeeModel.CashPaidAmount = dbstudentfeeDetails.CashPaidAmount.GetValueOrDefault();
studentFeeModel.ChequePaidAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault();
studentFeeModel.ChequeNumber = dbstudentfeeDetails.ChequeNumber;
studentFeeModel.ChequeDate = dbstudentfeeDetails.ChequeDate;
return(studentFeeModel);
}
else
{
return(null);
}
}
public dynamic SearchFeeResult(DTO.LABURNUM.COM.FeeReportingModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
if (model.ClassId == 0 && model.SectionId == 0 && model.StudentId == 0 && model.StartDate.Year == 0001 && model.EndDate.Year == 0001)
{
return(GetApiResponseModel("Search Creteria Cannot Be Blank.", false, null));
}
DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new Controllers.ReportsController().GetStudentFeeModel(model);
List <DTO.LABURNUM.COM.StudentFeeModel> studentFeeList = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(studentFeeModel)).Map();
return(GetApiResponseModel("Successfully Performed.", true, studentFeeList));
}
else
{
return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null));
}
}
private void GetFeeAmountFrosmb()
{
ddlSessionName.Items.Clear();
SqlConnection con = new SqlConnection(cs);
SqlCommand csm = new SqlCommand("select SessionId from dbo.MasterFee where YearOfAdmission = @yearofadmission and DepttId = @depttid", con);
csm.Parameters.AddWithValue("@yearofadmission", lblBatch.Text);
csm.Parameters.AddWithValue("@depttid", FeeHelper2.ConvertDepartmentNameToId(lblDepttName.Text));
try
{
ListItem newItem = new ListItem();
newItem.Text = "<Select Session>";
newItem.Value = "0";
ddlSessionName.Items.Add(newItem);
con.Open();
SqlDataReader rdr = csm.ExecuteReader();
while (rdr.Read())
{
newItem = new ListItem();
newItem.Text = StudentFeeHelper.ConvertSessionIdToSessionName(rdr["SessionId"].ToString());
ddlSessionName.Items.Add(newItem);
//ddlSessionName.DataValueField = rdr["SessionId"].ToString();
}
rdr.Close();
}
catch (Exception)
{
}
finally
{
con.Close();
}
}
