public ActionResult Create([Bind(Include = "A2AStateDepositsId,StateDeposits,Month,Year")] A2AStateDeposits a2AStateDeposits)
        {
            if (ModelState.IsValid)
            {
                var dataexist = from s in db.StateDeposit.ToList()
                                where
                                s.Month == a2AStateDeposits.Month &&
                                s.Year == a2AStateDeposits.Year
                                select s;

                if (dataexist.Count() >= 1)
                {
                    ViewBag.error = "State Budget for " + a2AStateDeposits.Month
                                    + " - " + a2AStateDeposits.Year + " already exists.";

                    ModelState.Clear();
                }
                else
                {
                    a2AStateDeposits.A2AStateDepositsId = Guid.NewGuid();
                    db.StateDeposit.Add(a2AStateDeposits);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
            }

            var datelist = Enumerable.Range(System.DateTime.Now.Year - 1, 5).ToList();

            ViewBag.Year = new SelectList(datelist);
            return(View(a2AStateDeposits));
        }
        public ActionResult DeleteConfirmed(Guid id)
        {
            A2AStateDeposits a2AStateDeposits = db.StateDeposit.Find(id);

            db.StateDeposit.Remove(a2AStateDeposits);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "A2AStateDepositsId,StateDeposits,Month,Year")] A2AStateDeposits a2AStateDeposits)
 {
     if (ModelState.IsValid)
     {
         db.Entry(a2AStateDeposits).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(a2AStateDeposits));
 }
        // GET: A2AStateDeposits/Details/5
        public ActionResult Details(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            A2AStateDeposits a2AStateDeposits = db.StateDeposit.Find(id);

            if (a2AStateDeposits == null)
            {
                return(HttpNotFound());
            }
            return(View(a2AStateDeposits));
        }