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));
}
}
// GET: CartaCreditoMVC/Details/5
public ActionResult Details(long id)
{
HttpWebRequest request;
HttpWebResponse response;
StreamReader sr;
clsJSONFormatter formatter = new clsJSONFormatter();
CartaCredito carta = new CartaCredito();
try
{
request = (HttpWebRequest)WebRequest.Create(String.Concat(ConfigurationSettings.AppSettings["URLCarta"], "/", id));
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "GET";
request.KeepAlive = false;
response = (HttpWebResponse)request.GetResponse();
sr = new StreamReader(response.GetResponseStream());
carta = (CartaCredito)formatter.JSONtoClass(sr.ReadToEnd(), new CartaCredito());
carta.AdmConsorcios = ReadAdmConsorcio();
carta.TipoConsorcios = ReadTipoConsorcio();
carta.StatusCartas = ReadStatusCarta();
return(View(carta));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(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));
}
}
public ActionResult InfoPagamento()
{
var carta = Components.DataLayer.GetCartaCredito(SessionContext.GetUserID());
if (carta == null)
{
carta = new CartaCredito();
}
return(View(carta));
}
public ActionResult Create([Bind(Include = "AdmConsorcio,TipoConsorcio,Cidade,UF,ValorCredito,ValorEntrada,QtdParcelas,ValorParcela,SaldoCarta,Indexador,Honorarios,TaxaJuros")] CartaCredito cartaCredito)
{
if (ModelState.IsValid)
{
InserirCarta(cartaCredito);
return(RedirectToAction("Index", "CartaCreditoMVC", new { id = Session["LoginUser"].ToString() }));
}
ViewData["AdmConsorcio"] = ReadAdmConsorcio();
ViewData["TipoConsorcio"] = ReadTipoConsorcio();
return(View());
}
public ActionResult SalvaInfoPagamento(FormCollection form)
{
var carta = new CartaCredito
{
Numero = form["cc_num"],
Scadenza = form["cc_scadenza"],
Proprietario = form["cc_proprietario"],
CVV = form["cc_cvv"],
};
Components.DataLayer.InsertCartaCredito(carta, SessionContext.GetUserID());
return(RedirectToAction("InfoPagamento"));
}
public int InsertCartaCredito(CartaCredito cc, int userid)
{
string ccc = Convert.ToBase64String(Crypto.Encrypt(cc.ToCSV()));
SqlConnection conn = new SqlConnection(conn_string);
conn.Open();
SqlCommand cmd1 = new SqlCommand("InsertCartaCredito", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@cc", ccc);
cmd1.Parameters.AddWithValue("@uid", userid);
int a = cmd1.ExecuteNonQuery();
conn.Close();
return(a);
}
private void InserirCarta(CartaCredito cartaCredito)
{
HttpWebRequest request;
HttpWebResponse response;
StreamWriter sw;
clsJSONFormatter formatter = new clsJSONFormatter();
Vendedor vendedor = new Vendedor();
string strJSON = "";
try
{
vendedor = ReadVendedor();
cartaCredito.IdVendedor = vendedor.Id;
cartaCredito.StatusCarta = (int)CartaCredito.enStatusCarta.Em_Analise;
request = (HttpWebRequest)WebRequest.Create(ConfigurationSettings.AppSettings["URLCarta"]);
strJSON = formatter.ClasstoJSON(cartaCredito);
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "POST";
request.KeepAlive = false;
sw = new StreamWriter(request.GetRequestStream());
sw.Write(strJSON);
sw.Flush();
response = (HttpWebResponse)request.GetResponse();
request.Abort();
response.Close();
response.Dispose();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// GET: PropostaCartaMVC/Create
public ActionResult Create(long id)
{
HttpWebRequest request;
HttpWebResponse response;
StreamReader sr;
clsJSONFormatter formatter = new clsJSONFormatter();
CartaCredito carta = new CartaCredito();
PropostaCarta proposta = new PropostaCarta();
try
{
request = (HttpWebRequest)WebRequest.Create(String.Concat(ConfigurationSettings.AppSettings["URLCarta"], "/", id));
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "GET";
request.KeepAlive = false;
response = (HttpWebResponse)request.GetResponse();
sr = new StreamReader(response.GetResponseStream());
carta = (CartaCredito)formatter.JSONtoClass(sr.ReadToEnd(), new CartaCredito());
proposta.IdCarta = carta.Id;
proposta.IdVendedor = carta.IdVendedor;
ViewData["carta-entrada"] = carta.ValorEntrada;
ViewData["carta-qtdparcela"] = carta.QtdParcelas;
ViewData["carta-vlrparcela"] = carta.ValorParcela;
ViewData["carta-taxajuros"] = carta.TaxaJuros;
ViewData["carta-indexador"] = carta.Indexador;
return(View(proposta));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(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 CartaCredito GetCartaCredito(int userid)
{
SqlConnection conn = new SqlConnection(conn_string);
conn.Open();
SqlCommand cmd1 = new SqlCommand("GetCartaCredito", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@uid", userid);
string s = (string)cmd1.ExecuteScalar();
conn.Close();
if (s == null)
{
return(null);
}
else
{
return(CartaCredito.FromCSV(Crypto.Decrypt(Convert.FromBase64String(s))));
}
}
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 ActionResult Edit([Bind(Include = "Id,IdVendedor,AdmConsorcio,TipoConsorcio,StatusCarta,Cidade,UF,ValorCredito,ValorEntrada,QtdParcelas,ValorParcela,SaldoCarta,Indexador,Honorarios,TaxaJuros")] CartaCredito cartaCredito)
{
HttpWebRequest request;
HttpWebResponse response;
StreamReader sr;
StreamWriter sw;
clsJSONFormatter formatter = new clsJSONFormatter();
Vendedor vendedor = new Vendedor();
string strJSON = "";
if (ModelState.IsValid)
{
request = (HttpWebRequest)WebRequest.Create(String.Concat(ConfigurationSettings.AppSettings["URLCarta"], "/", cartaCredito.Id));
strJSON = formatter.ClasstoJSON(cartaCredito);
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "PUT";
request.KeepAlive = false;
sw = new StreamWriter(request.GetRequestStream());
sw.Write(strJSON);
sw.Flush();
response = (HttpWebResponse)request.GetResponse();
return(RedirectToAction("Index"));
}
cartaCredito.AdmConsorcios = ReadAdmConsorcio();
cartaCredito.TipoConsorcios = ReadTipoConsorcio();
cartaCredito.StatusCartas = ReadStatusCarta();
return(View(cartaCredito));
}
public ActionResult CartaStatusTransit(long idCarta, int status)
{
HttpWebRequest request;
HttpWebResponse response;
StreamReader sr;
StreamWriter sw;
string strJSON = "";
clsJSONFormatter formatter = new clsJSONFormatter();
CartaCredito carta = new CartaCredito();
try
{
if (ModelState.IsValid)
{
request = (HttpWebRequest)WebRequest.Create(String.Concat(ConfigurationSettings.AppSettings["URLCarta"], "/", idCarta));
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "GET";
request.KeepAlive = false;
response = (HttpWebResponse)request.GetResponse();
sr = new StreamReader(response.GetResponseStream());
carta = (CartaCredito)formatter.JSONtoClass(sr.ReadToEnd(), new CartaCredito());
switch (status)
{
case (int)CartaCredito.enStatusCarta.Publicada:
if (carta.StatusCarta != (int)CartaCredito.enStatusCarta.Em_Analise)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Carta não pode ser Publicada!"));
}
break;
case (int)CartaCredito.enStatusCarta.Reprovada:
if (carta.StatusCarta != (int)CartaCredito.enStatusCarta.Em_Analise)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Carta não pode ser Reprovada!"));
}
break;
}
carta.StatusCarta = status;
request.Abort();
response.Close();
response.Dispose();
sr.Close();
sr.Dispose();
request = (HttpWebRequest)WebRequest.Create(String.Concat(ConfigurationSettings.AppSettings["URLCarta"], "/", idCarta));
request.ContentType = "application/json";
request.Accept = "application/json";
request.Method = "PUT";
request.KeepAlive = false;
strJSON = formatter.ClasstoJSON(carta);
sw = new StreamWriter(request.GetRequestStream());
sw.Write(strJSON);
sw.Flush();
response = (HttpWebResponse)request.GetResponse();
request.Abort();
response.Close();
response.Dispose();
sw.Close();
sw.Dispose();
}
return(RedirectToAction("CartasCredito", "Admin", new { area = "" }));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message));
}
}
public ActionResult Ordina(Models.Ordine ordine)
{
try
{
if (ordine.Carta.Numero == ordine.Carta.NumeroAst)
{
ordine.Carta.Numero = Crypto.Decrypt(Convert.FromBase64String(ordine.NumOrig));
}
var dal = Components.DataLayer;
int a = CartaCredito.IsValid(ordine.Carta);
if (a == 0)
{
if (ordine.SalvaCarta)
{
dal.InsertCartaCredito(ordine.Carta, SessionContext.GetUserID());
}
var carrello = dal.GetCarrello(SessionContext.GetUserID());
int b = dal.CreaOrdine(SessionContext.GetUserID());
if (b == 0)
{
ViewData.Add("Items", carrello);
return(View(new Models.Ordine {
StatoOrdine = Models.Ordine.Stato.Validato
}));
}
else
{
return(View(new Models.Ordine {
Errore = "Errore del server, riprova più tardi. Codice errore: " + b, StatoOrdine = Models.Ordine.Stato.Errore
}));
}
}
else
{
switch (a)
{
case -1:
ordine.Errore = "Numero errato";
break;
case -2:
ordine.Errore = "Proprietario non valido";
break;
case -3:
ordine.Errore = "Scadenza errata";
break;
case -4:
ordine.Errore = "CVV errato";
break;
default:
break;
}
ordine.NumOrig = Convert.ToBase64String(Crypto.Encrypt(ordine.Carta.Numero));
ordine.Carta.Numero = ordine.Carta.NumeroAst;
return(View(ordine));
}
}
catch (Exception)
{
return(View(new Models.Ordine {
Errore = "Errore del server, riprova più tardi", StatoOrdine = Models.Ordine.Stato.Errore
}));
}
}
public int InsertCartaCredito(CartaCredito cc, int userid)
{
throw new System.NotImplementedException();
}
