Example #1
0
        public int ValidarIdentityCode_Libre(string identityCode)
        {
            int Id_User = -1;

            try
            {
                var    accessor = new DataAccesor(_connectionString);
                string ic       = accessor.ParameterIdentifierCharacter();

                var sql = string.Format(@"select 
                                        Id
                                        from Usuario
                                        where
                                            IdentityCode = " + ic + "{0}",
                                        Arguments.Identity_Code);



                List <IDataParameter> parameters = new List <IDataParameter>()
                {
                    accessor.Parameter(Arguments.Identity_Code, identityCode)
                };

                //var ds = accessor.FillDataSet(sql, parameters);
                Id_User = Convert.ToInt32(accessor.ExecuteScalar(sql, parameters, false));
            }
            catch (Exception ex)
            {
                log.Error("ValidarIdentityCode_Libre(IdentityCode: {0})", ex, identityCode);
            }
            return(Id_User);
        }