public ActionResult DeleteConfirmed(int id) { StudentPenalty studentPenalty = db.StudentPenalties.Find(id); db.StudentPenalties.Remove(studentPenalty); db.SaveChanges(); return(RedirectToAction("StudentPaneltiesIndex")); }
public ActionResult Edit([Bind(Include = "Id,StudentId,PenaltyId")] StudentPenalty studentPenalty) { if (ModelState.IsValid) { db.Entry(studentPenalty).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("StudentPaneltiesIndex")); } ViewBag.StudentId = new SelectList(db.AspNetStudents, "Id", "Name", studentPenalty.StudentId); ViewBag.PenaltyId = new SelectList(db.PenaltyFees, "Id", "Name", studentPenalty.PenaltyId); return(View(studentPenalty)); }
// GET: StudentPenalties/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentPenalty studentPenalty = db.StudentPenalties.Find(id); if (studentPenalty == null) { return(HttpNotFound()); } return(View(studentPenalty)); }
// GET: StudentPenalties/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentPenalty studentPenalty = db.StudentPenalties.Find(id); if (studentPenalty == null) { return(HttpNotFound()); } ViewBag.StudentId = new SelectList(db.AspNetStudents, "Id", "Name", studentPenalty.StudentId); ViewBag.PenaltyId = new SelectList(db.PenaltyFees, "Id", "Name", studentPenalty.PenaltyId); return(View(studentPenalty)); }
public ActionResult Create([Bind(Include = "Id,StudentId,PenaltyId")] StudentPenalty studentPenalty) { string S_UID = Request.Form["StudentId"]; int? S_Id = db.AspNetStudents.Where(x => x.StudentID == S_UID).Select(x => x.Id).FirstOrDefault(); if (S_UID != null && S_Id != 0) { studentPenalty.StudentId = S_Id; try { studentPenalty.Status = "Pending"; db.StudentPenalties.Add(studentPenalty); db.SaveChanges(); //Student_ChallanForm std_from = db.Student_ChallanForm.Where(x => x.StudentId == studentPenalty.StudentId).FirstOrDefault(); //var amount = db.PenaltyFees.Where(x => x.Id == studentPenalty.PenaltyId).Select(x => x.Amount).FirstOrDefault(); //std_from.AmountPayable += amount; //db.SaveChanges(); //var fee = db.StudentPenalties.Where(x => x.PenaltyId == studentPenalty.PenaltyId).Select(x => x.PenaltyFee.Amount).FirstOrDefault(); //Ledger ledger = db.Ledgers.Where(x => x.Name == "Student Receivables").FirstOrDefault(); //ledger.StartingBalance += fee; //ledger.CurrentBalance += fee; //db.SaveChanges(); //Ledger l = db.Ledgers.Where(x => x.Name == "Student Fee").FirstOrDefault(); //l.StartingBalance += fee; //l.CurrentBalance += fee; //db.SaveChanges(); return(RedirectToAction("StudentPaneltiesIndex")); } catch { return(RedirectToAction("Create")); } } else { return(RedirectToAction("StudentPaneltiesIndex")); } ViewBag.StudentId = new SelectList(db.AspNetStudents, "Id", "Name", studentPenalty.StudentId); ViewBag.PenaltyId = new SelectList(db.PenaltyFees, "Id", "Name", studentPenalty.PenaltyId); return(View(studentPenalty)); }