private void updateCustom_Click(object sender, EventArgs e)
{
PolicyUpdateSdi policyUpdateSdi = new PolicyUpdateSdi();
policyUpdateSdi.Description = descriptionTextBox.Text;
policyUpdateSdi.Value = Convert.ToInt32(valueTextBox.Text);
Policy policy = policyService.updatePolicy(policyUpdateSdi);
if (policy != null)
{
this.Close();
policyForm.updateDataToTable(policy);
}
}
public Policy updatePolicy(PolicyUpdateSdi policyUpdateSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append(" update Policies set " +
" value = @value ");
sql.Append(" where description = @description");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("value", policyUpdateSdi.Value);
command.Parameters.AddWithValue("description", policyUpdateSdi.Description);
command.ExecuteNonQuery();
con.Close();
return(this.getPolicyByDescription(policyUpdateSdi.Description));
}
public Policy updatePolicy(PolicyUpdateSdi policyUpdateSdi)
{
return(policyRepoService.updatePolicy(policyUpdateSdi));
}
