public IHttpActionResult saveReimbursement([FromBody] reimbursement reimbursement) { try { reimbursement record = (from s in fmp.reimbursement where s.id == reimbursement.id select s).FirstOrDefault <reimbursement>(); if (record != null) { objMapper.Map <reimbursement>(ref record, reimbursement); } else { reimbursement new_record = new reimbursement(); objMapper.Map <reimbursement>(ref new_record, reimbursement); fmp.reimbursement.Add(new_record); } fmp.SaveChanges(); return(Ok(1)); } catch (Exception ex) { return(InternalServerError(ex)); } }
public ActionResult DeleteConfirmed(int id) { reimbursement reimbursement = db.reimbursements.Find(id); db.reimbursements.Remove(reimbursement); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int id) { reimbursement reimbursement = db.reimbursements.Find(id); ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", reimbursement.acaYearid); ViewBag.studentid = new SelectList(db.students, "id", "htno", reimbursement.studentid); return(View(reimbursement)); }
public ActionResult Edit(reimbursement reimbursement) { if (db.reimbursements.Any(s => s.studentid.Equals(reimbursement.studentid) && s.acaYearid.Equals(reimbursement.acaYearid)) && reimbursement.id != db.reimbursements.Where(s => s.studentid.Equals(reimbursement.studentid) && s.acaYearid.Equals(reimbursement.acaYearid)).FirstOrDefault().id) { ModelState.AddModelError("", "Record exists with the given paramerts"); } if (ModelState.IsValid) { db.Entry(reimbursement).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", reimbursement.acaYearid); ViewBag.studentid = new SelectList(db.students, "id", "htno", reimbursement.studentid); return(View(reimbursement)); }
public ActionResult Create(reimbursement reimbursement) { if (db.reimbursements.Any(s => s.studentid.Equals(reimbursement.studentid) && s.acaYearid.Equals(reimbursement.acaYearid))) { ModelState.AddModelError("", "Record exists with the given paramerts"); } if (ModelState.IsValid) { reimbursement.date = DateTime.Now; db.reimbursements.Add(reimbursement); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.acaYearid = new SelectList(db.acayears, "id", "year", reimbursement.acaYearid); ViewBag.studentid = new SelectList(db.students, "id", "htno", reimbursement.studentid); return(View(reimbursement)); }
public ActionResult gridAddOrUpdate(reimbursement rb) { if (db.reimbursements.Any(s => s.acaYearid == rb.acaYearid && s.studentid == rb.studentid)) { if (db.reimbursements.Where(s => s.acaYearid == rb.acaYearid && s.studentid == rb.studentid).Select(s => s.id).ToList().AsQueryable().FirstOrDefault() != rb.id) { return(Json(new { success = false, message = "Record Already Exists" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(rb).State = EntityState.Modified; } } else { rb.date = DateTime.Now; db.reimbursements.Add(rb); } db.SaveChanges(); return(Json(new { success = true, message = "Record saved successfully" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int id) { reimbursement reimbursement = db.reimbursements.Find(id); return(View(reimbursement)); }
public ViewResult Details(int id) { reimbursement reimbursement = db.reimbursements.Find(id); return(View(reimbursement)); }