//Add public List <employedCompositeType> getEmployedArea(String sArea) { List <employedCompositeType> lst = new List <employedCompositeType>(); param = new SqlParameter[1]; param[0] = new SqlParameter("@area", SqlDbType.VarChar); param[0].Value = sArea; DataTable dt = objDB.ExecStore("sp_selectEmployedByNameArea", param); foreach (DataRow dr in dt.Rows) { employedCompositeType et = new employedCompositeType(); et.iIdEmployed = int.Parse(dr.ItemArray[0].ToString()); et.iNumber = int.Parse(dr.ItemArray[1].ToString()); et.sName = dr.ItemArray[2].ToString(); et.sMLastName = dr.ItemArray[3].ToString(); et.sFLastName = dr.ItemArray[4].ToString(); et.sEMail = dr.ItemArray[5].ToString(); et.iStatus = int.Parse(dr.ItemArray[6].ToString()); et.iIdArea = int.Parse(dr.ItemArray[7].ToString()); et.iIdPlant = int.Parse(dr.ItemArray[8].ToString()); et.dDate = DateTime.Parse(dr.ItemArray[9].ToString()); et.iBoss = int.Parse(dr.ItemArray[10].ToString()); et.iSubstitute = int.Parse(dr.ItemArray[11].ToString()); et.sCompleteName = dr.ItemArray[12].ToString(); lst.Add(et); } return(lst); }
public List <employedCompositeType> getAll() { List <employedCompositeType> lst = new List <employedCompositeType>(); DataTable dt = objDB.Consult("sp_selectEmployed"); foreach (DataRow dr in dt.Rows) { employedCompositeType et = new employedCompositeType(); et.iIdEmployed = int.Parse(dr.ItemArray[0].ToString()); et.iNumber = int.Parse(dr.ItemArray[1].ToString()); et.sName = dr.ItemArray[2].ToString(); et.sMLastName = dr.ItemArray[3].ToString(); et.sFLastName = dr.ItemArray[4].ToString(); et.sEMail = dr.ItemArray[5].ToString(); et.iStatus = int.Parse(dr.ItemArray[6].ToString()); et.iIdArea = int.Parse(dr.ItemArray[7].ToString()); et.iIdPlant = int.Parse(dr.ItemArray[9].ToString()); et.dDate = DateTime.Parse(dr.ItemArray[11].ToString()); et.iBoss = int.Parse(dr.ItemArray[12].ToString()); et.iSubstitute = int.Parse(dr.ItemArray[13].ToString()); et.sBoss = dr.ItemArray[14].ToString(); et.sSubstitute = dr.ItemArray[15].ToString(); et.sCompleteName = dr.ItemArray[16].ToString(); et.sDescriptionArea = dr.ItemArray[8].ToString(); //Add lst.Add(et); } return(lst); }
public employedCompositeType GetEmployedById(int iIdEmployed) { employedCompositeType et = new employedCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_Employed", SqlDbType.Int); param[0].Value = iIdEmployed; DataTable dt = objDB.ExecStore("sp_getEmployedById", param); if (dt.Rows.Count > 0) { et.iIdEmployed = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.iNumber = int.Parse(dt.Rows[0].ItemArray[1].ToString()); et.sName = dt.Rows[0].ItemArray[2].ToString(); et.sMLastName = dt.Rows[0].ItemArray[3].ToString(); et.sFLastName = dt.Rows[0].ItemArray[4].ToString(); et.sEMail = dt.Rows[0].ItemArray[5].ToString(); et.iStatus = int.Parse(dt.Rows[0].ItemArray[6].ToString()); et.iIdArea = int.Parse(dt.Rows[0].ItemArray[7].ToString()); et.iIdPlant = int.Parse(dt.Rows[0].ItemArray[8].ToString()); et.dDate = DateTime.Parse(dt.Rows[0].ItemArray[9].ToString()); et.iBoss = int.Parse(dt.Rows[0].ItemArray[10].ToString()); et.iSubstitute = int.Parse(dt.Rows[0].ItemArray[11].ToString()); et.sBoss = dt.Rows[0].ItemArray[12].ToString(); et.sSubstitute = dt.Rows[0].ItemArray[13].ToString(); et.sCompleteName = dt.Rows[0].ItemArray[14].ToString(); } else { et = null; } return(et); }