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