public List <personal_workModel> tb_work_person(string person)
{
List <personal_workModel> obj = new List <personal_workModel>();
using (SqlConnection conn = new SqlConnection(db.sqlConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tab_personal_work WHERE work_ref_personal_id = '" + person + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
personal_workModel pw = new personal_workModel();
pw.work_company = rdr["work_company"].ToString();
pw.work_position = rdr["work_position"].ToString();
pw.work_address = rdr["work_address"].ToString();
pw.work_start = Convert.ToDateTime(rdr["work_start"]).ToString("dd/MM/yyyy");
pw.work_end = Convert.ToDateTime(rdr["work_end"]).ToString("dd/MM/yyyy");
pw.work_id = rdr["work_id"].ToString();
pw.work_ref_personal_id = rdr["work_ref_personal_id"].ToString();
pw.work_ref_admin_id = rdr["work_ref_admin_id"].ToString();
pw.work_submit_date = rdr["work_submit_date"].ToString();
obj.Add(pw);
}
conn.Close();
}
return(obj);
}
public List <personal_workModel> tb_work(string id)
{
List <personal_workModel> obj = new List <personal_workModel>();
using (SqlConnection conn = new SqlConnection(db.sqlConnection)) {
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tab_personal_work INNER JOIN tab_emp ON tab_emp.ep_ref_personal_id = tab_personal_work.work_ref_personal_id WHERE tab_emp.ep_id = '" + id + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
personal_workModel pw = new personal_workModel();
pw.work_company = rdr["work_company"].ToString();
pw.work_position = rdr["work_position"].ToString();
pw.work_address = rdr["work_address"].ToString();
pw.work_start = rdr["work_start"].ToString();
pw.work_end = rdr["work_end"].ToString();
obj.Add(pw);
}
conn.Close();
}
return(obj);
}
