public ActionResult BondNoWiseSave(BondNoWiseViewModel model)
        {
            var script = db.APPSCRIPTs.SingleOrDefault(s => s.BONDNO == model.BondNo);

            if (script != null)
            {
                script.BONDSTATUS = model.ChangeStatus;
            }
            db.Entry(script).State = EntityState.Modified;
            db.SaveChanges();
            return(View("Successfull"));
        }
        public PartialViewResult BondNoWise(string BondCode, string prefix, string bondNo)
        {
            var script      = db.APPSCRIPTs.SingleOrDefault(o => o.BONDNO == bondNo);
            var application = db.BONDAPPLICATIONs.Find(script.BONDSCN);
            var model       = new BondNoWiseViewModel()
            {
                BondType        = db.BONDINFOes.Find(BondCode).BONDNAME,
                BondNo          = bondNo,
                Prefix          = prefix,
                BondHolder      = application.BUYFNAME + " " + application.BUYMNAME + " " + application.BUYLNAME,
                ApplicationDate = application.SCNDATE,
                CurrentStatus   = db.STATUSINFOes.Single(o => o.STATUSCODE == script.BONDSTATUS).STATUSDESC,
                AppNo           = application.BONDSCN,
                LocalAddress    = application.LOCALADDR,
                ForeignAddress  = application.ABOARDADDR,
                DateOfBirth     = application.DOB,
                PassportNo      = application.PASSPORTNO,
                IssueDate       = application.PASSISSUEDATE
            };

            ViewBag.BondNoWiseStatus = db.STATUSINFOes.Where(o => o.STATUSCODE != application.STATUSCODE).ToList();
            return(PartialView("_bondNoWise", model));
        }