/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <GroupCompositeType> getAll() { List <GroupCompositeType> lst = new List <GroupCompositeType>(); DataTable dt = objDB.Consult("sp_selectGroup"); foreach (DataRow dr in dt.Rows) { GroupCompositeType et = new GroupCompositeType(); et.iIdGroup = int.Parse(dr.ItemArray[0].ToString()); et.sDescription = dr.ItemArray[1].ToString(); et.bStatus = bool.Parse(dr.ItemArray[2].ToString()); lst.Add(et); } return(lst); }
public GroupCompositeType GetGroupById(int iIdGroup) { GroupCompositeType et = new GroupCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_group", SqlDbType.Int) { Value = iIdGroup }; DataTable dt = objDB.ExecStore("sp_getGroupById", param); et.iIdGroup = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.sDescription = dt.Rows[0].ItemArray[1].ToString(); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[2].ToString()); return(et); }