public int SaveTestPolicy(TestPolicyModel model) { try { CommandObj.CommandText = "UDSP_SaveTestPolicy"; CommandObj.CommandType = CommandType.StoredProcedure; CommandObj.Parameters.AddWithValue("@TestCategoryId", model.TestCategoryId); CommandObj.Parameters.AddWithValue("@ProductId", model.ProductId); CommandObj.Parameters.AddWithValue("@Parameter", model.Parameter); CommandObj.Parameters.AddWithValue("@AcceptableValue", model.AcceptableValue); CommandObj.Parameters.AddWithValue("@Remarks", model.Remarks); CommandObj.Parameters.AddWithValue("@UserId", model.UserId); CommandObj.Parameters.Add("@RowAffected", SqlDbType.Int); CommandObj.Parameters["@RowAffected"].Direction = ParameterDirection.Output; ConnectionObj.Open(); CommandObj.ExecuteNonQuery(); var rowAffected = Convert.ToInt32(CommandObj.Parameters["@RowAffected"].Value); return(rowAffected); } catch (Exception exception) { Log.WriteErrorLog(exception); throw new Exception("Coluld not add product test policy"); } finally { CommandObj.Dispose(); ConnectionObj.Close(); CommandObj.Parameters.Clear(); } }
public ActionResult TestPolicy(TestPolicyModel modelPolicy) { try { var user = (ViewUser)Session["user"]; modelPolicy.UserId = user.UserId; bool result = _iPolicyManager.SaveTestPolicy(modelPolicy); if (result) { return(RedirectToAction("ViewTestPolicy")); } return(View()); } catch (Exception exception) { Log.WriteErrorLog(exception); return(PartialView("_ErrorPartial", exception)); } }
public bool SaveTestPolicy(TestPolicyModel modelPolicy) { var rowAffected = _iPolicyGateway.SaveTestPolicy(modelPolicy); return(rowAffected > 0); }