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)); }