public TaskDataCompositeType GetTaskDataById(int iIdTaskData) { TaskDataCompositeType et = new TaskDataCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_task_data", SqlDbType.Int) { Value = iIdTaskData }; DataTable dt = objDB.ExecStore("sp_getTaskDataById", param); et.iIdTaskData = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.iIdTask = int.Parse(dt.Rows[0].ItemArray[1].ToString()); et.iIdData = int.Parse(dt.Rows[0].ItemArray[2].ToString()); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[3].ToString()); et.sDescriptionTask = dt.Rows[0].ItemArray[4].ToString(); et.sDescriptionData = dt.Rows[0].ItemArray[5].ToString(); et.sDescription = dt.Rows[0].ItemArray[6].ToString(); return(et); }
/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <TaskDataCompositeType> getAll() { List <TaskDataCompositeType> lst = new List <TaskDataCompositeType>(); DataTable dt = objDB.Consult("sp_selectTaskData"); foreach (DataRow dr in dt.Rows) { var et = new TaskDataCompositeType { iIdTaskData = int.Parse(dr.ItemArray[0].ToString()), iIdTask = int.Parse(dr.ItemArray[1].ToString()), iIdData = int.Parse(dr.ItemArray[2].ToString()), bStatus = bool.Parse(dr.ItemArray[3].ToString()), sDescriptionTask = dr.ItemArray[4].ToString(), sDescriptionData = dr.ItemArray[5].ToString(), sDescription = dr.ItemArray[6].ToString() }; lst.Add(et); } return(lst); }