//Insert Student In to Registration table public void InsertStudent(Student student) { CreateConnection(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "insertStudent"; try { command.Parameters.AddWithValue("@Name", student.Name); command.Parameters.AddWithValue("@DOB", student.Dob); command.Parameters.AddWithValue("@GradePointAvg", student.GradePointAvg); if (student.Active == true) { command.Parameters.AddWithValue("@Active", 1); } else { command.Parameters.AddWithValue("@Active", 0); } command.ExecuteNonQuery(); } catch (Exception ex) { EventLog eventlog = new EventLog(); eventlog.Source = "JeTech Queens University app"; eventlog.WriteEntry("Insert Student Failed" + ex.Message, EventLogEntryType.Error); } CloseConnection(); }
private void buttonOk_Click(object sender, EventArgs e) { //Insert Student Objects to a List Student student = new Student(); string name = textBoxName.Text; bool validrangegpa=false; student.Dob = dateTimePickerDateOfBirth.Value; student.StudentId =Convert.ToInt32(textBoxStudentID.Text); string gpa = textBoxGradePoint.Text; if (!string.IsNullOrEmpty(name) & !string.IsNullOrEmpty(gpa)) { bool validegpa = validateNumbers(gpa); if (validegpa) { float gpaValue=(float)Convert.ToDouble(gpa); if (gpaValue <= 4.0 & gpaValue > 0) { validrangegpa=true; student.GradePointAvg = gpaValue; } else { MessageBox.Show("Enter Valid GPA"); } } else { MessageBox.Show("Gpa is not Valid"); } bool valideName = IsName(name); if (valideName) { student.Name = name; } else { MessageBox.Show("Name is Not Valid"); } bool activeValue = checkBoxActive.Checked; if (activeValue == true) { student.Active = true; } else { student.Active = false; } if (valideName & validrangegpa) { st.Add(student); this.Close(); StudentDetails stud = new StudentDetails(); // stud.MdiParent = MdiParentHome.ActiveForm; stud.Show(); if (newNumber == 0) { newNumber = loadnumber; ++newNumber; } else { ++newNumber; } } } else { MessageBox.Show("Please Enter Details"); } }