/// <summary> /// Realiza a autenticação do usuário. /// </summary> /// <param name="actionContext"></param> /// <returns></returns> private bool Autenticar(HttpActionContext actionContext) { if (actionContext.Request.Headers != null && actionContext.Request.Headers.Authorization != null && actionContext.Request.Headers.Authorization.Scheme.Equals(SCHEME)) { try { string credenciais = actionContext.Request.Headers.Authorization.Parameter; if (!string.IsNullOrWhiteSpace(credenciais)) { string[] parametros = Encoding.UTF8.GetString(Convert.FromBase64String(credenciais)).Split(':'); SYS_UsuarioAPI entityUsuarioAPI = new SYS_UsuarioAPI { uap_usuario = parametros[0].Trim() , uap_senha = parametros[1].Trim() }; return(SYS_UsuarioAPIBO.AutenticarUsuario(entityUsuarioAPI)); } else { return(false); } } catch (Exception) { return(false); } } else { return(false); } }
protected override void ParamDeletar(QueryStoredProcedure qs, SYS_UsuarioAPI entity) { if (entity != null & qs != null) { Param = qs.NewParameter(); Param.DbType = DbType.Int32; Param.ParameterName = "@uap_id"; Param.Size = 4; Param.Value = entity.uap_id; qs.Parameters.Add(Param); Param = qs.NewParameter(); Param.DbType = DbType.Byte; Param.ParameterName = "@uap_situacao"; Param.Size = 3; Param.Value = entity.uap_situacao; qs.Parameters.Add(Param); Param = qs.NewParameter(); Param.DbType = DbType.DateTime; Param.ParameterName = "@uap_dataAlteracao"; Param.Value = DateTime.Now; qs.Parameters.Add(Param); } }
protected override bool Alterar(SYS_UsuarioAPI entity) { __STP_UPDATE = "NEW_SYS_UsuarioAPI_UPDATE"; return(base.Alterar(entity)); }
protected override void ParamAlterar(QueryStoredProcedure qs, SYS_UsuarioAPI entity) { entity.uap_dataAlteracao = DateTime.Now; base.ParamAlterar(qs, entity); qs.Parameters.RemoveAt("@uap_dataCriacao"); }
protected override void ParamInserir(QuerySelectStoredProcedure qs, SYS_UsuarioAPI entity) { entity.uap_dataCriacao = entity.uap_dataAlteracao = DateTime.Now; base.ParamInserir(qs, entity); }
public override bool Delete(SYS_UsuarioAPI entity) { __STP_DELETE = "NEW_SYS_UsuarioAPI_UpdateSituacao"; return(base.Delete(entity)); }