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); }