public int AddVerificationNotesToRejectedProduct(ProductVerificationModel verificationModel)
{
try
{
CommandObj.CommandText = "UDSP_AddVerificationNotesToRejectedProduct";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.AddWithValue("@Notes", verificationModel.Notes);
CommandObj.Parameters.AddWithValue("@RejectionId", verificationModel.RejectionId);
CommandObj.Parameters.AddWithValue("@VerifiedByUserId", verificationModel.VerifiedByUserId);
CommandObj.Parameters.AddWithValue("@PassOrFailedStatus", verificationModel.QcPassorFailedStatus);
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)
{
throw new Exception("Could not add verification notes to rejected product", exception);
}
finally
{
CommandObj.Dispose();
CommandObj.Parameters.Clear();
ConnectionObj.Close();
}
}
public JsonResult AddVerificationNotes(long rejectionId, string notes, int passfailedStatus)
{
var user = (ViewUser)Session["user"];
var verificationModel = new ProductVerificationModel
{
Notes = notes,
QcPassorFailedStatus = passfailedStatus,
RejectionId = rejectionId,
VerifiedByUserId = user.UserId
};
SuccessErrorModel model = new SuccessErrorModel();
bool result = _iProductionQcManager.AddVerificationNotesToRejectedProduct(verificationModel);
model.Message = result ? "Added Successfully" : "Failed to Add qc notes";
return(Json(model, JsonRequestBehavior.AllowGet));
}
public bool AddVerificationNotesToRejectedProduct(ProductVerificationModel verificationModel)
{
int rowAffected = _iProductionQcGateway.AddVerificationNotesToRejectedProduct(verificationModel);
return(rowAffected > 0);
}