private void AddEvaluationSaveBtn_Click(object sender, EventArgs e)
{
if (ValidateEntries())
{
if (flag == 0)
{
SqlConnection conn = new SqlConnection(conURL);
conn.Open();
String AddEvaluationCMD = "INSERT INTO Evaluation (Name, TotalMarks, TotalWeightage) VALUES (@name, @marks, @weightage)";
SqlCommand AddEvaluationCommand = new SqlCommand(AddEvaluationCMD, conn);
AddEvaluationCommand.Parameters.Add(new SqlParameter("name", EvaluationNameTextBox.Text));
AddEvaluationCommand.Parameters.Add(new SqlParameter("marks", EvaluationMarksTextBox.Text));
AddEvaluationCommand.Parameters.Add(new SqlParameter("weightage", TotalWeightageTextBox.Text));
int count = AddEvaluationCommand.ExecuteNonQuery();
Evaluation form = new Evaluation();
form.Show();
this.Hide();
}
if (flag == 1)
{
SqlConnection conn = new SqlConnection(conURL);
conn.Open();
String UpdateEvaluationCMD = "UPDATE Evaluation SET Name = @name, TotalMarks = @marks, TotalWeightage = @weightage WHERE Id = @id";
SqlCommand UpdateEvaluationCommand = new SqlCommand(UpdateEvaluationCMD, conn);
UpdateEvaluationCommand.Parameters.Add(new SqlParameter("name", EvaluationNameTextBox.Text));
UpdateEvaluationCommand.Parameters.Add(new SqlParameter("marks", EvaluationMarksTextBox.Text));
UpdateEvaluationCommand.Parameters.Add(new SqlParameter("weightage", TotalWeightageTextBox.Text));
UpdateEvaluationCommand.Parameters.Add(new SqlParameter("id", incomingId));
int count = UpdateEvaluationCommand.ExecuteNonQuery();
Evaluation form = new Evaluation();
form.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid input");
}
}
