public ActionResult AddEditFeeStructure(int id = 0) { var fsm = new FeeStructureModel(); var feeHeadClassList = new List <FeeHeadClass>(); var matchFeeStructureId = _Context.StudentFeeCollections.Any(x => x.FK_FeeStructurId == id && x.FeeCancellationDate == null); if (matchFeeStructureId == true) { TempData["errMsg"] = "You can not perform this operation."; return(RedirectToAction("Error")); } var matchFeeStructureIdInFeeSchedule = _Context.StudentFeeSchedules.Any(x => x.FK_FeeStructurId == id); if (matchFeeStructureIdInFeeSchedule == true) { TempData["errMsg"] = "You can not perform this operation."; return(RedirectToAction("Error")); } var feeStructureDetails = _Context.Sp_GetWholeFeeStructureByPK(id).ToList(); var feeeStructureId = feeStructureDetails.Select(x => x.PK_FeeStructurId).FirstOrDefault(); var cnt = 1; foreach (var item in feeStructureDetails) { var feeHeadClass = new FeeHeadClass(); feeHeadClass.FeeHeadId = item.PK_FeeHeadId; feeHeadClass.HeadName = item.HeadName; feeHeadClass.IsOptional = item.IsOptional; if (feeeStructureId != null) { feeHeadClass.Amount = Convert.ToDecimal(item.Amount); if (item.Amount > 0) { feeHeadClass.IsInclude = true; } if (cnt <= 1) { fsm.FeeStructurId = Convert.ToInt64(item.PK_FeeStructurId); fsm.StructurName = item.StructurName; fsm.TotalFee = Convert.ToDecimal(item.TotalFee); if (item.StartDate.HasValue) { fsm.StartDate = item.StartDate.Value.ToShortDateString().ToString(); } if (item.EndDate.HasValue) { fsm.EndDate = item.EndDate.Value.ToShortDateString().ToString(); } cnt++; } } feeHeadClassList.Add(feeHeadClass); } fsm.feeheads = feeHeadClassList; return(View(fsm)); }
public ActionResult AddEditFeeStructure(FeeStructureModel fsm) { XDocument feeHeads = new XDocument(new XDeclaration("1.0", "UTF - 8", "yes"), new XElement("FeeHeadList", from HList in fsm.feeheads where HList.IsInclude == true select new XElement("FeeHead", new XElement("FeeHeadId", HList.FeeHeadId), new XElement("Amount", HList.Amount), new XElement("IsOptional", HList.IsOptional))) ); var startDate = Convert.ToDateTime(fsm.StartDate); var endDate = Convert.ToDateTime(fsm.EndDate); _Context.Sp_InsertUpdateFeeStructure(fsm.FeeStructurId, fsm.StructurName, startDate, endDate, feeHeads.ToString()); return(RedirectToAction("FeeStructureList")); }
// GET: FeeStructure public ActionResult FeeStructureList() { var fsmList = new List <FeeStructureModel>(); var fsDeatils = _Context.FeeStructurs.Where(x => x.IsActive == true).Select(x => new { x.PK_FeeStructurId, x.StructurName, x.TotalFee, x.StartDate, x.EndDate }).ToList(); foreach (var item in fsDeatils) { var fsm = new FeeStructureModel(); fsm.FeeStructurId = item.PK_FeeStructurId; fsm.StructurName = item.StructurName; fsm.TotalFee = Convert.ToDecimal(item.TotalFee); if (item.StartDate.HasValue) { fsm.StartDate = item.StartDate.Value.ToShortDateString().ToString(); } if (item.EndDate.HasValue) { fsm.EndDate = item.EndDate.Value.ToShortDateString().ToString(); } fsmList.Add(fsm); } return(View(fsmList)); }