Beispiel #1
0
        /// <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);
        }
Beispiel #2
0
        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);
        }