/// <summary> /// Altera tbAdquirente /// </summary> /// <param name="param"></param> /// <returns></returns> public static void Update(string token, tbAdquirente param, painel_taxservices_dbContext _dbContext = null) { painel_taxservices_dbContext _db; if (_dbContext == null) { _db = new painel_taxservices_dbContext(); } else { _db = _dbContext; } try { tbAdquirente value = _db.tbAdquirentes .Where(e => e.cdAdquirente.Equals(param.cdAdquirente)) .First <tbAdquirente>(); if (param.cdAdquirente != value.cdAdquirente) { value.cdAdquirente = param.cdAdquirente; } if (param.nmAdquirente != null && param.nmAdquirente != value.nmAdquirente) { value.nmAdquirente = param.nmAdquirente; } if (param.dsAdquirente != null && param.dsAdquirente != value.dsAdquirente) { value.dsAdquirente = param.dsAdquirente; } if (param.stAdquirente != value.stAdquirente) { value.stAdquirente = param.stAdquirente; } if (param.hrExecucao != null && param.hrExecucao != value.hrExecucao) { value.hrExecucao = param.hrExecucao; } _db.SaveChanges(); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao listar parâmetros bancários" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } finally { if (_dbContext == null) { // Fecha conexão _db.Database.Connection.Close(); _db.Dispose(); } } }
// PUT /tbAdquirente/token/ public HttpResponseMessage Put(string token, [FromBody] tbAdquirente param) { // Abre nova conexão using (painel_taxservices_dbContext _db = new painel_taxservices_dbContext()) { tbLogAcessoUsuario log = new tbLogAcessoUsuario(); try { log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Put", _db); HttpResponseMessage retorno = new HttpResponseMessage(); if (Permissoes.Autenticado(token, _db)) { GatewayTbAdquirente.Update(token, param, _db); log.codResposta = (int)HttpStatusCode.OK; Bibliotecas.LogAcaoUsuario.Save(log, _db); return(Request.CreateResponse(HttpStatusCode.OK)); } else { log.codResposta = (int)HttpStatusCode.Unauthorized; Bibliotecas.LogAcaoUsuario.Save(log, _db); return(Request.CreateResponse(HttpStatusCode.Unauthorized)); } } catch (Exception e) { log.codResposta = (int)HttpStatusCode.InternalServerError; log.msgErro = e.Message; Bibliotecas.LogAcaoUsuario.Save(log); throw new HttpResponseException(HttpStatusCode.InternalServerError); } } }
/// <summary> /// Adiciona nova TbAdquirente /// </summary> /// <param name="param"></param> /// <returns></returns> public static Int32 Add(string token, tbAdquirente param, painel_taxservices_dbContext _dbContext = null) { painel_taxservices_dbContext _db; if (_dbContext == null) { _db = new painel_taxservices_dbContext(); } else { _db = _dbContext; } try { _db.tbAdquirentes.Add(param); _db.SaveChanges(); return(param.cdAdquirente); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao listar parâmetros bancários" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } finally { if (_dbContext == null) { // Fecha conexão _db.Database.Connection.Close(); _db.Dispose(); } } }