public JsonResult AddStudentAsync(int[] studentIds, int BatchId) { try { foreach (int id in studentIds) { BatchMember batchmember = new BatchMember() { BatchId = BatchId, studentId = id }; db.BatchMember.Add(batchmember); db.SaveChanges(); long formno = db.StudentDetails.Find(id).Form_No; if (db.Installments.Where(w => w.Form_No == formno).OrderByDescending(o => o.Datetime).Select(s => s.Balance_Due).Take(1).ToArray()[0] == 0 && db.BatchMember.Any(a => a.studentId == id)) { AdmissionForm ad = db.AdmisionForms.Find(formno); ad.Form_Complete = true; db.SaveChanges(); } } return(Json("{ \"success\":true}")); } catch (Exception ex) { return(Json("{ \"success\":false}")); } }
public bool DeleteMember(int id) { BatchMember _bm = db.BatchMember.Find(id); long formno = _bm.Student.Form_No; db.BatchMember.Remove(_bm); bool result = Convert.ToBoolean(db.SaveChanges()); if (db.Installments.Where(w => w.Form_No == formno).OrderByDescending(o => o.Datetime).Select(s => s.Balance_Due).Take(1).ToArray()[0] != 0 || !db.BatchMember.Any(a => a.studentId == id)) { AdmissionForm ad = db.AdmisionForms.Find(formno); ad.Form_Complete = false; db.SaveChanges(); } return(result); }