public HttpResponseMessage Get()
{
List <tbStatusCarta> readstatus = new List <tbStatusCarta>();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
List <StatusCarta> liststatus = new List <StatusCarta>();
try
{
readstatus = CRUD.readStatusCarta();
if (readstatus.Count > 0)
{
for (int i = 0; i < readstatus.Count; i++)
{
StatusCarta status = new StatusCarta();
status.Id = readstatus[i].cd_statuscarta;
status.Nome = readstatus[i].de_statuscarta;
liststatus.Add(status);
status = null;
}
}
return(this.Request.CreateResponse(HttpStatusCode.OK, liststatus));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage GetList(long id)
{
List <tbPropostaCarta> tpropostas = new List <tbPropostaCarta>();
List <PropostaCarta> propostas = new List <PropostaCarta>();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
tpropostas = CRUD.readPropostasCarta(id);
foreach (tbPropostaCarta item in tpropostas)
{
PropostaCarta pCarta = new PropostaCarta();
pCarta.Id = item.cd_propostacarta;
pCarta.IdCarta = item.cd_cartacredito;
pCarta.IdComprador = item.cd_comprador;
pCarta.IdVendedor = item.cd_vendedor;
pCarta.StatusProposta = item.cd_statusproposta;
pCarta.MensagemProposta = item.de_mensagemproposta;
propostas.Add(pCarta);
pCarta = null;
}
return(this.Request.CreateResponse(HttpStatusCode.OK, propostas));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] Users value)
{
tbUsers newUser = new tbUsers();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newUser.de_username = value.UserName;
newUser.nm_user = value.Nome;
newUser.nm_apelido = value.Apelido;
newUser.cd_fisjur = value.FisJur;
newUser.cd_cpf = value.CPF;
newUser.cd_cnpj = value.CNPJ;
newUser.cd_ie = value.IE;
newUser.de_telefone = value.Telefone;
newUser = CRUD.insertUser(newUser);
value.Id = newUser.id_user;
return(this.Request.CreateResponse(HttpStatusCode.OK, value));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Put(string id, [FromBody] Users value)
{
tbUsers upUser = new tbUsers();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
upUser.id_user = id;
upUser.de_username = value.UserName;
upUser.nm_user = value.Nome;
upUser.nm_apelido = value.Apelido;
upUser.cd_fisjur = value.FisJur;
upUser.cd_cpf = value.CPF;
upUser.cd_cnpj = value.CNPJ;
upUser.cd_ie = value.IE;
upUser.de_telefone = value.Telefone;
CRUD.updateUser(upUser);
return(this.Request.CreateResponse(HttpStatusCode.OK, value));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get()
{
List <tbAdmConsorcio> readadmconsorcio = new List <tbAdmConsorcio>();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
List <AdmConsorcio> listadmconsorcio = new List <AdmConsorcio>();
try
{
readadmconsorcio = CRUD.readAdmConsorcio();
if (readadmconsorcio.Count > 0)
{
for (int i = 0; i < readadmconsorcio.Count; i++)
{
AdmConsorcio admcons = new AdmConsorcio();
admcons.Id = readadmconsorcio[i].cd_admconsorcio;
admcons.Nome = readadmconsorcio[i].nm_admconsorcio;
listadmconsorcio.Add(admcons);
admcons = null;
}
}
return(this.Request.CreateResponse(HttpStatusCode.OK, listadmconsorcio));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get(string id)
{
Users retUser = new Users();
tbUsers user = new tbUsers();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
user = CRUD.readUser(id);
retUser.Id = id;
retUser.UserName = user.de_username;
retUser.Nome = user.nm_user;
retUser.Apelido = user.nm_apelido;
retUser.FisJur = user.cd_fisjur;
retUser.CPF = user.cd_cpf;
retUser.CNPJ = user.cd_cnpj;
retUser.IE = user.cd_ie;
retUser.Blocked = user.bit_bloqueio;
retUser.Telefone = user.de_telefone;
return(this.Request.CreateResponse(HttpStatusCode.OK, retUser));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get()
{
List <tbTipoConsorcio> readtipoconsorcio = new List <tbTipoConsorcio>();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
List <TipoConsorcio> listtipoconsorcio = new List <TipoConsorcio>();
try
{
readtipoconsorcio = CRUD.readTipoConsorcio();
if (readtipoconsorcio.Count > 0)
{
for (int i = 0; i < readtipoconsorcio.Count; i++)
{
TipoConsorcio status = new TipoConsorcio();
status.Id = readtipoconsorcio[i].cd_tipoconsorcio;
status.Nome = readtipoconsorcio[i].de_tipoconsorcio;
listtipoconsorcio.Add(status);
status = null;
}
}
return(this.Request.CreateResponse(HttpStatusCode.OK, listtipoconsorcio));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] CartaCredito value)
{
tbCartaCredito newCarta = new tbCartaCredito();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newCarta.cd_admconsorcio = value.AdmConsorcio;
newCarta.cd_tipoconsorcio = value.TipoConsorcio;
newCarta.cd_vendedor = value.IdVendedor;
newCarta.de_cidade = value.Cidade;
newCarta.de_uf = value.UF;
newCarta.cd_statuscarta = value.StatusCarta;
newCarta.de_indexador = value.Indexador;
newCarta.nu_honorarios = value.Honorarios;
newCarta.nu_qtd_parcelas = value.QtdParcelas;
newCarta.nu_saldocarta = value.SaldoCarta;
newCarta.nu_taxajuros = value.TaxaJuros;
newCarta.nu_valorcredito = value.ValorCredito;
newCarta.nu_valorentrada = value.ValorEntrada;
newCarta.nu_valorparcela = value.ValorParcela;
CRUD.insertCartaCredito(newCarta);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get(Int64 id)
{
tbCartaCredito readCarta = new tbCartaCredito();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
CartaCredito carta = new CartaCredito();
try
{
readCarta = CRUD.readCartaCredito(id);
carta.Id = readCarta.cd_cartacredito;
carta.AdmConsorcio = readCarta.cd_admconsorcio;
carta.TipoConsorcio = readCarta.cd_tipoconsorcio;
carta.IdVendedor = readCarta.cd_vendedor;
carta.StatusCarta = readCarta.cd_statuscarta;
carta.Cidade = readCarta.de_cidade;
carta.UF = readCarta.de_uf;
carta.Indexador = readCarta.de_indexador;
carta.Honorarios = readCarta.nu_honorarios;
carta.QtdParcelas = readCarta.nu_qtd_parcelas;
carta.SaldoCarta = readCarta.nu_saldocarta;
carta.TaxaJuros = readCarta.nu_taxajuros;
carta.ValorCredito = readCarta.nu_valorcredito;
carta.ValorEntrada = readCarta.nu_valorentrada;
carta.ValorParcela = readCarta.nu_valorparcela;
return(this.Request.CreateResponse(HttpStatusCode.OK, carta));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
//// GET: api/QualificacaoComprador
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
//// GET: api/QualificacaoComprador/5
//public string Get(int id)
//{
// return "value";
//}
// POST: api/QualificacaoComprador
public void Post([FromBody] QualificacaoComprador value)
{
tbQualificacaoComprador newQualificacao = new tbQualificacaoComprador();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
newQualificacao.cd_cartacredito = value.IdCarta;
newQualificacao.cd_comprador = value.IdComprador;
newQualificacao.cd_vendedor = value.IdVendedor;
newQualificacao.nu_pontuacao = value.Pontuacao;
newQualificacao.de_observacaovendedor = value.ObservacaoVendedor;
CRUD.insertQualificacaoComprador(newQualificacao);
}
public HttpResponseMessage Post([FromBody] Comprador value)
{
tbComprador newComprador = new tbComprador();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newComprador.id_user = value.IdUser;
CRUD.insertComprador(newComprador);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Delete(string id)
{
tbUsers delUser = new tbUsers();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
delUser.id_user = id;
CRUD.deleteUser(delUser);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Put(string id, [FromBody] UserPassword value)
{
tbUserPassword upPassword = new tbUserPassword();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
upPassword.id_user = id;
upPassword.de_password = value.Password;
CRUD.updateUserPassword(upPassword);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] AnexoCarta value)
{
tbAnexoCarta newAnexo = new tbAnexoCarta();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newAnexo.cd_cartacredito = value.IdCarta;
newAnexo.de_linkanexo = value.LinkAnexo;
CRUD.insertAnexoCarta(newAnexo);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] UserPassword value)
{
tbUserPassword newPassword = new tbUserPassword();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newPassword.id_user = value.Id;
newPassword.de_password = value.Password;
CRUD.insertUserPassword(newPassword);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Put(string id, [FromBody] AnexoCarta value)
{
tbAnexoCarta upAnexo = new tbAnexoCarta();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
upAnexo.id_anexo = id;
upAnexo.cd_cartacredito = value.IdCarta;
upAnexo.de_linkanexo = value.LinkAnexo;
CRUD.updateAnexoCarta(upAnexo);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] PropostaCarta value)
{
tbPropostaCarta newPropostaCarta = new tbPropostaCarta();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
newPropostaCarta.cd_cartacredito = value.IdCarta;
newPropostaCarta.cd_comprador = value.IdComprador;
newPropostaCarta.cd_vendedor = value.IdVendedor;
newPropostaCarta.de_mensagemproposta = value.MensagemProposta;
CRUD.insertPropostaCarta(newPropostaCarta);
return(this.Request.CreateResponse(HttpStatusCode.NoContent));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Put(long id, [FromBody] Comprador value)
{
tbComprador upComprador = new tbComprador();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
upComprador.cd_comprador = id;
upComprador.id_user = value.IdUser;
upComprador.nu_qual_negativa = value.NegativeFeedback;
upComprador.nu_qual_positiva = value.PositiveFeedback;
upComprador.bt_bloqueado = value.Blocked;
CRUD.updateComprador(upComprador);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public IEnumerable <CartaCredito> Post([FromBody] Models.Filter value)
{
List <tbCartaCredito> readCarta = new List <tbCartaCredito>();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
List <CartaCredito> listCarta = new List <CartaCredito>();
readCarta = CRUD.readCartasCredito(value.ValorCreditoDe, value.ValorCreditoAte, value.IdUser, value.StatusCarta, value.RemoveProposta);
if (readCarta.Count > 0)
{
for (int i = 0; i < readCarta.Count; i++)
{
CartaCredito carta = new CartaCredito();
carta.Id = readCarta[i].cd_cartacredito;
carta.IdVendedor = readCarta[i].cd_vendedor;
carta.AdmConsorcio = readCarta[i].cd_admconsorcio;
carta.TipoConsorcio = readCarta[i].cd_tipoconsorcio;
carta.Cidade = readCarta[i].de_cidade;
carta.Honorarios = readCarta[i].nu_honorarios;
carta.Indexador = readCarta[i].de_indexador;
carta.QtdParcelas = readCarta[i].nu_qtd_parcelas;
carta.SaldoCarta = readCarta[i].nu_saldocarta;
carta.StatusCarta = readCarta[i].cd_statuscarta;
carta.TaxaJuros = readCarta[i].nu_taxajuros;
carta.UF = readCarta[i].de_uf;
carta.ValorCredito = readCarta[i].nu_valorcredito;
carta.ValorEntrada = readCarta[i].nu_valorentrada;
carta.ValorParcela = readCarta[i].nu_valorparcela;
listCarta.Add(carta);
carta = null;
}
}
return(listCarta);
}
public void Put(long id, [FromBody] CartaCredito value)
{
tbCartaCredito upCarta = new tbCartaCredito();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
upCarta.cd_cartacredito = id;
upCarta.cd_admconsorcio = value.AdmConsorcio;
upCarta.cd_tipoconsorcio = value.TipoConsorcio;
upCarta.cd_vendedor = value.IdVendedor;
upCarta.cd_statuscarta = value.StatusCarta;
upCarta.de_cidade = value.Cidade;
upCarta.de_uf = value.UF;
upCarta.de_indexador = value.Indexador;
upCarta.nu_honorarios = value.Honorarios;
upCarta.nu_qtd_parcelas = value.QtdParcelas;
upCarta.nu_saldocarta = value.SaldoCarta;
upCarta.nu_taxajuros = value.TaxaJuros;
upCarta.nu_valorcredito = value.ValorCredito;
upCarta.nu_valorentrada = value.ValorEntrada;
upCarta.nu_valorparcela = value.ValorParcela;
CRUD.updateCartaCredito(upCarta);
}
public HttpResponseMessage Put(long id, [FromBody] PropostaCarta value)
{
tbPropostaCarta upPropostaCarta = new tbPropostaCarta();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
upPropostaCarta.cd_propostacarta = id;
upPropostaCarta.cd_cartacredito = value.IdCarta;
upPropostaCarta.cd_comprador = value.IdComprador;
upPropostaCarta.cd_vendedor = value.IdVendedor;
upPropostaCarta.cd_statusproposta = value.StatusProposta;
upPropostaCarta.de_mensagemproposta = value.MensagemProposta;
CRUD.updatePropostaCarta(upPropostaCarta);
return(this.Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Login([FromBody] LoginUser value)
{
tbUsers user = new tbUsers();
tbUserPassword password = new tbUserPassword();
bool validate = false;
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
try
{
user.de_username = value.UserName;
user.id_user = CRUD.readIdUser(value.UserName);
if (user.id_user == "")
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, "Usuário ou Senha Incorretos!"));
}
password.id_user = user.id_user;
password.de_password = value.Password;
validate = CRUD.validateUserPassword(password);
if (validate == false)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, "Usuário ou Senha Incorretos!"));
}
value.Id = user.id_user;
value.Nome = user.nm_user;
return(this.Request.CreateResponse(HttpStatusCode.OK, value));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get(long id)
{
tbPropostaCarta readProposta = new tbPropostaCarta();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
PropostaCarta proposta = new PropostaCarta();
try
{
readProposta = CRUD.readPropostaCarta(id);
proposta.Id = readProposta.cd_propostacarta;
proposta.IdCarta = readProposta.cd_cartacredito;
proposta.IdComprador = readProposta.cd_comprador;
proposta.IdVendedor = readProposta.cd_vendedor;
proposta.MensagemProposta = readProposta.de_mensagemproposta;
proposta.StatusProposta = readProposta.cd_statusproposta;
return(this.Request.CreateResponse(HttpStatusCode.OK, proposta));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get(string id)
{
tbComprador readComprador = new tbComprador();
clsCRUDConsorcio CRUD = new clsCRUDConsorcio();
Comprador comprador = new Comprador();
try
{
readComprador = CRUD.readComprador(id);
comprador.Id = readComprador.cd_comprador;
comprador.IdUser = readComprador.id_user;
comprador.CreatedAt = readComprador.dt_create.ToString();
comprador.NegativeFeedback = readComprador.nu_qual_negativa;
comprador.PositiveFeedback = readComprador.nu_qual_positiva;
comprador.Blocked = readComprador.bt_bloqueado;
return(this.Request.CreateResponse(HttpStatusCode.OK, comprador));
}
catch (Exception ex)
{
return(this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}