public ActionResult Create([Bind(Include = "Id, Availability, FromYear, MaxAmount")] AvailabilityCeiling availabilityCeiling)
        {
            Db db = new Db(DbServices.ConnectionString);

            if (ModelState.IsValid)
            {
                try
                {
                    AvailabilityCeilingServices.Insert(CurrentUser.Id, availabilityCeiling, db);
                    TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed");
                    return(RedirectToAction("Index"));
                }
                catch (CfException cfex)
                {
                    TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
                }
                catch (Exception ex)
                {
                    TempData["Failure"] = ex.Message;
                }
            }

            ViewBag.AvailabilityList = new SelectList(AvailabilityServices.List(db), "Id", "Name");
            return(View(availabilityCeiling));
        }
        // GET: AvailabilityCeiling/Delete/5
        public ActionResult Delete(Nullable <short> id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Db db = new Db(DbServices.ConnectionString);
            AvailabilityCeiling availabilityCeiling = AvailabilityCeilingServices.Get(id.Value, db);

            if (availabilityCeiling == null)
            {
                return(HttpNotFound());
            }
            return(View(availabilityCeiling));
        }
        // GET: AvailabilityCeiling/Edit/5
        public ActionResult Edit(Nullable <short> id)
        {
            Db db = new Db(DbServices.ConnectionString);

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AvailabilityCeiling availabilityCeiling = AvailabilityCeilingServices.Get(id.Value, db);

            if (availabilityCeiling == null)
            {
                return(HttpNotFound());
            }

            ViewBag.AvailabilityList = new SelectList(AvailabilityServices.List(db), "Id", "Name", availabilityCeiling.Availability);
            return(View(availabilityCeiling));
        }
 public ActionResult DeleteConfirmed(short id)
 {
     try
     {
         Db db = new Db(DbServices.ConnectionString);
         AvailabilityCeilingServices.Delete(CurrentUser.Id, id, db);
         TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "DeleteConfirmed");
         // return RedirectToAction("Index");
     }
     catch (CfException cfex)
     {
         TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
     }
     catch (Exception ex)
     {
         TempData["Failure"] = ex.Message;
     }
     // return View(availabilityCeiling);
     return(RedirectToAction("Index"));
 }