public List <personal_kidModel> tb_kid_person(string person)
{
List <personal_kidModel> obj = new List <personal_kidModel>();
using (SqlConnection conn = new SqlConnection(db.sqlConnection))
{
conn.Open();
int i = 0;
SqlCommand cmd = new SqlCommand("SELECT * FROM tab_personal_kid WHERE kid_ref_personal_id = '" + person + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
personal_kidModel kid = new personal_kidModel();;
kid.kid_id = rdr["kid_id"].ToString();
kid.kid_name = rdr["kid_name"].ToString();
kid.kid_lastname = rdr["kid_lastname"].ToString();
kid.kid_age = rdr["kid_age"].ToString();
kid.kid_study_status = rdr["kid_study_status"].ToString();
kid.kid_study_level = rdr["kid_study_level"].ToString();
kid.kid_study_school = rdr["kid_study_school"].ToString();
if (rdr["kid_study_status"].ToString() == "yes")
{
kid.kid_check_yes = "checked";
kid.kid_check_not = "";
}
else if (rdr["kid_study_status"].ToString() == "not")
{
kid.kid_check_yes = "";
kid.kid_check_not = "checked";
}
obj.Add(kid);
i++;
}
conn.Close();
}
return(obj);
}
public List <personal_kidModel> tb_kid(string id)
{
List <personal_kidModel> obj = new List <personal_kidModel>();
using (SqlConnection conn = new SqlConnection(db.sqlConnection)) {
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tab_personal_kid INNER JOIN tab_emp ON tab_emp.ep_ref_personal_id = tab_personal_kid.kid_ref_personal_id WHERE tab_emp.ep_id = '" + id + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
personal_kidModel kid = new personal_kidModel();;
kid.kid_name = rdr["kid_name"].ToString();
kid.kid_lastname = rdr["kid_lastname"].ToString();
kid.kid_age = rdr["kid_age"].ToString();
if (rdr["kid_study_status"].ToString() == "yes")
{
kid.kid_study_status = "กำลังศึกษา";
kid.kid_study_level = rdr["kid_study_level"].ToString();
kid.kid_study_school = rdr["kid_study_school"].ToString();
}
else
{
kid.kid_study_status = "-";
kid.kid_study_level = "-";
kid.kid_study_school = "-";
}
obj.Add(kid);
}
conn.Close();
}
return(obj);
}