public IncarceratedStep6 insertStep6(IncarceratedStep6 step6, int userid, string Command, out string result, out bool isSuccess)
        {
            try
            {
                Form form = new Form();
                using (BoardofPardonsEntities1 dbcontext = new BoardofPardonsEntities1())
                {
                    form = dbcontext.Forms.Where(a => a.id == step6.FormId).FirstOrDefault();

                    if (Command == "save")
                    {
                        form.Status = 0;
                    }
                    else
                    {
                        form.Status = 1;
                    }



                    var _step6 = dbcontext.IncarceratedStep6.Where(a => a.FormId == step6.FormId).FirstOrDefault();
                    if (_step6 == null)
                    {
                        step6.CreatedAt = DateTime.Now;
                        step6           = dbcontext.IncarceratedStep6.Add(step6);
                    }
                    else
                    {
                        _step6           = step6;
                        _step6.UpdatedAt = DateTime.Now;
                    }


                    //step6.FormId = form.id;

                    dbcontext.SaveChanges();
                }
                isSuccess = true;
                result    = "Success";
                return(step6);
            }
            catch (Exception ex)
            {
                using (StreamWriter writer =
                           new StreamWriter(HostingEnvironment.MapPath("~/errLog.txt")))
                {
                    writer.WriteLine("==========================");
                    writer.WriteLine("Date " + DateTime.Now);
                    writer.WriteLine("Error" + ex.Message);
                }
                isSuccess = false;
                result    = ex.Message;
                return(null);
            }
        }
 public ActionResult step6(IncarceratedStep6 step6, string Command)
 {
     if (Session["formNo"] != null)
     {
         objIncarc    = new InCarceratedManger();
         step6.FormId = (int)Session["formNo"];
         int mu1 = (int)WebSecurity.CurrentUserId;
         try
         {
             mu1 = Session["UserId"] == null ? WebSecurity.CurrentUserId : (int)Session["UserId"];
         }
         catch (Exception) {
         }
         step6 = objIncarc.insertStep6(step6, mu1, Command, out returnMessage, out isSuccess);
         if (isSuccess)
         {
             if (Command == "save")
             {
                 return(RedirectToAction("step7"));
             }
             else if (Command == "submit")
             {
                 sendSubmitEmail();
                 Session["formNo"] = null;
                 return(RedirectToAction("PDFView", "PDFReport", new { id = step6.FormId })); //PDFView(int id)
                 //return RedirectToAction("index", "FormSelect");
             }
             else
             {
                 return(RedirectToAction("step5"));
             }
         }
         else
         {
             return(View(step6));
         }
     }
     else
     {
         return(RedirectToAction("Index", "FormSelect"));
     }
 }
 //step 6
 public ActionResult step6()
 {
     objIncarc = new InCarceratedManger();
     if (Session["formNo"] == null)
     {
         return(View());
     }
     else
     {
         int formId = (int)Session["formNo"];
         IncarceratedStep6 step6 = objIncarc.getIncarceratedStep6(formId);
         if (step6 != null)
         {
             return(View(step6));
         }
         else
         {
             return(View());
         }
     }
 }