public ActionResult DeleteFile(int id)
 {
     try
     {
         pay_statement obj = db.pay_statement.Find(id);
         db.pay_statement.Remove(obj);
         db.SaveChanges();
         return(RedirectToAction("ManagePay"));
     }
     catch (DataException)
     {
         return(RedirectToAction("DeleteFile", new { id = id, saveChangesError = true }));
     }
     return(RedirectToAction("ManagePay"));
 }
        //---------------------------------------------------------------------------------------

        public ActionResult DeleteFile(int?id, bool?saveChangesError = false)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            //
            if (saveChangesError.GetValueOrDefault())
            {
                ViewBag.ErrorMessage = "Delete failed.Try again.";
            }
            //
            pay_statement obj = db.pay_statement.Find(id);

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