public Condition InsertCondition(ConditionInsertSdi conditionInsertSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append("insert into Condition values(@grade,@percent)");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("grade", conditionInsertSdi.Grade);
command.Parameters.AddWithValue("percent", conditionInsertSdi.Percent);
command.ExecuteNonQuery();
con.Close();
return(this.getConditionByGrade(conditionInsertSdi.Grade));
}
private void insertCustom_Click(object sender, EventArgs e)
{
if (conditionService.isExistCondition(gradeTextBox.Text))
{
MessageBox.Show("condition already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ConditionInsertSdi conditionInsertSdi = new ConditionInsertSdi();
conditionInsertSdi.Grade = gradeTextBox.Text;
conditionInsertSdi.Percent = Convert.ToInt32(percentTextBox.Text);
Condition condition = conditionService.insertCondition(conditionInsertSdi);
if (condition != null)
{
this.Close();
conditionForm.addDataToTable(condition);
}
}
}
public Condition insertCondition(ConditionInsertSdi conditionInsertSdi)
{
return(conditionRepoService.InsertCondition(conditionInsertSdi));
}
