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