private long AddStudentFee(DTO.LABURNUM.COM.StudentFeeModel model)
{
API.LABURNUM.COM.StudentFee apiStudentFee = new StudentFee()
{
StudentId = model.StudentId,
AdmissionTypeId = model.AdmissionTypeId,
ClassId = model.ClassId,
SectionId = model.SectionId,
AdmissionFee = model.AdmissionFee,
AnnualCharges = model.AnnualCharges,
DevelopementFee = model.DevelopementFee,
ExamFee = model.ExamFee,
SecurityFee = model.SecurityFee,
SportsFee = model.SportsFee,
AnnualFunctionFee = model.AnnualFunctionFee,
DiscountAmount = model.DiscountAmount,
DiscountRemarks = model.DiscountRemarks,
CollectedById = model.CollectedById,
CreatedOn = new Component.Utility().GetISTDateTime(),
AcademicYearId = model.AcademicYearId,
IsActive = true,
};
this._laburnum.StudentFees.Add(apiStudentFee);
this._laburnum.SaveChanges();
return(apiStudentFee.StudentFeeId);
}
public void Update(DTO.LABURNUM.COM.StudentFeeModel model)
{
model.StudentFeeId.TryValidate();
IQueryable <API.LABURNUM.COM.StudentFee> iQuery = this._laburnum.StudentFees.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
List <API.LABURNUM.COM.StudentFee> dbStudentFees = iQuery.ToList();
if (dbStudentFees.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbStudentFees.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbStudentFees[0].ClassId = model.ClassId;
dbStudentFees[0].AdmissionTypeId = model.AdmissionTypeId;
dbStudentFees[0].StudentId = model.StudentId;
dbStudentFees[0].SectionId = model.SectionId;
dbStudentFees[0].AdmissionFee = model.AdmissionFee;
dbStudentFees[0].AnnualCharges = model.AnnualCharges;
dbStudentFees[0].DevelopementFee = model.DevelopementFee;
dbStudentFees[0].ExamFee = model.ExamFee;
dbStudentFees[0].SecurityFee = model.SecurityFee;
dbStudentFees[0].SportsFee = model.SportsFee;
dbStudentFees[0].AnnualFunctionFee = model.AnnualFunctionFee;
dbStudentFees[0].DiscountAmount = model.DiscountAmount;
dbStudentFees[0].DiscountRemarks = model.DiscountRemarks;
dbStudentFees[0].CollectedById = model.CollectedById;
dbStudentFees[0].LastUpdated = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
private DTO.LABURNUM.COM.StudentFeeModel MapCore(API.LABURNUM.COM.StudentFee studentFee)
{
DTO.LABURNUM.COM.StudentFeeModel dtoStudentFee = new DTO.LABURNUM.COM.StudentFeeModel()
{
StudentFeeId = studentFee.StudentFeeId,
ClassId = studentFee.ClassId,
AdmissionTypeId = studentFee.AdmissionTypeId,
AdmissionFee = studentFee.AdmissionFee,
DevelopementFee = studentFee.DevelopementFee,
AnnualCharges = studentFee.AnnualCharges,
ExamFee = studentFee.ExamFee,
SportsFee = studentFee.SportsFee,
SecurityFee = studentFee.SecurityFee,
StudentId = studentFee.StudentId,
AnnualFunctionFee = studentFee.AnnualFunctionFee,
CollectedById = studentFee.CollectedById,
SectionId = studentFee.SectionId,
CreatedOn = studentFee.CreatedOn,
IsActive = studentFee.IsActive,
LastUpdated = studentFee.LastUpdated,
AcademicYearId = studentFee.AcademicYearId,
ClassName = studentFee.Class.ClassName,
StudentName = studentFee.Student.FirstName + " " + studentFee.Student.MiddleName + " " + studentFee.Student.LastName,
SectionName = studentFee.Section.SectionName,
DiscountAmount = studentFee.DiscountAmount,
DiscountRemarks = studentFee.DiscountRemarks,
TotalPayableAmount = (studentFee.AdmissionFee + studentFee.DevelopementFee + studentFee.AnnualCharges + studentFee.ExamFee + studentFee.SportsFee + studentFee.SecurityFee + studentFee.AnnualFunctionFee.GetValueOrDefault()) - studentFee.DiscountAmount,
CollectedByName = studentFee.Faculty.FacultyName,
ParentName = studentFee.Student.FatherName,
AcademicYear = studentFee.AcademicYearTable.StartYear + "-" + studentFee.AcademicYearTable.EndYear,
StudentAdmissionNumber = studentFee.Student.AdmissionNumber,
};
return(dtoStudentFee);
}
public void UpdateStatus(DTO.LABURNUM.COM.StudentFeeModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.StudentFeeApi().UpdateIsActive(model);
}
}
public List <DTO.LABURNUM.COM.StudentFeeModel> SearchStudentByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
public long Add(DTO.LABURNUM.COM.StudentFeeModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.StudentFeeApi().Add(model));
}
else
{
return(-1);
}
}
public DTO.LABURNUM.COM.StudentFeeModel GetStudentFeeModel(DTO.LABURNUM.COM.FeeReportingModel model)
{
DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new DTO.LABURNUM.COM.StudentFeeModel()
{
ClassId = model.ClassId,
StudentId = model.StudentId,
SectionId = model.SectionId,
StartDate = model.StartDate,
EndDate = model.EndDate
};
return(studentFeeModel);
}
private long AddStudentFee(DTO.LABURNUM.COM.StudentFeeModel model)
{
API.LABURNUM.COM.StudentFee apiStudentFee = new StudentFee()
{
StudentId = model.StudentId,
AdmissionTypeId = model.AdmissionTypeId,
ClassId = model.ClassId,
CreatedOn = System.DateTime.Now,
IsActive = true
};
this._laburnum.StudentFees.Add(apiStudentFee);
this._laburnum.SaveChanges();
return(apiStudentFee.ClassId);
}
private DTO.LABURNUM.COM.StudentFeeModel MapCore(API.LABURNUM.COM.StudentFee studentFee)
{
DTO.LABURNUM.COM.StudentFeeModel dtoStudentFee = new DTO.LABURNUM.COM.StudentFeeModel()
{
StudentFeeId = studentFee.StudentFeeId,
ClassId = studentFee.ClassId,
AdmissionTypeId = studentFee.AdmissionTypeId,
StudentId = studentFee.StudentId,
CreatedOn = studentFee.CreatedOn,
IsActive = studentFee.IsActive,
LastUpdated = studentFee.LastUpdated
};
return(dtoStudentFee);
}
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 void UpdateIsActive(DTO.LABURNUM.COM.StudentFeeModel model)
{
model.StudentFeeId.TryValidate();
IQueryable <API.LABURNUM.COM.StudentFee> iQuery = this._laburnum.StudentFees.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
List <API.LABURNUM.COM.StudentFee> dbStudentFees = iQuery.ToList();
if (dbStudentFees.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbStudentFees.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbStudentFees[0].IsActive = model.IsActive;
dbStudentFees[0].LastUpdated = System.DateTime.Now;
this._laburnum.SaveChanges();
}
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);
}
}
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 long Add(DTO.LABURNUM.COM.StudentFeeModel model)
{
return(AddValidation(model));
}
private long AddValidation(DTO.LABURNUM.COM.StudentFeeModel model)
{
model.TryValidate();
return(AddStudentFee(model));
}
public List <API.LABURNUM.COM.StudentFee> GetStudentFeeByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeModel model)
{
IQueryable <API.LABURNUM.COM.StudentFee> iQuery = null;
//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.StudentFees.Where(x => x.AcademicYearId == model.AcademicYearId && x.IsActive == true);
}
}
//Search By Student Fee Id.
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.StudentFees.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
}
}
//Search By Admission Type Id.
if (iQuery != null)
{
if (model.AdmissionTypeId > 0)
{
iQuery = iQuery.Where(x => x.AdmissionTypeId == model.AdmissionTypeId && x.IsActive == true);
}
}
else
{
if (model.AdmissionTypeId > 0)
{
iQuery = this._laburnum.StudentFees.Where(x => x.AdmissionTypeId == model.AdmissionTypeId && x.IsActive == true);
}
}
//Search By Student Id.
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.StudentFees.Where(x => x.StudentId == model.StudentId && x.IsActive == true);
}
}
//Search By Class Id.
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.StudentFees.Where(x => x.ClassId == model.ClassId && x.IsActive == true);
}
}
//Search By Section Id.
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.StudentFees.Where(x => x.SectionId == model.SectionId && 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.StudentFees.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
}
}
List <API.LABURNUM.COM.StudentFee> dbStudentFee = iQuery.OrderByDescending(x => x.StudentFeeId).ToList();
return(dbStudentFee);
}
public List <API.LABURNUM.COM.StudentFee> GetStudentFeeByAdvanceSearch(DTO.LABURNUM.COM.StudentFeeModel model)
{
IQueryable <API.LABURNUM.COM.StudentFee> iQuery = null;
//Search By Student Fee Id.
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.StudentFees.Where(x => x.StudentFeeId == model.StudentFeeId && x.IsActive == true);
}
}
//Search By Admission Type Id.
if (iQuery != null)
{
if (model.AdmissionTypeId > 0)
{
iQuery = iQuery.Where(x => x.AdmissionTypeId == model.AdmissionTypeId && x.IsActive == true);
}
}
else
{
if (model.AdmissionTypeId > 0)
{
iQuery = this._laburnum.StudentFees.Where(x => x.AdmissionTypeId == model.AdmissionTypeId && x.IsActive == true);
}
}
//Search By Student Id.
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.StudentFees.Where(x => x.StudentId == model.StudentId && x.IsActive == true);
}
}
//Search By Class Id.
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.StudentFees.Where(x => x.ClassId == model.ClassId && x.IsActive == true);
}
}
List <API.LABURNUM.COM.StudentFee> dbStudentFee = iQuery.ToList();
return(dbStudentFee);
}
public static void TryValidate(this DTO.LABURNUM.COM.StudentFeeModel item)
{
item.StudentId.TryValidate();
item.AdmissionTypeId.TryValidate();
item.ClassId.TryValidate();
}
