public TaskGroupCompositeType GetTaskGroupById(int iIdTaskGroup) { TaskGroupCompositeType et = new TaskGroupCompositeType(); //try //{ param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_task_group", SqlDbType.Int); param[0].Value = iIdTaskGroup; DataTable dt = objDB.ExecStore("sp_getTaskGroupById", param); et.iIdTaskGroup = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.iIdTask = int.Parse(dt.Rows[0].ItemArray[1].ToString()); et.iIdGroup = int.Parse(dt.Rows[0].ItemArray[2].ToString()); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[3].ToString()); et.sDescriptionTask = dt.Rows[0].ItemArray[3].ToString(); et.sDescriptionGroup = dt.Rows[0].ItemArray[3].ToString(); return(et); //} //catch (Exception ex) //{ // throw ex.Message(); //} }
/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <TaskGroupCompositeType> getAll() { List <TaskGroupCompositeType> lst = new List <TaskGroupCompositeType>(); //try //{ DataTable dt = objDB.Consult("sp_selectTaskGroup"); foreach (DataRow dr in dt.Rows) { TaskGroupCompositeType et = new TaskGroupCompositeType(); et.iIdTaskGroup = int.Parse(dr.ItemArray[0].ToString()); et.iIdTask = int.Parse(dr.ItemArray[1].ToString()); et.iIdGroup = int.Parse(dr.ItemArray[2].ToString()); et.bStatus = bool.Parse(dr.ItemArray[3].ToString()); et.sDescriptionTask = dr.ItemArray[4].ToString(); et.sDescriptionGroup = dr.ItemArray[5].ToString(); lst.Add(et); } return(lst); //} //catch (Exception ex) //{ // throw ex.Message(); //} }