private void Section_UC_MouseClick(object sender, MouseEventArgs e)
{
AddStatusLabel.Hide();
DeleteStatusLabel.Hide();
RefreshStatusLabel.Hide();
ClearedLabel.Hide();
}
private void Subjects_UC_MouseClick(object sender, MouseEventArgs e)
{
SearchStatusLabel.Hide();
AddStatusLabel.Hide();
DeleteStatusLabel.Hide();
RefreshedLabel.Hide();
ClearedLabel.Hide();
}
private void AddButton_Click(object sender, EventArgs e)
{
if (SubcodeTextField.Text != "" && BookTitleTextField.Text != "" && SemTextField.Text != "" && CreditsTextField.Text != "")
{
using (SqlCommand cmd = new SqlCommand("AddSubject_SP", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@subCode", SubcodeTextField.Text);
cmd.Parameters.AddWithValue("@title", BookTitleTextField.Text);
cmd.Parameters.AddWithValue("@sem", SemTextField.Text);
cmd.Parameters.AddWithValue("@credits", CreditsTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
AddStatusLabel.ForeColor = Color.Green;
AddStatusLabel.Text = "Added successfully";
AddStatusLabel.Show();
SubcodeTextField.Text = "";
BookTitleTextField.Text = "";
SemTextField.Text = "";
CreditsTextField.Text = "";
}
catch (Exception)
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Error!";
AddStatusLabel.Show();
}
con.Close();
SubjectdataGridView();
}
}
else
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Empty!";
AddStatusLabel.Show();
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (SSIDTextField.Text != "" && SemesterTextField.Text != "" && SectionTextField.Text != "")
{
using (SqlCommand cmd = new SqlCommand("AddSection_SP", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ssid", SSIDTextField.Text);
cmd.Parameters.AddWithValue("@sem", SemesterTextField.Text);
cmd.Parameters.AddWithValue("@sec", SectionTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
AddStatusLabel.ForeColor = Color.Green;
AddStatusLabel.Text = "Added successfully";
AddStatusLabel.Show();
SSIDTextField.Text = "";
SemesterTextField.Text = "";
SectionTextField.Text = "";
}
catch (Exception z)
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Error!";
AddStatusLabel.Show();
MessageBox.Show("" + z);
}
con.Close();
SectiondataGridView();
}
}
else
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Empty!";
AddStatusLabel.Show();
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (USNTextField.Text != "" && SSIDTextField.Text != "")
{
SqlCommand cmd = new SqlCommand("AddClass_SP", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@usn", USNTextField.Text);
cmd.Parameters.AddWithValue("@ssid", SSIDTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
AddStatusLabel.ForeColor = Color.Green;
AddStatusLabel.Text = "Added successfully";
AddStatusLabel.Show();
USNTextField.Text = "";
SSIDTextField.Text = "";
}
catch (Exception)
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Error!";
AddStatusLabel.Show();
MessageBox.Show("Value is missing ;\nEither USN or SSID not found\nOr duplicate entry.\nTry with a valid details.");
}
con.Close();
ClassdataGridView();
}
else
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Empty!";
AddStatusLabel.Show();
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (USNTextField.Text != "" && SubcodeTextField.Text != "" && SSIDTextField.Text != "")
{
int a = Convert.ToInt32(numericUpDown1.Value);
int b = Convert.ToInt32(numericUpDown2.Value);
int c = Convert.ToInt32(numericUpDown3.Value);
int f;
if (a < b && a < c)
{
f = (b + c) / 2;
}
else if (b < a && b < c)
{
f = (a + c) / 2;
}
else
{
f = (a + b) / 2;
}
using (SqlCommand cmd = new SqlCommand("AddExam_SP", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@usn", USNTextField.Text);
cmd.Parameters.AddWithValue("@subCode", SubcodeTextField.Text);
cmd.Parameters.AddWithValue("@ssid", SSIDTextField.Text);
cmd.Parameters.AddWithValue("@test1", a);
cmd.Parameters.AddWithValue("@test2", b);
cmd.Parameters.AddWithValue("@test3", c);
cmd.Parameters.AddWithValue("@final", f);
con.Open();
try
{
cmd.ExecuteNonQuery();
AddStatusLabel.ForeColor = Color.Green;
AddStatusLabel.Text = "Added successfully";
AddStatusLabel.Show();
USNTextField.Text = "";
SSIDTextField.Text = "";
SubcodeTextField.Text = "";
}
catch (Exception)
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Error!";
AddStatusLabel.Show();
MessageBox.Show("Value is missing ;\nEither USN or SSID not found\nOr duplicate entry.\nTry with a valid details.");
}
con.Close();
}
ExamdataGridView();
}
else
{
AddStatusLabel.ForeColor = Color.Red;
AddStatusLabel.Text = "Empty!";
AddStatusLabel.Show();
}
}
