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