private void BackScreen_Click(object sender, EventArgs e) { ManageEvaluationForm form = new ManageEvaluationForm(); this.Close(); form.Show(); }
private void GoToEvaluationForm_Click_1(object sender, EventArgs e) { ManageEvaluationForm form = new ManageEvaluationForm(); form.Show(); this.Hide(); }
private void InsertEvaluation_Click(object sender, EventArgs e) { try { Evaluation evaluation = new Evaluation(); evaluation.Name = NameTextBox.Text; try { evaluation.Marks = MarksTextBox.Text; } catch (ArgumentException) { MessageBox.Show("Please enter the marks of evaluation in digits"); throw new ArgumentException(); } try { evaluation.TotalWeightage = WeightageTextBox.Text; } catch (ArgumentException) { MessageBox.Show("Please enter the correct weightage"); throw new ArgumentException(); } if (value1 == "add") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string addEvaluation = string.Format("INSERT INTO Evaluation(Name, TotalMarks, TotalWeightage) values('{0}', '{1}', '{2}')", evaluation.Name, int.Parse(evaluation.Marks), int.Parse(evaluation.TotalWeightage)); SqlCommand cmd = new SqlCommand(addEvaluation, connection); cmd.ExecuteNonQuery(); MessageBox.Show("Evaluation Added!"); connection.Close(); } else if (value1 == "edit") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string update = string.Format("UPDATE Evaluation SET Name = '{0}', TotalMarks = '{1}', TotalWeightage = '{2}'" + "WHERE Id = '{3}'", evaluation.Name, int.Parse(evaluation.Marks), int.Parse(evaluation.TotalWeightage), id); SqlCommand cmd = new SqlCommand(update, connection); cmd.ExecuteNonQuery(); MessageBox.Show("Evaluation Updated!"); connection.Close(); } ManageEvaluationForm form = new ManageEvaluationForm(); this.Close(); form.Show(); } catch (Exception) { MessageBox.Show("Evaluation not saved!"); } }