public List <DTO.LABURNUM.COM.FeeReportingResultModel> SearchStudentReporting(DTO.LABURNUM.COM.FeeReportingModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
List <DTO.LABURNUM.COM.FeeReportingResultModel> report = new List <DTO.LABURNUM.COM.FeeReportingResultModel> ();
List <API.LABURNUM.COM.StudentFee> dbStudentFee = new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeModel()
{
AcademicYearId = model.AcademicYearId, StudentId = model.StudentId
});
List <API.LABURNUM.COM.StudentFeeDetail> dbstudentFeeDetails = new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
AcademicYearId = model.AcademicYearId, StudentId = model.StudentId
});
if (dbStudentFee.Count > 0)
{
report = new Component.FeeReportingResultModelHelper().GetFeeReportingResultModel(dbStudentFee[0], dbstudentFeeDetails);
}
//report.MonthlyFeeDetails = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeDetailModel() { AcademicYearId = model.AcademicYearId, StudentId = model.StudentId })).Map();
//double y = 0;
//foreach (DTO.LABURNUM.COM.StudentFeeDetailModel item in report.MonthlyFeeDetails)
//{
// y = y + item.TotalPayableAmount;
//}
//report.TotalPaidOnMonthly = y;
return(report);
}
else
{
return(null);
}
}
public long Add(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
long admissionTypeId = 0, cstatus = 0;
if (model.IsNewAdmission)
{
admissionTypeId = DTO.LABURNUM.COM.Utility.AdmissionType.GetValue(DTO.LABURNUM.COM.Utility.EnumAdmissionType.NEWADMISSION);
}
else
{
admissionTypeId = DTO.LABURNUM.COM.Utility.AdmissionType.GetValue(DTO.LABURNUM.COM.Utility.EnumAdmissionType.READMISSION);
}
if (model.ChequePaidAmount > 0)
{
cstatus = DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.SUBMITTED);
}
else
{
cstatus = model.ChequeStatus.GetValueOrDefault();
}
model.ChequeStatus = cstatus;
//model.StudentFeeId = new FrontEndApi.StudentFeeApi().GetStudentFeeId(model.ClassId, model.SectionId, model.StudentId, admissionTypeId);
long studentfeeDetailsId = new FrontEndApi.StudentFeeDetailApi().Add(model);
if (Component.Constants.DEFAULTVALUE.ISMAILSENDSTART)
{
sendmail(studentfeeDetailsId);
}
return(studentfeeDetailsId);
}
else
{
return(-1);
}
}
public DTO.LABURNUM.COM.StudentFeeDetailModel SearchPendingFeeReceiptData(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
DTO.LABURNUM.COM.StudentFeeDetailModel studentFeeDetailModel = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByID(model.StudentFeeDetailId)).MapSingle();
List <API.LABURNUM.COM.StudentFeeDetail> dbstudentfeeDetailList = new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentId = studentFeeDetailModel.StudentId, ClassId = studentFeeDetailModel.ClassId, SectionId = studentFeeDetailModel.SectionId, AcademicYearId = studentFeeDetailModel.AcademicYearId
});
int index = dbstudentfeeDetailList.FindIndex(x => x.StudentFeeDetailId == model.StudentFeeDetailId);
API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new StudentFeeDetail();
if (index >= 0)
{
index = index + 1;
dbstudentfeeDetails = dbstudentfeeDetailList[index];
}
if (dbstudentfeeDetails.ChequeStatus == DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.BOUNCE))
{
studentFeeDetailModel.LastPendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
studentFeeDetailModel.BounceChequePanelty = API.LABURNUM.COM.Component.Constants.DEFAULTVALUE.CHEQUEBOUNCEPANELTY;
studentFeeDetailModel.BounceChequeAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault();
}
else
{
studentFeeDetailModel.LastPendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
}
return(studentFeeDetailModel);
}
else
{
return(null);
}
}
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 API.LABURNUM.COM.StudentFeeDetail GetFeePaidDetailDuringMonthlyFeePayment(long studentId, long classId, long academicYear, long studentFeeDetailsId)
{
List <API.LABURNUM.COM.StudentFeeDetail> dbstudentfeeDetailList = new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentId = studentId, ClassId = classId, AcademicYearId = academicYear
});
int index = dbstudentfeeDetailList.FindIndex(x => x.StudentFeeDetailId == studentFeeDetailsId);
API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new StudentFeeDetail();
if (index >= 0)
{
index = index + 1;
dbstudentfeeDetails = dbstudentfeeDetailList[index];
}
return(dbstudentfeeDetails);
}
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 long Add(DTO.LABURNUM.COM.StudentFeeModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
long cstatus = 0;
if (model.ChequePaidAmount > 0)
{
cstatus = DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.SUBMITTED);
}
else
{
cstatus = model.ChequeStatus.GetValueOrDefault();
}
long studentFeeDetailsId = new FrontEndApi.StudentFeeDetailApi().Add(new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
CollectedById = model.CollectedById,
AcademicYearId = model.AcademicYearId,
DiscountAmount = model.DiscountAmount,
DiscountRemarks = model.DiscountRemarks,
StudentId = model.StudentId,
ClassId = model.ClassId,
SectionId = model.SectionId,
PayForTheMonth = new Component.Utility().GetISTDateTime().Month,
CashPaidAmount = model.CashPaidAmount,
ChequePaidAmount = model.ChequePaidAmount,
BankId = model.BankId,
ChequeDate = model.ChequeDate.GetValueOrDefault(),
ChequeNumber = model.ChequeNumber,
PendingFee = model.PendingFee,
ChequeStatus = cstatus
});
long studentfeeId = new FrontEndApi.StudentFeeApi().Add(model);
if (Component.Constants.DEFAULTVALUE.ISMAILSENDSTART)
{
sendmail(studentFeeDetailsId);
}
return(studentFeeDetailsId);
}
else
{
return(-1);
}
}
public DTO.LABURNUM.COM.StudentFeeDetailModel SearchMonthlyFeeReceiptData(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
DTO.LABURNUM.COM.StudentFeeDetailModel studentFeeDetailModel = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByID(model.StudentFeeDetailId)).MapSingle();
API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new FrontEndApi.StudentFeeDetailApi().GetFeePaidDetailDuringMonthlyFeePayment(studentFeeDetailModel.StudentId, studentFeeDetailModel.ClassId, studentFeeDetailModel.AcademicYearId, model.StudentFeeDetailId);
if (dbstudentfeeDetails.ChequeStatus == DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.BOUNCE))
{
studentFeeDetailModel.LastPendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
studentFeeDetailModel.BounceChequePanelty = API.LABURNUM.COM.Component.Constants.DEFAULTVALUE.CHEQUEBOUNCEPANELTY;
studentFeeDetailModel.BounceChequeAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault();
}
else
{
studentFeeDetailModel.LastPendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault();
}
return(studentFeeDetailModel);
}
else
{
return(null);
}
}
