public Policy insertPolicy(PolicyInsertSdi policyInsertSdi) { con = SqlServerConnection.getConnnection(); con.Open(); StringBuilder sql = new StringBuilder(); sql.Append("insert into Policies values(@description,@value)"); SqlCommand command = new SqlCommand(sql.ToString(), con); command.Parameters.AddWithValue("description", policyInsertSdi.Description); command.Parameters.AddWithValue("value", policyInsertSdi.Value); command.ExecuteNonQuery(); con.Close(); return(this.getPolicyByDescription(policyInsertSdi.Description)); }
private void insertCustom_Click(object sender, EventArgs e) { if (policyService.isExistPolicy(descriptionTextBox.Text)) { MessageBox.Show("description already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { PolicyInsertSdi policyInsertSdi = new PolicyInsertSdi(); policyInsertSdi.Description = descriptionTextBox.Text; policyInsertSdi.Value = Convert.ToInt32(valueTextBox.Text); Policy policy = policyService.insertPolicy(policyInsertSdi); if (policy != null) { this.Close(); policyForm.addDataToTable(policy); } } }
public Policy insertPolicy(PolicyInsertSdi conditionInsertSdi) { return(policyRepoService.insertPolicy(conditionInsertSdi)); }