private void UploadGradeBtn_Click(object sender, EventArgs e) { this.Hide(); UploadGrade UG = new UploadGrade(uid); UG.Show(); }
private void ConfirmBtn_Click(object sender, EventArgs e) { con.Open(); cmd = new SqlCommand("Insert into Grade(gsid,gcid,grade,marks) values (@s,@c,@g,@m)", con); // cmd3 = new SqlCommand("select * from Grade"); cmd.Parameters.AddWithValue("@s", (Convert.ToInt32(IdBox.Text))); cmd.Parameters.AddWithValue("@c", SubjBox.Text.ToString()); cmd.Parameters.AddWithValue("@g", (Convert.ToInt32(comboBox1.SelectedIndex))); cmd.Parameters.AddWithValue("@m", (Convert.ToSingle(MarkBox.Text))); cmd.ExecuteNonQuery(); //MessageBox.Show("Grade uploaded succesfully"); int ass = Convert.ToInt32(comboBox1.SelectedIndex); con2.Open(); cmd3 = new SqlCommand("Select Credits, cgpa from student where sid=(@data)", con2); cmd3.Parameters.AddWithValue("@data", (Convert.ToInt32(IdBox.Text))); int? c = null; float?g = null; using (SqlDataReader oReader = cmd3.ExecuteReader()) { while (oReader.Read()) { if (oReader["Credits"].Equals(DBNull.Value)) { c = null; } else { c = Convert.ToInt32(oReader["Credits"]); } if (oReader["cgpa"].Equals(DBNull.Value)) { g = null; } else { g = Convert.ToSingle(oReader["cgpa"]); } } } if (c.Equals(null)) { c = 0; c = c + 3; } else { c = c + 3; } if (g.Equals(null)) { if (ass == 0) { g = 4; } else if (ass == 1) { g = Convert.ToSingle(3.8); } else if (ass == 2) { g = Convert.ToSingle(3.6); } else { g = 0; } } else { if (ass == 0) { g = g - 0; } else if (ass == 1) { g = Convert.ToSingle(g - .2); } else if (ass == 2) { g = Convert.ToSingle(g - .4); } else { g = Convert.ToSingle(g - .8);; } } //cmd1.ExecuteNonQuery(); con.Close(); con2.Open(); cmd4 = new SqlCommand("Update student set Credits= (@sal), cgpa= (@edu) where sid= (@tid)", con2); cmd4.Parameters.AddWithValue("@tid", (Convert.ToInt32(IdBox.Text))); cmd4.Parameters.AddWithValue("@sal", c); cmd4.Parameters.AddWithValue("@edu", g); //cmd.Parameters.AddWithValue("@edu", nat); //cmd.Parameters.AddWithValue("@dob1", dateTimePicker1.Text); cmd4.ExecuteNonQuery(); MessageBox.Show("Uploaded"); this.Visible = false; UploadGrade form = new UploadGrade(s); form.Show(); }