public IActionResult Claim(Claim claim) { var hiddenState = Request.Form["hiddenState"]; if (ModelState.IsValid) { UpdateClaim updClaim = new UpdateClaim(claim); List <SqlParameter> parameter = updClaim.parameterMap; if (!claim.Check) { parameter[12] = new SqlParameter("@mailingState", hiddenState.ToString()); } var result = _context.Database.ExecuteSqlCommand("sp_updClaim @claimID, @currentAPN, @ClaimStatusRefID, @AssigneeID, @AssignorID, @claimant, @claimantSSN, @spouse, @spouseSSN, @mailingStName, @mailingApt, @mailingCity, @mailingState, @mailingZip, @priorAPN, @dateMovedOut, @priorStName, @priorApt, @priorCity, @priorState, @priorZip, @ClaimActionRefID, @FindingReasonRefID, @Comments, @Late, @rollTaxYear, @suppTaxYear, @exemptRE, @exemptRE2" , parameter[0], parameter[1], parameter[2], parameter[3], new SqlParameter("@AssignorID", User.Identity.Name) , parameter[5], parameter[6], parameter[7], parameter[8], parameter[9] , parameter[10], parameter[11], parameter[12], parameter[13], parameter[14] , parameter[15], parameter[16], parameter[17], parameter[18], parameter[19] , parameter[20], parameter[21], parameter[22], parameter[23], parameter[24] , parameter[25], parameter[26], parameter[27], parameter[28]); return(LocalRedirect("~/Home/Claim/" + claim.claimID)); } return(View("Claim", "Home")); }
public IActionResult Claim(int?id) { ViewBag.history = new ClaimHistory(); DropdownListClaim drop = GetDropdown(id); var modelUser = new Claim(); ViewBag.ModelMessage = false; if (id != null && id > 1) { var EmpID = new SqlParameter("@ClaimID", id); modelUser = _context.Claim.FromSql("sp_getClaim @ClaimID", EmpID).FirstOrDefaultAsync().Result; if (modelUser == null) { ViewBag.ModelMessage = true; return(RedirectToAction(nameof(Index))); } modelUser.CreatedDate = DateTime.Now; var test = _context.History.FromSql("sp_getClaimHistory @ClaimID", EmpID).ToListAsync().Result.ToList(); ViewBag.history = test; } else { modelUser = new Claim(); } ViewBag.Staffs = GetAllStaffs(); ViewBag.dropdownInfo = drop; return(View(modelUser)); }