Beispiel #1
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <ExchangeTypeCompositeType> getAll()
        {
            List <ExchangeTypeCompositeType> lst = new List <ExchangeTypeCompositeType>();


            //try
            //{

            DataTable dt = objDB.Consult("sp_selectExchangeType");


            foreach (DataRow dr in dt.Rows)
            {
                ExchangeTypeCompositeType et = new ExchangeTypeCompositeType();
                et.iIdExchangeType = int.Parse(dr.ItemArray[0].ToString());
                et.sDescription    = dr.ItemArray[1].ToString();
                et.bStatus         = bool.Parse(dr.ItemArray[2].ToString());
                et.sInitial        = dr.ItemArray[3].ToString();

                lst.Add(et);
            }
            return(lst);
            //}
            //catch (Exception ex)
            //{
            //    throw ex.Message();
            //}
        }
Beispiel #2
0
        public List <employedCompositeType> getAll()
        {
            List <employedCompositeType> lst = new List <employedCompositeType>();


            DataTable dt = objDB.Consult("sp_selectEmployed");


            foreach (DataRow dr in dt.Rows)
            {
                employedCompositeType et = new employedCompositeType();
                et.iIdEmployed      = int.Parse(dr.ItemArray[0].ToString());
                et.iNumber          = int.Parse(dr.ItemArray[1].ToString());
                et.sName            = dr.ItemArray[2].ToString();
                et.sMLastName       = dr.ItemArray[3].ToString();
                et.sFLastName       = dr.ItemArray[4].ToString();
                et.sEMail           = dr.ItemArray[5].ToString();
                et.iStatus          = int.Parse(dr.ItemArray[6].ToString());
                et.iIdArea          = int.Parse(dr.ItemArray[7].ToString());
                et.iIdPlant         = int.Parse(dr.ItemArray[9].ToString());
                et.dDate            = DateTime.Parse(dr.ItemArray[11].ToString());
                et.iBoss            = int.Parse(dr.ItemArray[12].ToString());
                et.iSubstitute      = int.Parse(dr.ItemArray[13].ToString());
                et.sBoss            = dr.ItemArray[14].ToString();
                et.sSubstitute      = dr.ItemArray[15].ToString();
                et.sCompleteName    = dr.ItemArray[16].ToString();
                et.sDescriptionArea = dr.ItemArray[8].ToString();                 //Add
                lst.Add(et);
            }
            return(lst);
        }
Beispiel #3
0
        /// <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();
            //}
        }
Beispiel #4
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <reviewTypeCompositeType> getAll()
        {
            var dt = objDB.Consult("sp_selectReviewType");

            return((from DataRow dr in dt.Rows
                    select new reviewTypeCompositeType
            {
                iIdReviewType = int.Parse(dr.ItemArray[0].ToString()), sDescription = dr.ItemArray[1].ToString(), bStatus = bool.Parse(dr.ItemArray[2].ToString())
            }).ToList());
        }
Beispiel #5
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <PriorityCompositeType> getAll()
        {
            DataTable dt = objDB.Consult("sp_selectPriority");

            return((from DataRow dr in dt.Rows
                    select new PriorityCompositeType
            {
                iIdPriority = int.Parse(dr.ItemArray[0].ToString()),
                sDescription = dr.ItemArray[1].ToString(),
                bStatus = bool.Parse(dr.ItemArray[2].ToString())
            }).ToList());
        }
Beispiel #6
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 #7
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <affectationTypeCompositeType> getAll()
        {
            var       lst = new List <affectationTypeCompositeType>();
            DataTable dt  = objDB.Consult("sp_selectAffectationType");

            foreach (DataRow dr in dt.Rows)
            {
                var et = new affectationTypeCompositeType
                {
                    iIdAffectationType = int.Parse(dr.ItemArray[0].ToString()),
                    sDescription       = dr.ItemArray[1].ToString(),
                    bStatus            = bool.Parse(dr.ItemArray[2].ToString())
                };
                lst.Add(et);
            }
            return(lst);
        }
Beispiel #8
0
 public List <menuCompositeType> getAll()
 {
     try
     {
         DataTable dt = objDB.Consult("sp_selectMenu");
         return((from DataRow dr in dt.Rows
                 select new menuCompositeType
         {
             sDescription = dr.ItemArray[1].ToString(),
             sURL = dr.ItemArray[3].ToString()
         }).ToList());
     }
     catch (Exception ex)
     {
         throw new Exception();
     }
 }
Beispiel #9
0
        public List <RolCompositeType> getAll()
        {
            var       lst = new List <RolCompositeType>();
            DataTable dt  = objDB.Consult("sp_selectRol");

            foreach (DataRow dr in dt.Rows)
            {
                var et = new RolCompositeType
                {
                    iIdRol       = int.Parse(dr.ItemArray[0].ToString()),
                    dRegistry    = DateTime.Parse(dr.ItemArray[2].ToString()),
                    sDescription = dr.ItemArray[1].ToString(),
                    bStatus      = bool.Parse(dr.ItemArray[3].ToString())
                };
                lst.Add(et);
            }
            return(lst);
        }
Beispiel #10
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <PartListCompositeType> getAll()
        {
            var       lst = new List <PartListCompositeType>();
            DataTable dt  = objDB.Consult("sp_selectPartList");

            foreach (DataRow dr in dt.Rows)
            {
                var et = new PartListCompositeType
                {
                    iIdPart       = int.Parse(dr.ItemArray[0].ToString()),
                    iNumber       = dr.ItemArray[1].ToString(),
                    sDescription  = dr.ItemArray[2].ToString(),
                    bStatus       = bool.Parse(dr.ItemArray[4].ToString()),
                    iNumberClient = dr.ItemArray[3].ToString()
                };
                lst.Add(et);
            }
            return(lst);
        }
Beispiel #11
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <taskCompositeType> getAll()
        {
            List <taskCompositeType> lst = new List <taskCompositeType>();
            DataTable dt = objDB.Consult("sp_selectTask");

            foreach (DataRow dr in dt.Rows)
            {
                var et = new taskCompositeType
                {
                    iIdTask          = int.Parse(dr.ItemArray[0].ToString()),
                    sDescription     = dr.ItemArray[1].ToString(),
                    bStatus          = bool.Parse(dr.ItemArray[2].ToString()),
                    iIdArea          = int.Parse(dr.ItemArray[3].ToString()),
                    sDescriptionArea = dr.ItemArray[4].ToString()
                };
                lst.Add(et);
            }
            return(lst);
        }
Beispiel #12
0
        /// <summary>
        /// Obtiene todos los Tipos de Cambio
        /// </summary>
        /// <returns></returns>
        public List <DataTypeCompositeType> getAll()
        {
            var lst = new List <DataTypeCompositeType>();

            try
            {
                DataTable dt = objDB.Consult("sp_selectDataType");
                foreach (DataRow dr in dt.Rows)
                {
                    var swap = new DataTypeCompositeType
                    {
                        iIdDataType  = int.Parse(dr.ItemArray[0].ToString()),
                        sDescription = dr.ItemArray[1].ToString(),
                        bStatus      = bool.Parse(dr.ItemArray[2].ToString())
                    };
                    lst.Add(swap);
                }
                return(lst);
            }
            catch (Exception ex)
            {
                throw new Exception();
            }
        }
Beispiel #13
0
 public int getNumberPreFolio()
 {
     return(int.Parse(objDB.Consult("[sp_getPreFolio]").Rows[0].ItemArray[0].ToString()));
 }
Beispiel #14
0
 public DataTable GetAll()
 {
     return(objDB.Consult("sp_selectSalesAutorization_Type"));
 }