public ActionResult gridAddOrUpdate(setfee setfee)
{
if (setFeeExists(setfee))
{
return(Json(new { success = false, message = "Record Already Exists" }, JsonRequestBehavior.AllowGet));
}
if (setfee.id.CompareTo(0) > 0)
{
feeEntities db1 = new feeEntities();
if (setfee.amount < 0)
{
setfee setfee1 = db.setfees.Find(setfee.id);
db.setfees.Remove(setfee1);
}
else
{
long previousAmount = db1.setfees.Find(setfee.id).amount;
db1.Dispose();
//long previousAmount = setfees.AsQueryable().FirstOrDefault().amount;
if (setfee.amount < previousAmount)
{
return(Json(new { success = false, message = "You cannot decrease amount, try adding concession instead" }, JsonRequestBehavior.AllowGet));
}
db.Entry(setfee).State = EntityState.Modified;
//return Json(new { success = true, message = setfee.id.CompareTo(0)>0 }, JsonRequestBehavior.AllowGet);
}
}
else
{
db.setfees.Add(setfee);
//return Json(new { success = true, message = setfee.id.CompareTo(0) > 0 }, JsonRequestBehavior.AllowGet);
}
db.SaveChanges();
return(Json(new { success = true, message = "Record saved successfully" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(setfee setfee)
{
if (setFeeExists(setfee))
{
ModelState.AddModelError(string.Empty, "Record already exists");
}
short thisAcaYear = db.acayears.Find(setfee.acaYearid).year;
short batch = db.students.Find(setfee.studentid).batch.name;
if (thisAcaYear < batch)
{
ModelState.AddModelError(string.Empty, "Fee can't be set to student where acayear < batch");
}
if (ModelState.IsValid)
{
db.setfees.Add(setfee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.feeTypeid = new SelectList(db.feetypes, "id", "type", setfee.feeTypeid);
ViewBag.studentid = new SelectList(db.students, "id", "htno", setfee.studentid);
ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", setfee.acaYearid);
return(View(setfee));
}
public ActionResult DeleteConfirmed(int id)
{
setfee setfee = db.setfees.Find(id);
db.setfees.Remove(setfee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
setfee setfee = db.setfees.Find(id);
ViewBag.feeTypeid = new SelectList(db.feetypes, "id", "type", setfee.feeTypeid);
ViewBag.studentid = new SelectList(db.students, "id", "htno", setfee.studentid);
ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", setfee.acaYearid);
return(View(setfee));
}
public bool setFeeExists(setfee setfee)
{
var setfees = db.setfees.Where(d => d.studentid.Equals(setfee.studentid)).Where(d => d.feeTypeid.Equals(setfee.feeTypeid)).Where(d => d.acaYearid.Equals(setfee.acaYearid));
if (setfee.id.CompareTo(0) > 0)
{
return(setfees.Where(d => !d.id.Equals(setfee.id)).Count() > 0);
}
return(setfees.Count() > 0);
}
public ActionResult Edit(setfee setfee)
{
if (setFeeExists(setfee))
{
ModelState.AddModelError(string.Empty, "Record already exists");
}
if (ModelState.IsValid)
{
db.Entry(setfee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.feeTypeid = new SelectList(db.feetypes, "id", "type", setfee.feeTypeid);
ViewBag.studentid = new SelectList(db.students, "id", "htno", setfee.studentid);
ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", setfee.acaYearid);
return(View(setfee));
}
public ActionResult Delete(int id)
{
setfee setfee = db.setfees.Find(id);
return(View(setfee));
}
public ViewResult Details(int id)
{
setfee setfee = db.setfees.Find(id);
return(View(setfee));
}
