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