private void BackBtn_Click(object sender, EventArgs e) { Evaluation form = new Evaluation(); form.Show(); this.Hide(); }
private void DeleteEvaluationsBtn_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); if (EvaluationsGridView.SelectedCells.Count != 0) { int row = EvaluationsGridView.SelectedCells[0].RowIndex; int id = Convert.ToInt32(EvaluationsGridView.Rows[row].Cells[0].Value); String delEvaluationCMD1 = String.Format("DELETE FROM GroupEvaluation WHERE GroupEvaluation.EvaluationId = {0}", id); SqlCommand delEvaluationCommand1 = new SqlCommand(delEvaluationCMD1, conn); int count = delEvaluationCommand1.ExecuteNonQuery(); String delEvaluationCMD = String.Format("DELETE FROM Evaluation WHERE Id = {0}", id); SqlCommand delEvaluationCommand = new SqlCommand(delEvaluationCMD, conn); count = delEvaluationCommand.ExecuteNonQuery(); Evaluation form = new Evaluation(); this.Hide(); form.Show(); } }
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"); } }