public hrmanager rec(string req_id) { dal dl = new dal(); DataTable dt = dl.status(); hrmanager cls = new hrmanager(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].ItemArray[8].ToString() == req_id) { //cls.appl_id = Convert.ToInt32(dt.Rows[i].ItemArray[0].ToString()); cls.appl_id = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString());; cls.job_desc = dt.Rows[i].ItemArray[7].ToString(); //cls.min_qualification = dt.Rows[i].ItemArray[2].ToString(); //cls.pref_qualification = dt.Rows[i].ItemArray[3].ToString(); //cls.resp = dt.Rows[i].ItemArray[4].ToString(); cls.req_id = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString()); cls.appstatus = dt.Rows[i].ItemArray[9].ToString(); cls.manager_name = dt.Rows[i].ItemArray[0].ToString(); cls.project_name = dt.Rows[i].ItemArray[1].ToString(); cls.period_month = Convert.ToInt32(dt.Rows[i].ItemArray[2].ToString()); cls.noof_vacancies = Convert.ToInt32(dt.Rows[i].ItemArray[3].ToString()); cls.skill = dt.Rows[i].ItemArray[4].ToString(); cls.pgm_languages = dt.Rows[i].ItemArray[5].ToString(); cls.exp_years = Convert.ToInt32(dt.Rows[i].ItemArray[6].ToString()); cls.desg = dt.Rows[i].ItemArray[10].ToString(); cls.dateapp = dt.Rows[i].ItemArray[11].ToString(); } } return(cls); }
public List <managerreq> record(string name) { DataTable dt = d.status(); for (int i = 0; i < dt.Rows.Count; i++) { mgr = new managerreq(); if (dt.Rows[i].ItemArray[0].ToString() == name) { mgr.reqid = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString()); mgr.status = dt.Rows[i].ItemArray[9].ToString(); mgr.prjname = dt.Rows[i].ItemArray[1].ToString(); //mgr.date = Convert.ToDateTime(dt.Rows[i].ItemArray[10].ToString()); ls.Add(mgr); } } return(ls); }