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