public string Edit(GenerateFeesCreateModel model, int id)
{
try
{
var feesIndvList = GetFeeIndvList(model);
var tblGenerateFeesMst = db.tblGenerateFeesMst.Find(id);
var tblGenerateFeesDtlList = db.tblGenerateFeesDtl.Where(x => x.GenFeesMstID == id).ToList();
tblGenerateFeesMst.UpdateBy = portalutilities._username;
tblGenerateFeesMst.UpdateDate = DateTime.Now;
tblGenerateFeesMst.TotalDiscountAmount = model.totalDiscount;
tblGenerateFeesMst.TotalFeesAmount = model.totalFees;
tblGenerateFeesMst.TotalNetFees = model.totalNetFees;
tblGenerateFeesMst.TotalStudents = feesIndvList.Count;
foreach (var item in tblGenerateFeesDtlList)
{
foreach (var findv in feesIndvList)
{
if (findv.feesTypeId == item.FeesTypeID)
{
item.EditedDiscAmount = findv.editedDiscount;
item.NetFees = findv.netFees;
}
}
}
db.SaveChanges();
return("Done");
}
catch (Exception e)
{
return(e.InnerException.ToString());
}
}
public ActionResult Create(GenerateFeesCreateModel model)
{
var feesIndvList = GetFeeIndvList(model);
var mstId = db.tblGenerateFeesMst.Add(new tblGenerateFeesMst
{
ClassID = model.classId,
CreateBy = portalutilities._username,
CreateDate = DateTime.Now,
FeesDate = DateTime.Now,
IsDelete = false,
PostDate = model.postDate,
SchoolID = portalutilities._schollid,
SectionID = model.sectionId,
SessionID = portalutilities.ActiveSessionID,
StageID = model.stageId,
TotalDiscountAmount = model.totalDiscount,
TotalFeesAmount = model.totalFees,
TotalNetFees = model.totalNetFees,
TotalStudents = feesIndvList.Count,
});
db.SaveChanges();
foreach (var item in feesIndvList)
{
db.tblGenerateFeesDtl.Add(new tblGenerateFeesDtl
{
AdmissionID = item.admissionId,
ClassID = model.classId,
DiscountID = item.discountId,
EditedDiscAmount = item.editedDiscount,
FeesTypeID = item.feesTypeId,
GenFeesMstID = mstId.GenFeesMstID,
NetFees = item.netFees,
SectionID = model.sectionId,
StageID = model.stageId,
Status = portalutilities.FeesStatus.UnPaid,
});
}
foreach (var item in model.chargeFees.Split(','))
{
var id = int.Parse(item);
var currentFeeType = db.tblFeesType.FirstOrDefault(x => x.FeesTypeID == id).FeesType;
db.tblGenerateFeesCFDtl.Add(new tblGenerateFeesCFDtl
{
ChargeFee = currentFeeType,
GenFeesMstID = mstId.GenFeesMstID,
});
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
private static List <GenerateFeesIndv> GetFeeIndvList(GenerateFeesCreateModel model)
{
var feesIndvList = new List <GenerateFeesIndv>();
foreach (var item in model.generateFeesList.Split('|'))
{
var itemArray = item.Split(',');
feesIndvList.Add(new GenerateFeesIndv
{
admissionId = int.Parse(itemArray[0]),
feesTypeId = int.Parse(itemArray[1]),
discountId = int.Parse(itemArray[2]),
editedDiscount = int.Parse(itemArray[3]),
netFees = int.Parse(itemArray[4])
});
}
return(feesIndvList);
}
