}//End of Load
public List <Assesment> Load2()
{
try
{
using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
{
con.Open();
string sql = "SELECT * FROM stud_registration WHERE stud_regNo =@studRegistrationNo";
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("studRegistrationNo", studRegistrationNo);
MySqlDataReader reader = cmd.ExecuteReader();
//loop while have record
while (reader.Read())
{
//instantiate model
Assesment assesment = new Assesment();
//prepare properties
assesment.id = Convert.ToInt32(reader["id"].ToString());
assesment.studLRN = reader["stud_LRN"].ToString();
assesment.studGOCNo = reader["stud_GOCNo"].ToString();
assesment.studRegistrationNo = reader["stud_regNo"].ToString();
assesment.studLastName = reader["stud_lastName"].ToString();
assesment.studFirstName = reader["stud_firstName"].ToString();
assesment.studMiddleName = reader["stud_middleName"].ToString();
assesment.studGradeLevel = reader["stud_grade_level"].ToString();
assesment.studType = reader["stud_type"].ToString();
assesment.studCourse = reader["stud_course"].ToString();
assesment.studStrand = reader["stud_strand"].ToString();
assesment.studAcadTrack = reader["stud_acad_track"].ToString();
assesment.studDateOfBirth = reader["stud_date_of_birth"].ToString();
assesment.studGender = reader["stud_gender"].ToString();
assesment.studBirthPlace = reader["stud_birth_place"].ToString();
assesment.studAddress1 = reader["stud_address1"].ToString();
assesment.studGradeLevel = reader["stud_grade_level"].ToString();
assesment.reqPSA = reader["req_BC"].ToString();
assesment.reqForm138 = reader["req_form138"].ToString();
assesment.reqDrugTest = reader["req_drug_test"].ToString();
assesment.reqAdmissionTest = reader["req_entrance_exam"].ToString();
//add object to list
assesments.Add(assesment);
}
}
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR : " + ex.Message.ToString(), "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(assesments);
}//End of Load
/// <summary>
/// not working
/// </summary>
/// <returns></returns>
public List <Assesment> GetByRegNo1()
{
try
{
//prepare connection string
using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
{
//try to open connection
con.Open();
//prepare sql query
string sql = "SELECT * FROM stud_registration WHERE stud_regNo =@studRegistrationNo;";
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("studRegistrationNo", studRegistrationNo);
MySqlDataReader reader = cmd.ExecuteReader();
//loop while have record
while (reader.Read())
{
//instantiate model
Assesment assesment = new Assesment();
//prepare properties
//assesment.id = Convert.ToInt32(reader["id"].ToString());
assesment.studRegistrationNo = reader["stud_regNo"].ToString();
//assesment.studLastName = reader["stud_lastName"].ToString();
assesments.Add(assesment);
}
}
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR : " + ex.Message.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(assesments);
}
public List <Assesment> LoadStudNo()
{
try
{
//prepare connection string
using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
{
//try to open connection
con.Open();
//prepare sql query
string sql = "SELECT * FROM stud_registration;";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
//loop while have record
while (reader.Read())
{
//instantiate model
Assesment assesment = new Assesment();
//prepare properties
assesment.studRegistrationNo = reader["stud_GOCNo"].ToString();
assesments.Add(assesment);
}
}
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR : " + ex.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(assesments);
}
public void passValue()
{
Assesment assesment = new Assesment();
assesments.Add(assesment);
}