public int AddEditFeeStructureHead(FeeStructure entity)
{
int i = 0;
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (entity != null && string.IsNullOrEmpty(entity.SchoolID))
{
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
}
if (string.IsNullOrEmpty(entity.FeeStructureHeadID))
{
entity.FeeStructureHeadID = Utility.GeneratorUniqueId(ID_PREFIX_CONSTANTS.FEE_STRUCTURE_HEAD_ID_PREFIX);
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
{
entity.CreatedByID = objUser.UserID;
entity.ModifiedByID = objUser.UserID;
}
else
{
entity.CreatedByID = "1";
entity.ModifiedByID = "1";
}
}
else
{
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
entity.ModifiedByID = objUser.UserID;
else
entity.ModifiedByID = "1";
}
string[] addParams = { FeeStructure_Constant.FEE_STRUCTURE_HEAD_ID,
FeeStructure_Constant.FEE_STRUCTURE_ID,
FeeStructure_Constant.FEE_HEAD_ID,
FeeStructure_Constant.INSTALLMENT_AMOUNT,
FeeStructure_Constant.NO_OF_INSTALLMENT,
FeeStructure_Constant.FIRST_INSTALLMENT_STARTS_FROM,
FeeStructure_Constant.TOTAL_FEES,
FeeStructure_Constant.CREATED_BY_ID,
FeeStructure_Constant.MODIFIED_BY_ID
};
i = _FeeStructureRepository.ExecuteNonQuery(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_UPS);
return i;
}
public FeeStructure GetFeeStructureHeadsDetailServiceTaxAmount(FeeStructure entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (entity != null && string.IsNullOrEmpty(entity.SchoolID))
{
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
}
string[] addParams = { FeeStructure_Constant.SCHOOL_ID, FeeStructure_Constant.AY_ID, FeeStructure_Constant.CLASS_ID, FeeStructure_Constant.FEE_STRUCTURE_HEAD_DETAIL_IDs };
return _FeeStructureRepository.Get(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_CALCULATE_SERVICE_TAX);
}
public object GetScalar(FeeStructure entity)
{
throw new NotImplementedException();
}
public IEnumerable<FeeStructure> GetFeeStructureHeadInstallmentsUpToDate(FeeStructure entity)
{
string[] addParams = { FeeStructure_Constant.AY_ID, FeeStructure_Constant.CLASS_ID, FeeStructure_Constant.STUDENT_ID, FeeStructure_Constant.FEE_UP_TO };
return _FeeStructureRepository.GetAll(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_SEL_BY_FEE_UP_TO);
}
public FeeStructure GetFeeStructureHeadsDetail(FeeStructure entity)
{
string[] addParams = { FeeStructure_Constant.FEE_STRUCTURE_HEAD_DETAIL_ID };
return _FeeStructureRepository.Get(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_SEL);
}
public FeeStructure GetFeeHeadOptionalEntryDueAmount(FeeStructure entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (entity != null && string.IsNullOrEmpty(entity.SchoolID))
{
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
}
string[] addParams = { FeeStructure_Constant.SCHOOL_ID, FeeStructure_Constant.STUDENT_ID, FeeStructure_Constant.AY_ID, FeeStructure_Constant.CLASS_ID, FeeStructure_Constant.FEE_HEAD_OPTIONAL_ENTRY_IDS };
return _FeeStructureRepository.Get(entity, addParams, FeeStructure_Constant.SPROC_FEE_HEAD_OPTIONAL_ENTRY_CALCULATE_DUES);
}
public IEnumerable<FeeStructure> GetFeeStructureByClass(FeeStructure entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
string[] addParams = { FeeStructure_Constant.SCHOOL_ID, FeeStructure_Constant.AY_ID, FeeStructure_Constant.CLASS_ID };
return _FeeStructureRepository.GetAll(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_SEL_BY_CLASS);
}
public IEnumerable<FeeStructure> GetAllFeeStructureHeadsDetail(FeeStructure entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, FeeStructure_Constant.FEE_STRUCTURE_HEAD_ID };
return _FeeStructureRepository.GetAll(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_LSTALL);
}
public FeeStructure Get(FeeStructure entity)
{
string[] addParams = { FeeStructure_Constant.FEE_STRUCTURE_ID };
return _FeeStructureRepository.Get(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_SEL);
}
public int DeleteFeeStructureHeadsDetail(FeeStructure entity)
{
int i = 0;
string[] addParams = { FeeStructure_Constant.FEE_STRUCTURE_HEAD_DETAIL_ID };
i = _FeeStructureRepository.ExecuteNonQuery(entity, addParams, FeeStructure_Constant.SPROC_FEE_STRUCTURE_HEADS_DETAIL_DEL);
return i;
}
public ActionResult AddEditFeeStructureHead(FeeListViewModel model)
{
FillDDForFeeStructureHeads();
string strSuccessMsg = string.Empty;
string strErrorMsg = string.Empty;
if (model != null && model.FeeStructure != null)
{
if (string.IsNullOrEmpty(model.FeeStructure.FeeStructureHeadID))
{
strSuccessMsg = FeeRes.MsgAddSuccess;
strErrorMsg = FeeRes.MsgAddError;
}
else
{
strSuccessMsg = FeeRes.MsgEditSuccess;
strErrorMsg = FeeRes.MsgEditError;
}
int i = _FeeStructureService.AddEditFeeStructureHead(model.FeeStructure);
if( i > 0)
{
#region Add Fee Installments
if (!string.IsNullOrEmpty(model.FeeStructure.FeeStructureHeadID))
{
_FeeStructureService.DeleteByFSHID(model.FeeStructure);
DateTime dtFirstInstallmentDate = DateTime.Now.Date;
if( !string.IsNullOrEmpty( Convert.ToString(model.FeeStructure.FirstInstallmentStartsFrom)))
dtFirstInstallmentDate = model.FeeStructure.FirstInstallmentStartsFrom;
for (int j = 1; j <= model.FeeStructure.NoOfInstallment; j++)
{
FeeStructure objFeeInstallment = new FeeStructure();
objFeeInstallment.FeeStructureHeadID = model.FeeStructure.FeeStructureHeadID;
objFeeInstallment.InstallmentNo = j;
objFeeInstallment.InstallmentDate = Convert.ToDateTime(dtFirstInstallmentDate.ToShortDateString());
objFeeInstallment.Amount = model.FeeStructure.InstallmentAmount;
dtFirstInstallmentDate = dtFirstInstallmentDate.AddMonths(6);
int k = _FeeStructureService.AddEditFeeStructureHeadsDetail(objFeeInstallment);
}
}
#endregion
}
if (i <= 0)
{
TempData["err"] = strErrorMsg;
}
else
{
TempData["msg"] = strSuccessMsg;
}
}
return RedirectToAction("ManageFeeStructureHeads", "FeeStructure", new { pFeeStructureID = model.FeeStructure.FeeStructureID });
}
public IEnumerable<FeeStructure> GetAllFeeReceiptHeadDue(FeeStructure entity)
{
string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, FeeReceipt_Constant.FEE_RECEIPT_ID };
return _FeeStructureRepository.GetAll(entity, addParams, FeeReceipt_Constant.SPROC_FEE_RECEIPTS_HEADS_DUES_LSTALL);
}
