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 void UpdateStatus(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.StudentFeeDetailApi().UpdateIsActive(model);
}
}
public void Update(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
model.StudentFeeDetailId.TryValidate();
IQueryable <API.LABURNUM.COM.StudentFeeDetail> iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeDetailId == model.StudentFeeDetailId && x.IsActive == true);
List <API.LABURNUM.COM.StudentFeeDetail> dbStudentFeeDetails = iQuery.ToList();
if (dbStudentFeeDetails.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbStudentFeeDetails.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbStudentFeeDetails[0].StudentId = model.StudentId;
dbStudentFeeDetails[0].ClassId = model.ClassId;
dbStudentFeeDetails[0].SectionId = model.SectionId;
dbStudentFeeDetails[0].MonthlyFee = model.MonthlyFee;
dbStudentFeeDetails[0].LateFee = model.LateFee;
dbStudentFeeDetails[0].TransportFee = model.TransportFee;
// dbStudentFeeDetails[0].AnnualFunctionFee = model.AnnualFunctionFee;
dbStudentFeeDetails[0].CashPaidAmount = model.CashPaidAmount;
dbStudentFeeDetails[0].BankId = model.BankId;
dbStudentFeeDetails[0].ChequeDate = model.ChequeDate;
dbStudentFeeDetails[0].ChequeNumber = model.ChequeNumber;
dbStudentFeeDetails[0].ChequePaidAmount = model.ChequePaidAmount;
dbStudentFeeDetails[0].ChequeStatus = model.ChequeStatus;
dbStudentFeeDetails[0].PayForTheMonth = model.PayForTheMonth;
dbStudentFeeDetails[0].PendingFee = model.PendingFee;
dbStudentFeeDetails[0].DiscountAmount = model.DiscountAmount;
dbStudentFeeDetails[0].DiscountRemarks = model.DiscountRemarks;
dbStudentFeeDetails[0].CollectedById = model.CollectedById;
dbStudentFeeDetails[0].LastUpdated = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
private DTO.LABURNUM.COM.StudentFeeDetailModel MapCore(API.LABURNUM.COM.StudentFeeDetail studentFeeDetail)
{
DTO.LABURNUM.COM.StudentFeeDetailModel dtoStudentFeeDetail = new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentId = studentFeeDetail.StudentId,
StudentFeeDetailId = studentFeeDetail.StudentFeeDetailId,
MonthlyFee = studentFeeDetail.MonthlyFee,
LateFee = studentFeeDetail.LateFee,
TransportFee = studentFeeDetail.TransportFee,
//AnnualFunctionFee = studentFeeDetail.AnnualFunctionFee,
ChequeBankName = studentFeeDetail.Bank.BankName,
BankId = studentFeeDetail.BankId,
CashPaidAmount = studentFeeDetail.CashPaidAmount.GetValueOrDefault(),
ChequeNumber = studentFeeDetail.ChequeNumber,
ChequeStatus = studentFeeDetail.ChequeStatus,
ChequeDate = studentFeeDetail.ChequeDate,
ChequePaidAmount = studentFeeDetail.ChequePaidAmount.GetValueOrDefault(),
CollectedById = studentFeeDetail.CollectedById,
ClassId = studentFeeDetail.ClassId,
SectionId = studentFeeDetail.SectionId,
PendingFee = studentFeeDetail.PendingFee,
DiscountAmount = studentFeeDetail.DiscountAmount,
DiscountRemarks = studentFeeDetail.DiscountRemarks,
CreatedOn = studentFeeDetail.CreatedOn,
IsActive = studentFeeDetail.IsActive,
LastUpdated = studentFeeDetail.LastUpdated,
CollectedByName = studentFeeDetail.Faculty.FacultyName,
FatherName = studentFeeDetail.Student.FatherName,
StudentName = studentFeeDetail.Student.FirstName + " " + studentFeeDetail.Student.MiddleName + " " + studentFeeDetail.Student.LastName,
ClassName = studentFeeDetail.Class.ClassName,
SectionName = studentFeeDetail.Section.SectionName,
TotalPayableAmount = (studentFeeDetail.MonthlyFee + studentFeeDetail.LateFee + studentFeeDetail.TransportFee.GetValueOrDefault()) - studentFeeDetail.DiscountAmount,
AcademicYearId = studentFeeDetail.AcademicYearId,
AcademicYear = studentFeeDetail.AcademicYearTable.StartYear + "-" + studentFeeDetail.AcademicYearTable.EndYear,
ChequeBounceRemarks = studentFeeDetail.ChequeBounceRemarks,
StudentAdmissionNumber = studentFeeDetail.Student.AdmissionNumber,
MonthName = studentFeeDetail.PayForTheMonth.GetValueOrDefault() != 0 ? studentFeeDetail.Month.MonthName : "",
PayForTheMonth = studentFeeDetail.PayForTheMonth.GetValueOrDefault(),
};
if (studentFeeDetail.ChequeStatusMaster != null)
{
dtoStudentFeeDetail.ChequeStatusName = studentFeeDetail.ChequeStatusMaster.TextToDisplay;
}
if (studentFeeDetail.ChequeStatus == DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.BOUNCE))
{
dtoStudentFeeDetail.LastPendingFee = dtoStudentFeeDetail.PendingFee.GetValueOrDefault() + dtoStudentFeeDetail.ChequePaidAmount + Component.Constants.DEFAULTVALUE.CHEQUEBOUNCEPANELTY;
dtoStudentFeeDetail.BounceChequeAmount = dtoStudentFeeDetail.ChequePaidAmount;
dtoStudentFeeDetail.BounceChequeNumber = dtoStudentFeeDetail.ChequeNumber;
dtoStudentFeeDetail.BounceChequeBankName = dtoStudentFeeDetail.ChequeBankName;
dtoStudentFeeDetail.ChequeStatusName = dtoStudentFeeDetail.ChequeStatusName;
dtoStudentFeeDetail.BounceChequeDate = dtoStudentFeeDetail.ChequeDate.GetValueOrDefault();
dtoStudentFeeDetail.BounceChequePanelty = Component.Constants.DEFAULTVALUE.CHEQUEBOUNCEPANELTY;
}
else
{
dtoStudentFeeDetail.LastPendingFee = dtoStudentFeeDetail.PendingFee.GetValueOrDefault();
}
return(dtoStudentFeeDetail);
}
public long Add(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.StudentFeeDetailApi().Add(model));
}
else
{
return(-1);
}
}
public DTO.LABURNUM.COM.StudentFeeDetailModel SearchPendingFee(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
model.SectionId = 0;
return(new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetPendingFee(model)).MapSingle());
}
else
{
return(null);
}
}
public bool UpdateChequeStatus(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
DTO.LABURNUM.COM.StudentFeeDetailModel dtomodel = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().UpdateChequeStatus(model.StudentFeeDetailId, model.ChequeStatus.GetValueOrDefault(), model.ChequeBounceRemarks)).MapSingle();
SendChequeStatusUpdateEmail(dtomodel.StudentFeeDetailId);
return(true);
}
else
{
return(false);
}
}
//public double GetPendingFee(DTO.LABURNUM.COM.StudentFeeDetailModel model)
//{
// double pendingFee = 0;
// List<API.LABURNUM.COM.StudentFeeDetail> dblist = GetStudentFeeDetailByAdvanceSearch(model);
// if (dblist.Count > 0)
// {
// if (dblist[0].ChequeStatus == DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.BOUNCE)) { pendingFee = pendingFee + dblist[0].ChequePaidAmount.GetValueOrDefault(); }
// else { pendingFee = dblist[0].PendingFee.GetValueOrDefault(); }
// }
// return pendingFee;
//}
public API.LABURNUM.COM.StudentFeeDetail GetPendingFee(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
//double pendingFee = 0;
List <API.LABURNUM.COM.StudentFeeDetail> dblist = GetStudentFeeDetailByAdvanceSearch(model);
//if (dblist.Count > 0)
//{
// if (dblist[0].ChequeStatus == DTO.LABURNUM.COM.Utility.ChequeStatusMaster.GetChequeStatusMasterId(DTO.LABURNUM.COM.Utility.EnumChequeStatusMaster.BOUNCE)) { pendingFee = pendingFee + dblist[0].ChequePaidAmount.GetValueOrDefault(); }
// else { pendingFee = dblist[0].PendingFee.GetValueOrDefault(); }
//}
if (dblist.Count == 0)
{
throw new Exception(Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
return(dblist[0]);
}
private List <API.LABURNUM.COM.StudentFeeDetail> GetStudenFeeDetails(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
List <API.LABURNUM.COM.StudentFeeDetail> dbstudentFeeDetails = new List <StudentFeeDetail>();
API.LABURNUM.COM.StudentFeeDetail apiSFD = new StudentFeeDetail()
{
MonthlyFee = model.MonthlyFee,
//AnnualFunctionFee = model.AnnualFunctionFee,
LateFee = model.LateFee,
PendingFee = model.PendingFee,
IsActive = true,
CreatedOn = new Component.Utility().GetISTDateTime(),
};
dbstudentFeeDetails.Add(apiSFD);
return(dbstudentFeeDetails);
}
private long AddStudentFeeDetail(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (model.ChequeDate.GetValueOrDefault().Year == 0001)
{
model.ChequeDate = null;
}
else
{
if (model.ChequePaidAmount <= 0)
{
model.ChequeDate = null;
}
}
if (model.PayForTheMonth == 0)
{
model.PayForTheMonth = null;
}
API.LABURNUM.COM.StudentFeeDetail apiStudentFeeDetail = new StudentFeeDetail()
{
StudentId = model.StudentId,
ClassId = model.ClassId,
SectionId = model.SectionId,
MonthlyFee = model.MonthlyFee,
// AnnualFunctionFee = model.AnnualFunctionFee,
CashPaidAmount = model.CashPaidAmount,
BankId = model.BankId,
ChequeDate = model.ChequeDate,
ChequeNumber = model.ChequeNumber,
ChequePaidAmount = model.ChequePaidAmount,
ChequeStatus = model.ChequeStatus,
LateFee = model.LateFee,
PendingFee = model.PendingFee,
TransportFee = model.TransportFee,
DiscountAmount = model.DiscountAmount,
DiscountRemarks = model.DiscountRemarks,
PayForTheMonth = model.PayForTheMonth,
CollectedById = model.CollectedById,
AcademicYearId = model.AcademicYearId,
CreatedOn = new Component.Utility().GetISTDateTime(),
IsActive = true
};
this._laburnum.StudentFeeDetails.Add(apiStudentFeeDetail);
this._laburnum.SaveChanges();
return(apiStudentFeeDetail.StudentFeeDetailId);
}
private long AddStudentFeeDetail(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
API.LABURNUM.COM.StudentFeeDetail apiStudentFeeDetail = new StudentFeeDetail()
{
StudentFeeId = model.StudentFeeId,
AdmissionFee = model.AdmissionFee,
AnnualCharges = model.AnnualCharges,
DevelopementCharges = model.DevelopementCharges,
ExamFee = model.ExamFee,
MonthlyFee = model.MonthlyFee,
SportsFee = model.SportsFee,
CreatedOn = System.DateTime.Now,
IsActive = true
};
this._laburnum.StudentFeeDetails.Add(apiStudentFeeDetail);
this._laburnum.SaveChanges();
return(apiStudentFeeDetail.StudentFeeDetailId);
}
private DTO.LABURNUM.COM.StudentFeeDetailModel MapCore(API.LABURNUM.COM.StudentFeeDetail studentFeeDetail)
{
DTO.LABURNUM.COM.StudentFeeDetailModel dtoStudentFeeDetail = new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentFeeDetailId = studentFeeDetail.StudentFeeDetailId,
StudentFeeId = studentFeeDetail.StudentFeeId,
AdmissionFee = studentFeeDetail.AdmissionFee,
AnnualCharges = studentFeeDetail.AnnualCharges,
DevelopementCharges = studentFeeDetail.DevelopementCharges,
ExamFee = studentFeeDetail.ExamFee,
MonthlyFee = studentFeeDetail.MonthlyFee,
SportsFee = studentFeeDetail.SportsFee,
CreatedOn = studentFeeDetail.CreatedOn,
IsActive = studentFeeDetail.IsActive,
LastUpdated = studentFeeDetail.LastUpdated
};
return(dtoStudentFeeDetail);
}
public void UpdateIsActive(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
model.StudentFeeDetailId.TryValidate();
IQueryable <API.LABURNUM.COM.StudentFeeDetail> iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeDetailId == model.StudentFeeDetailId && x.IsActive == true);
List <API.LABURNUM.COM.StudentFeeDetail> dbStudentFeeDetails = iQuery.ToList();
if (dbStudentFeeDetails.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbStudentFeeDetails.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbStudentFeeDetails[0].IsActive = model.IsActive;
dbStudentFeeDetails[0].LastUpdated = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
private void sendmail(long studentfeeDetailId)
{
//DTO.LABURNUM.COM.StudentFeeDetailModel studentfeeDetail = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByID(studentfeeDetailId)).MapSingle();
DTO.LABURNUM.COM.StudentFeeDetailModel model = new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentFeeDetailId = studentfeeDetailId
};
model.ApiClientModel.UserName = Component.Constants.APIACCESS.APIUSERNAME;
model.ApiClientModel.Password = Component.Constants.APIACCESS.APIPASSWORD;
model = SearchMonthlyFeeReceiptData(model);
DTO.LABURNUM.COM.StudentModel studentmodel = new StudentHelper(new FrontEndApi.StudentApi().GetStudentByStudentId(model.StudentId)).MapSingle();
string from = Component.Constants.MAIL.MAILSENTFROM;
string subject = "Thank you For Paying Fee For the Month Of " + model.MonthName + "-" + new Component.Utility().GetISTDateTime().Year + " At Laburnum Public School.";
string body = new API.LABURNUM.COM.Component.HtmlHelper().RenderViewToString("User", "~/Views/Partial/ThankYouMailOnPaymentOfMonthlyFee.cshtml", model);
if (new Component.Mailer().MailSend(studentmodel.EmailId, "", body, from, subject))
{
}
else
{
}
}
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);
}
}
private void sendmail(long studentFeeDetailsId)
{
DTO.LABURNUM.COM.StudentFeeDetailModel smodel = new DTO.LABURNUM.COM.StudentFeeDetailModel()
{
StudentFeeDetailId = studentFeeDetailsId
};
smodel.ApiClientModel.UserName = Component.Constants.APIACCESS.APIUSERNAME;;
smodel.ApiClientModel.Password = Component.Constants.APIACCESS.APIPASSWORD;;
DTO.LABURNUM.COM.StudentFeeModel model = SearchAdmissionFeeReceiptDataByDetailId(smodel);
//DTO.LABURNUM.COM.StudentFeeDetailModel studentfeeDetail = new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetFeePaidDetailDuringAdmission(studentId, classId, sectionId, academicyearId)).MapSingle();
DTO.LABURNUM.COM.StudentModel studentmodel = new StudentHelper(new FrontEndApi.StudentApi().GetStudentByStudentId(model.StudentId)).MapSingle();
model.StudentFeeId = studentFeeDetailsId;
string from = Component.Constants.MAIL.MAILSENTFROM;
string subject = Component.Constants.MAILSUBJECT.ADMISSIONSUBJECT;
string body = new API.LABURNUM.COM.Component.HtmlHelper().RenderViewToString("User", "~/Views/Partial/NewAdmissionThankyouEmail.cshtml", model);
if (new Component.Mailer().MailSend(studentmodel.EmailId, "", body, from, subject))
{
}
else
{
}
}
public void Update(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
model.StudentFeeDetailId.TryValidate();
IQueryable <API.LABURNUM.COM.StudentFeeDetail> iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeDetailId == model.StudentFeeDetailId && x.IsActive == true);
List <API.LABURNUM.COM.StudentFeeDetail> dbStudentFeeDetails = iQuery.ToList();
if (dbStudentFeeDetails.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbStudentFeeDetails.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbStudentFeeDetails[0].StudentFeeId = model.StudentFeeId;
dbStudentFeeDetails[0].AdmissionFee = model.AdmissionFee;
dbStudentFeeDetails[0].AnnualCharges = model.AnnualCharges;
dbStudentFeeDetails[0].DevelopementCharges = model.DevelopementCharges;
dbStudentFeeDetails[0].ExamFee = model.ExamFee;
dbStudentFeeDetails[0].SportsFee = model.SportsFee;
dbStudentFeeDetails[0].MonthlyFee = model.MonthlyFee;
dbStudentFeeDetails[0].LastUpdated = System.DateTime.Now;
this._laburnum.SaveChanges();
}
public List <DTO.LABURNUM.COM.StudentFeeDetailModel> SearchStudentFeeDetailByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new StudentFeeDetailHelper(new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
public List <API.LABURNUM.COM.StudentFeeDetail> GetStudentFeeDetailByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
IQueryable <API.LABURNUM.COM.StudentFeeDetail> iQuery = null;
if (model.StudentFeeDetailId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeDetailId == model.StudentFeeDetailId && x.IsActive == true);
}
if (iQuery != null)
{
if (model.StudentFeeId > 0)
{
iQuery = iQuery.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
}
}
else
{
if (model.StudentFeeId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
}
}
List <API.LABURNUM.COM.StudentFeeDetail> dbStudentFeeDetails = iQuery.ToList();
return(dbStudentFeeDetails);
}
public List <API.LABURNUM.COM.StudentFeeDetail> GetStudentFeeDetailByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
IQueryable <API.LABURNUM.COM.StudentFeeDetail> iQuery = null;
if (model.StudentFeeDetailId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentFeeDetailId == model.StudentFeeDetailId && x.IsActive == true);
}
//Search By Academic Year Id.
if (iQuery != null)
{
if (model.AcademicYearId > 0)
{
iQuery = iQuery.Where(x => x.AcademicYearId == model.AcademicYearId && x.IsActive == true);
}
}
else
{
if (model.AcademicYearId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.AcademicYearId == model.AcademicYearId && x.IsActive == true);
}
}
//Search By StudentId.
if (iQuery != null)
{
if (model.StudentId > 0)
{
iQuery = iQuery.Where(x => x.StudentId == model.StudentId && x.IsActive == true);
}
}
else
{
if (model.StudentId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.StudentId == model.StudentId && x.IsActive == true);
}
}
//Search By ClassId.
if (iQuery != null)
{
if (model.ClassId > 0)
{
iQuery = iQuery.Where(x => x.ClassId == model.ClassId && x.IsActive == true);
}
}
else
{
if (model.ClassId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.ClassId == model.ClassId && x.IsActive == true);
}
}
//Search By SectionId.
if (iQuery != null)
{
if (model.SectionId > 0)
{
iQuery = iQuery.Where(x => x.SectionId == model.SectionId && x.IsActive == true);
}
}
else
{
if (model.SectionId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.SectionId == model.SectionId && x.IsActive == true);
}
}
//Search By Paid Month.
if (iQuery != null)
{
if (model.PayForTheMonth > 0)
{
iQuery = iQuery.Where(x => x.PayForTheMonth == model.PayForTheMonth && x.IsActive == true);
}
}
else
{
if (model.PayForTheMonth > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.PayForTheMonth == model.PayForTheMonth && x.IsActive == true);
}
}
//Search By Cheque Status id.
if (iQuery != null)
{
if (model.ChequeStatus > 0)
{
iQuery = iQuery.Where(x => x.ChequeStatus == model.ChequeStatus && x.IsActive == true);
}
}
else
{
if (model.ChequeStatus > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.ChequeStatus == model.ChequeStatus && x.IsActive == true);
}
}
//Search By Collected By id.
if (iQuery != null)
{
if (model.CollectedById > 0)
{
iQuery = iQuery.Where(x => x.CollectedById == model.CollectedById && x.IsActive == true);
}
}
else
{
if (model.CollectedById > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.CollectedById == model.CollectedById && x.IsActive == true);
}
}
//Search By Bank id.
if (iQuery != null)
{
if (model.BankId > 0)
{
iQuery = iQuery.Where(x => x.BankId == model.BankId && x.IsActive == true);
}
}
else
{
if (model.BankId > 0)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.BankId == model.BankId && x.IsActive == true);
}
}
//Search By Cheque No.
if (iQuery != null)
{
if (model.ChequeNumber != null)
{
iQuery = iQuery.Where(x => x.ChequeNumber.Equals(model.ChequeNumber) && x.IsActive == true);
}
}
else
{
if (model.ChequeNumber != null)
{
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.ChequeNumber.Equals(model.ChequeNumber) && x.IsActive == true);
}
}
//Search By Cheque Date.
//if (iQuery != null)
//{
// if (model.ChequeDate.GetValueOrDefault().Year != 0001)
// {
// if (model.ChequeDate.GetValueOrDefault().Year != 0001) { model.ChequeSearchEndDate = model.ChequeDate.GetValueOrDefault().AddDays(1).AddSeconds(-1); }
// iQuery = iQuery.Where(x => x.ChequeDate.GetValueOrDefault() >= model.ChequeDate.GetValueOrDefault() && x.ChequeDate.GetValueOrDefault() <= model.ChequeSearchEndDate && x.IsActive == true);
// }
//}
//else
//{
// if (model.ChequeDate.GetValueOrDefault().Year != 0001)
// {
// if (model.ChequeDate.GetValueOrDefault().Year != 0001) { model.ChequeSearchEndDate = model.ChequeDate.GetValueOrDefault().AddDays(1).AddSeconds(-1); }
// iQuery = this._laburnum.StudentFeeDetails.Where(x => x.ChequeDate.GetValueOrDefault() >= model.ChequeDate.GetValueOrDefault() && x.ChequeDate.GetValueOrDefault() <= model.ChequeSearchEndDate && x.IsActive == true);
// }
//}
//Search By Date Range.
if (iQuery != null)
{
if (model.StartDate.Year != 0001)
{
model.StartDate = new Component.Utility().GetDate(model.StartDate);
if (model.EndDate.Year != 0001)
{
model.EndDate = new Component.Utility().GetDate(model.EndDate).AddDays(1).AddSeconds(-1);
}
if (model.EndDate.Year == 0001)
{
model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1);
}
iQuery = iQuery.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
}
}
else
{
if (model.StartDate.Year != 0001)
{
model.StartDate = new Component.Utility().GetDate(model.StartDate);
if (model.EndDate.Year != 0001)
{
model.EndDate = new Component.Utility().GetDate(model.EndDate).AddDays(1).AddSeconds(-1);
}
if (model.EndDate.Year == 0001)
{
model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1);
}
iQuery = this._laburnum.StudentFeeDetails.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
}
}
List <API.LABURNUM.COM.StudentFeeDetail> dbStudentFeeDetails = iQuery.OrderByDescending(x => x.StudentFeeDetailId).ToList();
return(dbStudentFeeDetails);
}
public static void TryValidate(this DTO.LABURNUM.COM.StudentFeeDetailModel item)
{
item.StudentId.TryValidate();
item.ClassId.TryValidate();
item.SectionId.TryValidate();
}
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 long Add(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
return(AddValidation(model));
}
private long AddValidation(DTO.LABURNUM.COM.StudentFeeDetailModel model)
{
model.TryValidate();
return(AddStudentFeeDetail(model));
}
