public void SaveFunction() { GradingSP gradingSP = new GradingSP(); GradingInfo gradingInfo = new GradingInfo(); try { for (int i = 0; i < dgvGrading.RowCount - 1; i++) { if (dgvGrading.Rows[i].Cells["dgvsubject"].Value.ToString() != string.Empty && dgvGrading.Rows[i].Cells["dgvsubject"].Value != null) { gradingInfo.SubjectId = Convert.ToInt32(dgvGrading.Rows[i].Cells["dgvsubject"].Value); } if (dgvGrading.Rows[i].Cells["dgvmarks"].Value.ToString() != string.Empty && dgvGrading.Rows[i].Cells["dgvmarks"].Value != null) { gradingInfo.Marks = Convert.ToInt32(dgvGrading.Rows[i].Cells["dgvmarks"].Value); } gradingInfo.TermId = Convert.ToInt32(cmbTerm.SelectedValue); gradingInfo.ClassId = Convert.ToInt32(cmbClass.SelectedValue); gradingInfo.StudentId = Convert.ToInt32(cmbStudent.SelectedValue); gradingSP.GradingAdd(gradingInfo); } clearfielsd(); Messages.SavedMessage(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
///<summary> ///Function to get Student /// </summary> public void GradingAdd(GradingInfo gradingInfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand sqlcmd = new MySqlCommand("GradingAdd", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = sqlcmd.Parameters.Add("?student_id", MySqlDbType.Int32); sqlparam.Value = gradingInfo.StudentId; sqlparam = sqlcmd.Parameters.Add("?class_id", MySqlDbType.Int32); sqlparam.Value = gradingInfo.ClassId; sqlparam = sqlcmd.Parameters.Add("?subject_id", MySqlDbType.Int32); sqlparam.Value = gradingInfo.SubjectId; sqlparam = sqlcmd.Parameters.Add("?term_id", MySqlDbType.Int32); sqlparam.Value = gradingInfo.TermId; sqlparam = sqlcmd.Parameters.Add("?marks", MySqlDbType.Decimal); sqlparam.Value = gradingInfo.Marks; sqlparam = sqlcmd.Parameters.Add("?total", MySqlDbType.Decimal); sqlparam.Value = gradingInfo.Total; sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); } }