private void BtnUpdateDeleteCRS_Click(object sender, EventArgs e)
{
UpdateORDeleteMarks ud = new UpdateORDeleteMarks();
this.Hide();
ud.ShowDialog();
}
private void BtnRefresh_Click(object sender, EventArgs e)
{
UpdateORDeleteMarks newud = new UpdateORDeleteMarks();
this.Hide();
newud.ShowDialog();
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (tbRegNo.Text == "" || tbMark.Text == "")
{
MessageBox.Show("Please choose correct complete record to DELETE !!!!");
}
else
{
try
{
//con.Open();
string qry = "DELETE FROM ExamMarks WHERE SID = '" + tbRegNo.Text + "' AND SubjectID = '" + ((DataRowView)cbSubName.SelectedItem)[0] + "' And Term = '" + cbExam.Text + "' AND Year = '" + YearPicker.Value + "'";
SqlCommand cmd = new SqlCommand(qry, o.con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SubjectID", cbSubName.SelectedText.ToString());
cmd.ExecuteNonQuery();
if (MessageBox.Show("Are You Sure??", "DELETE", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
clearFields();
MessageBox.Show("Successfully Deleted!!");
displayData();
// con.Close();
UpdateORDeleteMarks newud = new UpdateORDeleteMarks();
this.Hide();
newud.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show(ex.StackTrace);
con.Close();
}
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
if (tbRegNo.Text == "" || tbMark.Text == "" || cbExam.Text == "")
{
errorProvider1.SetError(tbRegNo, "Please fill the empty Areas!!!!");
errorProvider1.SetError(tbMark, "Please fill the empty Areas!!!!");
errorProvider1.SetError(cbExam, "Please fill the empty Areas!!!!");
MessageBox.Show("Please fill the empty Areas!!!!");
return;
}
else
{
errorProvider1.Clear();
}
con.Open();
SqlCommand check = new SqlCommand("SELECT * FROM ExamMarks WHERE SID = '" + tbRegNo.Text + "' AND SubjectID = '" + ((DataRowView)cbSubName.SelectedItem)[0] + "' AND Term = '" + cbExam.Text + "' AND Mark = '" + tbMark.Text + "' AND Year = '" + YearPicker.Value + "' ", con);
SqlDataAdapter checkDa = new SqlDataAdapter(check);
DataSet ds = new DataSet();
checkDa.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{
errorProvider1.SetError(tbRegNo, "This already Exist!!!!");
errorProvider1.SetError(cbSubName, "This already Exist!!!!");
errorProvider1.SetError(cbExam, "This already Exist!!!!");
errorProvider1.SetError(tbMark, "This already Exist!!!!");
errorProvider1.SetError(YearPicker, "This already Exist!!!!");
MessageBox.Show("This already Exist!!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
con.Close();
}
else
{
try
{
//con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE ExamMarks SET Mark ='" + tbMark.Text + "' WHERE SID ='" + tbRegNo.Text + "' AND SubjectID = '" + ((DataRowView)cbSubName.SelectedItem)[0] + "' AND Term = '" + cbExam.Text + "' AND Year = '" + YearPicker.Value + "' ";
cmd.ExecuteNonQuery();
con.Close();
displayData();
clearFields();
MessageBox.Show("Record Updated Successfully!!!");
UpdateORDeleteMarks newud = new UpdateORDeleteMarks();
this.Hide();
newud.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
con.Close();
}
}
}
