private void ManageEvaluation_Click(object sender, EventArgs e) { ManageEvaluation E2 = new ManageEvaluation(); E2.Show(); this.Hide(); }
private void Save_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(conURL); con.Open(); if (flag > 0) { bool j = myvalidations(); if (j == true) { SqlCommand cmd1; string updateevaluation = "Update Evaluation set Name=@Name,TotalMarks=@TotalMarks,TotalWeightage=@TotalWeightage WHERE Evaluation.ID = @flag1"; cmd1 = new SqlCommand(updateevaluation, con); cmd1.Parameters.AddWithValue("@flag1", flag); cmd1.Parameters.AddWithValue("@Name", Ev_Name.Text); cmd1.Parameters.AddWithValue("@TotalMarks", Convert.ToInt64(Ev_TotalMarks.Text)); cmd1.Parameters.AddWithValue("@TotalWeightage", Convert.ToInt64(Ev_TotalWeightage.Text)); cmd1.ExecuteNonQuery(); con.Close(); MessageBox.Show("Evaluation Details Successfully Updated "); ManageEvaluation f3 = new ManageEvaluation(); f3.Show(); this.Close(); } } else { bool j = myvalidations(); if (j == true) { SqlCommand cmd1; string insertev = "INSERT INTO Evaluation(Name,TotalMarks,TotalWeightage) values(@Name,@TotalMarks,@TotalWeightage)"; cmd1 = new SqlCommand(insertev, con); cmd1.Parameters.AddWithValue("@Name", Ev_Name.Text); cmd1.Parameters.AddWithValue("@TotalMarks", Convert.ToInt64(Ev_TotalMarks.Text)); cmd1.Parameters.AddWithValue("@TotalWeightage", Convert.ToInt64(Ev_TotalWeightage.Text)); int i = cmd1.ExecuteNonQuery(); con.Close(); clearfields(); MessageBox.Show(i + " Row(s) Inserted "); } } }
private void dataGridView1_CellContentClick_2(object sender, DataGridViewCellEventArgs e) { SqlConnection con = new SqlConnection(conURL); con.Open(); int currentRow = int.Parse(e.RowIndex.ToString()); int currentColumnIndex = int.Parse(e.ColumnIndex.ToString()); int id = Convert.ToInt32(dataGridView1.Rows[currentRow].Cells[2].Value.ToString()); if (currentColumnIndex == 0) { AddEvaluation fe = new AddEvaluation(id); fe.Show(); this.Hide(); } if (currentColumnIndex == 1) { var confirmResult = MessageBox.Show("Are you sure to delete this item ??", "Confirm Delete!!", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { SqlCommand cmd1; SqlCommand cmd2; string deleteevaluation = "DELETE FROM Evaluation Where Id = @num"; string deletegroupev = "DELETE FROM GroupEvaluation Where EvaluationId = @num"; cmd1 = new SqlCommand(deleteevaluation, con); cmd2 = new SqlCommand(deletegroupev, con); cmd1.Parameters.AddWithValue("@num", id); cmd2.Parameters.AddWithValue("@num", id); cmd2.ExecuteNonQuery(); cmd1.ExecuteNonQuery(); con.Close(); MessageBox.Show("Record deleted succesfully"); ManageEvaluation f3 = new ManageEvaluation(); this.Close(); f3.Show(); } } }