public PartialViewResult PendingBalances() { int _centerid = CenterID(); var a = from p in db.Installments where p.AdmissionForm.Center.CenterId == _centerid group p.Balance_Due by p.Form_No; int count = 0; foreach (var b in a) { long length = b.Count(); var c = b.ToArray(); if (c[length - 1] != 0) { count++; } } @ViewBag.Count = count; List <long> formNos = db.AdmisionForms.Where(w => w.Center.CenterId == _centerid).OrderByDescending(o => o.Dated).Take(5).Select(x => x.Form_No).ToList(); List <PendingBalances> pendingBalances = new List <PendingBalances>(); foreach (long formno in formNos) { PendingBalances pendingBalance = new PendingBalances(); pendingBalance.Installment = db.Installments.Where(w => w.Form_No == formno && w.AdmissionForm.Center.CenterId == _centerid).OrderByDescending(x => x.Datetime).First(); pendingBalance.StudentDetail = db.StudentDetails.Where(w => w.Form_No == formno && w.CenterName.CenterId == _centerid).FirstOrDefault(); pendingBalances.Add(pendingBalance); } return(PartialView(pendingBalances)); }
public ActionResult TabPendingBalances() { int _centerId = CenterID(); List <long> formNos = db.AdmisionForms.Where(w => w.Center.CenterId == _centerId && w.Form_Complete == false).OrderByDescending(o => o.Dated).Select(x => x.Form_No).ToList(); List <PendingBalances> _pendingBalances = new List <PendingBalances>(); foreach (long formno in formNos) { PendingBalances pendingBalance = new PendingBalances(); pendingBalance.Installment = db.Installments.Where(w => w.Form_No == formno && w.AdmissionForm.Center.CenterId == _centerId).OrderByDescending(x => x.Datetime).First(); pendingBalance.StudentDetail = db.StudentDetails.Where(w => w.Form_No == formno && w.CenterName.CenterId == _centerId).FirstOrDefault(); if (pendingBalance.Installment.Balance_Due != 0) { _pendingBalances.Add(pendingBalance); } } string json = JsonConvert.SerializeObject(_pendingBalances); var sb = new StringBuilder(); sb.AppendFormat("retry: 300000\n\ndata: {0}\n\n", json); return(Content(sb.ToString(), "text/event-stream")); }