protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
var um = (from ito in n.ML_ItemOrganizacao
join it in n.ML_Item on ito.id equals it.id_org
join ordit in n.ML_OrderItem on it.id equals ordit.id_item
join ord in n.ML_Order on ordit.id_order equals ord.id
join fd in n.ML_FeedbackSeller on ord.id equals fd.id_order
where fd.id_order == ord.id
&& fd.rating == "positive"
select new { DescrItem = ito.Descricao, ValorOrdem = ord.total_amount });
var dois = (from p in um group p by p.DescrItem into umg select new { ItemDesc = umg.Key, Qtd = umg.Count(), TotalBruto = umg.Sum(x => x.ValorOrdem), TotalLiquido = (umg.Sum(x1 => x1.ValorOrdem) * COMISSAO_ML) });
GridView1.DataSource = dois;
GridView1.DataBind();
Label1.Text = String.Format("Total de valor recebido: {0}",dois.Sum(x => x.TotalLiquido));
}
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
ConstruirEF cf = new ConstruirEF();
NSAADMEntities n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
try
{
var u = (from p in n.UsuarioAdms where p.nome == Login1.UserName && p.senha == Login1.Password select p).First();
e.Authenticated = true;
FormsAuthentication.RedirectFromLoginPage(Login1.UserName, false);
}
catch (Exception ex)
{
throw new Exception("Erro no login: Login1_Authenticate", ex);
}
//if ((Login1.UserName == "admin") && (Login1.Password == "123"))
//{
// e.Authenticated = true;
// FormsAuthentication.RedirectFromLoginPage(Login1.UserName, false);
//}
//else
//{
// e.Authenticated = false;
//}
}
public void LimpaCallBack()
{
ConstruirEF cf = new ConstruirEF();
NSAADMEntities n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
List<CallBackML> x = (from p in n.CallBackMLs where p.topic == "questions" select p).ToList();
foreach (CallBackML item in x)
{
try
{
decimal cod;
cod = Convert.ToDecimal(item.resource.Replace("/questions/",""));
var b = (from p in n.ML_Question where p.id_question == cod select p ).First();
n.CallBackMLs.DeleteObject(item);
}
catch (Exception)
{
}
n.SaveChanges();
}
}
public bool VerificaUser(JToken t)
{
NSAADMEntities n;
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
try
{
decimal d = (decimal)t["id"];
ML_Usuario pa = (from p in n.ML_Usuario where p.id == d select p).First();
return true;
}
catch (InvalidOperationException)
{
if (t["nickname"].ToString() == "")
{
return true;
}
else
{
return false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Meli m;
string pg;
string codigo = Request.QueryString["code"];
if ((string)Session["pagina"] != null)
{
pg = (string)Session["pagina"];
}
else
{
pg = "InicioML.aspx";
}
if (Session["M"] == null)
{
//m = new Meli(5971480328026573, "HvQavElFhrbqlGCaTMWIrtQklsqnwlIM");
m = new Meli(AplicacaoML.RetornaIDAplicacaoML(), AplicacaoML.RetornaKeyAplicacaoML());
}
else
{
m = (Meli)Session["M"];
}
string redirectUrl = AplicacaoML.RetornaURLLoginAplicacaoML();// ServidorWeb.Properties.Settings.Default.URL_Login;
m.Authorize(codigo, redirectUrl);
Session["M"] = m;
NSAADMEntities n;
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
DadosML d;
d = (from p in n.DadosMLs where p.id == "Meli" select p).First();
d.ClientSecret = AplicacaoML.RetornaKeyAplicacaoML(); // m.ClientSecret;
d.ClientId = m.ClientId.ToString();
d.AccessToken = m.AccessToken;
d.RefreshToken = m.RefreshToken;
n.SaveChanges();
Response.Redirect(pg, false);
}
catch (Exception ex)
{
throw new Exception ("Erro no load do login.aspx", ex) ;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
int cont = 0;
ConstruirEF cef = new ConstruirEF();
NSAADMEntities n = (NSAADMEntities)cef.RecuperaEntity(Entities.MercadoLivre);
ConverterObjetoMLparaEF cf = new ConverterObjetoMLparaEF();
Usuario u = cm.RetornaUsuario();
ConverterObjetoMLparaEF c = new ConverterObjetoMLparaEF();
ListOrder o;
ML_Order Ordem;
ConverteVendas cv = new ConverteVendas();
GerenciarVendas gv = new GerenciarVendas();
NSAADM_HMLEntities ent = new NSAADM_HMLEntities();
do
{
o = cm.RetornarOrdens(u, cont);
cont = o.results.Count + cont;
foreach (Order or in o.results)
{
Ordem = (from p in n.ML_Order where p.id == or.id select p).FirstOrDefault();
if (Ordem == null)
{
Ordem = cf.ConverteOrdem(or, n);
n.ML_Order.AddObject(Ordem);
gv.IncluirVenda(cv.ConverteMLVendaEmVenda(Ordem, ent), ent);
}
else
{
cf.AtualizaOrdem(Ordem, or, n);
gv.IncluirVenda(cv.ConverteMLVendaEmVenda(Ordem, ent), ent);
}
n.SaveChanges();
}
} while (o.results.Count == 50);
}
catch (Exception ex)
{
throw new Exception("Erro na rotina Button1_Click",ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
Decimal codigo = Convert.ToDecimal(Request.QueryString["code"]);
var x = (from p in n.MP_Payments where p.id == codigo select p);
GridView1.DataSource = x;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
NSAADMEntities n;
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
//*****************************************
Request.InputStream.Position = 0;
System.IO.StreamReader str = new System.IO.StreamReader(Request.InputStream);
CallBackTemp c = new CallBackTemp();
c = JsonConvert.DeserializeObject<CallBackTemp>(str.ReadToEnd());
//*****************************************
try
{
CallBackML teste = (from p in n.CallBackMLs where p.resource == c.resource select p).First();
}
catch (Exception)
{
CallBackML call = new CallBackML();
call.received = c.received;
call.resource = c.resource;
call.sent = c.sent;
call.topic = c.topic;
call.userID = c.user_id;
n.CallBackMLs.AddObject(call);
n.SaveChanges();
if (c.topic == "questions")
{
ControlaMeli cm = new ControlaMeli();
ControlaPerguntas cp = new ControlaPerguntas();
cp.GravaPergunta(cm.RetonarQuestion(c.resource), cm.n);
}
if (c.topic == "orders")
{
ControlaMeli cm = new ControlaMeli();
ControlaOrdens co = new ControlaOrdens();
ConverterObjetoMLparaEF conv = new ConverterObjetoMLparaEF();
co.GravaOrdem(cm.RetornaOrder(c.resource),cm.n);
}
}
}
public ControlaMeli()
{
try
{
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
d = (from p in n.DadosMLs where p.id == "Meli" select p).First();
m = new Meli(Convert.ToInt64(d.ClientId), d.ClientSecret, d.AccessToken, d.RefreshToken);
}
catch (Exception ex)
{
throw new Exception(String.Format("Erro no New do ControlaMeli"), ex);
}
}
public bool VerificaPay(JToken t)
{
NSAADMEntities n;
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
try
{
decimal d = (decimal)t["id"];
MP_Payments pa = (from p in n.MP_Payments where p.id == d select p).First();
return true;
}
catch (InvalidOperationException)
{
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
var x = (from p in n.ML_ItemOrganizacao select p);
DropDownList1.Items.Clear();
Label1.Text = "";
Label2.Text = "";
Label3.Text = "";
DropDownList1.DataSource = x;
DropDownList1.DataTextField = "descricao";
DropDownList1.DataValueField = "id";
DropDownList1.DataBind();
}
}
public ML_Order ConverteOrdem(Order o, NSAADMEntities n)
{
try
{
ControlaUsuario ControlaUsu = new ControlaUsuario();
ControlaItem ControlaIt = new ControlaItem();
ControlaEndereco ControlEnd = new ControlaEndereco();
ConstruirEF cf = new ConstruirEF();
ML_Order ord = new ML_Order();
//CONVERTENDO COMPRADOR E VENDEDOR
ML_Usuario buy = ControlaUsu.RetonarUsuario(o.buyer.id, n);
if (buy == null)
{
buy = ConverteUsuario(o.buyer);
}
ML_Usuario sel = ControlaUsu.RetonarUsuario(o.seller.id, n);
if (sel == null)
{
sel = ConverteUsuario(o.seller);
}
ord.ML_Usuario = sel;
ord.ML_Usuario1 = buy;
//ITENS DA ORDEM
ML_OrderItem oi;
foreach (OrderItem item in o.order_items)
{
oi = new ML_OrderItem();
oi.currency_id = item.currency_id;
oi.quantity = item.quantity;
oi.unit_price = item.unit_price;
ML_Item mitem = ControlaIt.RetonarItem(o.order_items[0].item.id, n);
if (mitem == null)
{
mitem = ConverteItem(o.order_items[0].item);
}
oi.ML_Item = mitem;
ord.ML_OrderItem.Add(oi);
}
ML_Payment pa;
foreach (Payment p in o.payments)
{
pa = new ML_Payment();
pa.currency_id = p.currency_id;
pa.date_created = p.date_created;
pa.date_last_updated = p.date_last_updated;
pa.status = p.status;
pa.transaction_amount = p.transaction_amount;
pa.id = p.id;
ord.ML_Payment.Add(pa);
}
if (o.feedback != null)
{
if (o.feedback.purchase != null)
{
ML_FeedbackBuyer feeb = new ML_FeedbackBuyer();
feeb.date_created = o.feedback.purchase.date_created;
feeb.fulfilled = o.feedback.purchase.fulfilled.ToString();
feeb.rating = o.feedback.purchase.rating;
feeb.id_order = o.id;
ord.ML_FeedbackBuyer.Add(feeb);
}
if (o.feedback != null)
{
if (o.feedback.sale != null)
{
ML_FeedbackSeller fees = new ML_FeedbackSeller();
fees.date_created = o.feedback.sale.date_created;
fees.fulfilled = o.feedback.sale.fulfilled.ToString();
fees.rating = o.feedback.sale.rating;
fees.id_order = o.id;
ord.ML_FeedbackSeller.Add(fees);
}
}
}
ML_Shipping s = new ML_Shipping();
s = ConverteShipping(o, n);
if (s != null) ord.ML_Shipping.Add(s);
//DADOS DA ORDEM
ord.id = o.id;
ord.currency_id = o.currency_id;
ord.date_closed = o.date_closed;
ord.date_created = o.date_created;
ord.status = o.status;
//ord.status_detail = o.status_detail.description;
ord.total_amount = o.total_amount;
return ord;
}
catch (Exception ex)
{
throw new Exception(string.Format("Erro na rotina de ConverteOrdem. OrdemID: {0}",o.id), ex);
}
}
private void InserirMOvimentos(JObject t)
{
NSAADMEntities n;
ConstruirEF cf = new ConstruirEF();
n = (NSAADMEntities)cf.RecuperaEntity(Entities.MercadoLivre);
decimal temp;
Nullable<DateTime> tempd;
foreach (var item in t)
{
string a = item.ToString();
JToken j = t["response"];
JToken s = j["results"];
foreach (var i in s)
{
JToken b = i["collection"];
if (VerificaPay(b) == false)
{
MP_Payments p = new MP_Payments();
p.id = (decimal)b["id"];
p.last_modified = (DateTime)b["last_modified"];
p.marketplace = (string)b["marketplace"];
p.installments = b["installments"].ToString();
Decimal.TryParse(b["marketplace_fee"].ToString(), out temp);
p.marketplace_fee = temp;
Decimal.TryParse(b["mercadopago_fee"].ToString(), out temp);
p.mercadopago_fee = temp;
Decimal.TryParse(b["net_received_amount"].ToString(), out temp);
p.net_received_amount = temp;
Decimal.TryParse(b["collector_id"].ToString(), out temp);
p.collector_id = temp;
Decimal.TryParse(b["currency_id"].ToString(), out temp);
p.currency_id = temp;
Decimal.TryParse(b["external_reference"].ToString(), out temp);
p.external_reference = temp;
Decimal.TryParse(b["total_paid_amount"].ToString(), out temp);
p.total_paid_amount = temp;
Decimal.TryParse(b["transaction_amount"].ToString(), out temp);
p.transaction_amount = temp;
Decimal.TryParse(b["account_money_amount"].ToString(), out temp);
p.account_money_amount = temp;
Decimal.TryParse(b["shipping_cost"].ToString(), out temp);
p.shipping_cost = temp;
p.operation_type = (string)b["operation_type"];
p.payment_type = (string)b["payment_type"];
p.reason = (string)b["reason"];
p.released = (string)b["released"];
p.site_id = (string)b["site_id"];
p.sponsor_id = (string)b["sponsor_id"];
p.status = (string)b["status"];
p.status_code = (string)b["status_code"];
p.status_detail = (string)b["status_detail"];
tempd = (Nullable<DateTime>)b["date_approved"];
p.date_approved = tempd;
p.date_created = (DateTime)b["date_created"];
tempd = (Nullable<DateTime>)b["money_release_date"];
p.money_release_date = tempd;
//p.money_release_date = (DateTime)b["money_release_date"];
//USUARIO
JToken user = b["payer"];
if (VerificaUser(user) == false)
{
ML_Usuario u = new ML_Usuario();
Decimal.TryParse(user["id"].ToString(), out temp);
u.id = temp;
u.nickname = (string)user["nickname"];
u.first_name = (string)user["first_name"];
u.last_name = (string)user["last_name"];
u.email = (string)user["email"];
JToken phone = user["phone"];
ML_Phone phon = new ML_Phone();
phon.area_code = (string)phone["area_code"];
phon.number = (string)phone["number"];
phon.extension = (string)phone["extension"];
u.ML_Phone.Add(phon);
n.ML_Usuario.AddObject(u);
}
n.AddToMP_Payments(p);
n.SaveChanges();
}
}
}
}
