public static DataTable CreateDataTable( Registration registration ) { DataTable dt = new DataTable(); DataColumn col_StudentID = new DataColumn("StudentID" , typeof(int)); DataColumn col_Name = new DataColumn("Name" , typeof(string)); DataColumn col_DateOfBirth = new DataColumn("DateOfBirth" , typeof(DateTime)); DataColumn col_GradePointAvg = new DataColumn("GradePointAvg" , typeof(decimal)); DataColumn col_Active = new DataColumn("Active" , typeof(bool)); dt.Columns.AddRange(new DataColumn[] { col_StudentID,col_Name,col_DateOfBirth,col_GradePointAvg,col_Active,}); return dt; }
private void AddRegistration() { if (CheckValidity()) { Registration StudentRegistration; if (textBoxStudentID.Text == "<Auto Generate>") { StudentRegistration = new Registration(textBoxStudentName.Text.Trim(), dateTimePickerDateOfBirth.Value, decimal.Parse(textBoxGPA.Text), checkBoxActive.Checked); } else { StudentRegistration = new Registration(int.Parse(textBoxStudentID.Text), textBoxStudentName.Text.Trim(), dateTimePickerDateOfBirth.Value, decimal.Parse(textBoxGPA.Text), checkBoxActive.Checked); } NewRegistrations.Add(StudentRegistration); ClearFields(); } }
public static void FillData(DataTable dt, Registration user) { DataRow drow = dt.NewRow(); drow["StudentID"] = user.StudentID; drow["Name"] = user.Name; drow["DateOfBirth"] = user.DateOfBirth; drow["GradePointAvg"] = user.GradePointAvg; drow["Active"] = user.Active; dt.Rows.Add(drow); }
private static Registration MakeRegistration(SqlDataReader dataReader) { Registration registration = new Registration(); if (dataReader.IsDBNull(0) == false) { registration.StudentID = dataReader.GetInt32(0); } if (dataReader.IsDBNull(1) == false) { registration.Name = dataReader.GetString(1); } if (dataReader.IsDBNull(2) == false) { registration.DateOfBirth = dataReader.GetDateTime(2); } if (dataReader.IsDBNull(3) == false) { registration.GradePointAvg = dataReader.GetDecimal(3); } if (dataReader.IsDBNull(4) == false) { registration.Active = dataReader.GetBoolean(4); } return registration; }
public static Registration Select(int studentID_Incoming) { Registration Registrationins = new Registration(); SqlConnection scon = Connection.GetConnection(); SqlCommand scom = new SqlCommand("RegistrationSelect", scon); scom.CommandType = CommandType.StoredProcedure; scon.Open(); scom.Parameters.Add("@StudentID", SqlDbType.Int,4); scom.Parameters["@StudentID"].Value = studentID_Incoming; using (SqlDataReader dataReader = scom.ExecuteReader()){ if (dataReader.Read()) { Registrationins = MakeRegistration(dataReader); } else { Registrationins = null; } } scon.Close(); return Registrationins; }