コード例 #1
0
        public IEnumerable <EMPLEADO> Get([FromUri] EMPLEADO emp)
        {
            IList <EMPLEADO> emps = null;

            using (CICAMEntities entities = new CICAMEntities())
            {
                if (emp.ID != 0)
                {
                    emps = entities.EMPLEADO.Where(e => e.ID == emp.ID).ToList();
                }
                else if (emp.NOMBRE != null && emp.NOMBRE != "")
                {
                    emps = entities.EMPLEADO.Where(e => e.NOMBRE.Contains(emp.NOMBRE)).ToList();
                }
                else if (emp.PUESTO != null && emp.PUESTO != "")
                {
                    emps = entities.EMPLEADO.Where(e => e.PUESTO.Contains(emp.PUESTO)).ToList();
                }
                else if (emp.APELLIDO != null && emp.APELLIDO != "")
                {
                    emps = entities.EMPLEADO.Where(e => e.APELLIDO.Contains(emp.APELLIDO)).ToList();
                }


                return(emps);
            }
        }
コード例 #2
0
 //METODO PARA LISTAR TODOS LOS EMPLEADOS
 public IEnumerable <EMPLEADO> Get()
 {
     using (CICAMEntities entities = new CICAMEntities())
     {
         return(entities.EMPLEADO.ToList());
     }
 }
コード例 #3
0
        public IHttpActionResult GET([FromUri] MARK mark)
        {
            EMPLEADO empAnt = new EMPLEADO();

            //INICIANDO DISPOSITIVO
            zkfp2.Init();
            mDevHandle = zkfp2.OpenDevice(0);

            //CREANDO VECTOR QUE GUARDA HUELLA
            zkfp2.GetParameters(mDevHandle, 1, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpWidth);
            size = 4;
            zkfp2.GetParameters(mDevHandle, 2, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpHeight);


            //CREANDO BYTE PARA HUELLA
            FPBuffer = new byte[mfpWidth * mfpHeight];


            //CREANDO VECTOR PARA DENSIDAD DE HUELLA
            size = 4;
            zkfp2.GetParameters(mDevHandle, 3, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpDpi);


            //INCIANDO BASE DE DATOS DEL LECTOR
            mDBHandle = zkfp2.DBInit();


            ret      = zkfp.ZKFP_ERR_FAIL;
            cbCapTmp = 2048;
            while (ret != zkfp.ZKFP_ERR_OK)
            {
                ret = zkfp2.AcquireFingerprint(mDevHandle, FPBuffer, CapTmp, ref cbCapTmp);
            }

            ret = zkfp2.DBIdentify(mDBHandle, CapTmp, ref fid, ref score);

            if (zkfp.ZKFP_ERR_OK == ret)
            {
                using (CICAMEntities entities = new CICAMEntities())
                {
                    empAnt             = entities.EMPLEADO.Find(fid);
                    mark.EMPE_IDENTITY = empAnt.ID;
                    mark.FECHA         = DateTime.Now.Date;
                    mark.HORA          = DateTime.Now.TimeOfDay;
                    entities.MARK.Add(mark);
                    entities.SaveChanges();
                }

                return(Ok(new { status = "Registro encontrado", ID = fid }));
            }
            else
            {
                return(Ok(new { status = "Registro no encontrado" }));
            }
        }
コード例 #4
0
        public IHttpActionResult post([FromUri] EMPLEADO emp)
        {
            using (CICAMEntities entities = new CICAMEntities())
            {
                entities.EMPLEADO.Add(emp);
                entities.SaveChanges();
            }

            return(Ok(new { StatusCode = 200, message = "Empleado grabado exitosamente" }));
        }
コード例 #5
0
        public IHttpActionResult Delete([FromUri] EMPLEADO emp)
        {
            using (CICAMEntities entities = new CICAMEntities())
            {
                EMPLEADO empAnt = new EMPLEADO();
                empAnt = entities.EMPLEADO.Where(iid => iid.ID == emp.ID).FirstOrDefault();
                entities.Entry(empAnt).State = System.Data.Entity.EntityState.Deleted;
                entities.SaveChanges();
            }

            return(Ok(new { StatusCode = 200, message = "Empleado eliminado exitosamente" }));
        }
コード例 #6
0
        public string POST([FromUri] EMPLEADO emp)
        {
            //INICIANDO DISPOSITIVO
            zkfp2.Init();
            mDevHandle = zkfp2.OpenDevice(0);

            //CREANDO VECTOR QUE GUARDA HUELLA
            zkfp2.GetParameters(mDevHandle, 1, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpWidth);
            size = 4;
            zkfp2.GetParameters(mDevHandle, 2, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpHeight);


            //CREANDO BYTE PARA HUELLA
            FPBuffer = new byte[mfpWidth * mfpHeight];


            //CREANDO VECTOR PARA DENSIDAD DE HUELLA
            size = 4;
            zkfp2.GetParameters(mDevHandle, 3, paramValue, ref size);
            zkfp2.ByteArray2Int(paramValue, ref mfpDpi);


            //INCIANDO BASE DE DATOS DEL LECTOR
            mDBHandle = zkfp2.DBInit();


            //LIMPIANDO BYTES DE LECTURA
            for (int i = 0; i < 3; i++)
            {
                RegTmps[i] = new byte[2048];
            }

            ret      = zkfp.ZKFP_ERR_FAIL;
            cbCapTmp = 2048;
            while (conteo < 3)
            {
                ret = zkfp2.AcquireFingerprint(mDevHandle, FPBuffer, CapTmp, ref cbCapTmp);
                if (ret == zkfp.ZKFP_ERR_OK)
                {
                    Array.Copy(CapTmp, RegTmps[conteo], cbCapTmp);
                    String strBase64 = zkfp2.BlobToBase64(CapTmp, cbCapTmp);
                    byte[] blob      = zkfp2.Base64ToBlob(strBase64);
                    conteo++;
                }
            }

            conteo = 0;
            zkfp2.DBMerge(mDBHandle, RegTmps[0], RegTmps[1], RegTmps[2], RegTmp, ref cbRegTmp);
            String strShow = zkfp2.BlobToBase64(RegTmp, cbCapTmp);

            using (CICAMEntities entities = new CICAMEntities())
            {
                var empAnt = entities.EMPLEADO.Find(emp.ID);
                empAnt.HUELLA = strShow;
                entities.Entry(empAnt).State = System.Data.Entity.EntityState.Modified;
                entities.SaveChanges();
            }
            zkfp2.DBAdd(mDBHandle, emp.ID, RegTmp);
            return(strShow);
        }