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));
}
