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));
}
}
/// <summary>
/// NÃO IMPLEMENTADO - COLOCAR ELE COMO PUBLICO DEPOIS.
/// </summary>
/// <param name="o"></param>
/// <param name="n"></param>
public void GravaOrdem(Order o, NSAADMEntities n)
{
try
{
ML_Order Ordem;
ConverterObjetoMLparaEF cf = new ConverterObjetoMLparaEF();
Ordem = (from p in n.ML_Order where p.id == o.id select p).FirstOrDefault();
if (Ordem == null)
{
Ordem = cf.ConverteOrdem(o, n);
n.ML_Order.AddObject(Ordem);
}
else
{
cf.AtualizaOrdem(Ordem, o, n);
}
n.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Erro na rotina GravaOrdem.", ex);
}
}
public void GravaPergunta(Question q, NSAADMEntities n)
{
try
{
var i = (from p in n.ML_Question where p.id_question == q.id select p).First();
i.status = q.status;
if (q.from != null)
{
i.answered_questions = q.from.answered_questions;
}
if (q.answer != null)
{
i.Answer_date_created = q.answer.date_created;
i.Answer_status = q.answer.status;
i.Answer_text = q.answer.text;
}
}
catch (Exception)
{
ML_Question mlQ = conv.ConverteQuestion(q);
n.ML_Question.AddObject(mlQ);
}
n.SaveChanges();
}
public void GravaItem(ML_Item item, NSAADMEntities n)
{
ML_Item it = new ML_Item();
try
{
it = (from p in n.ML_Item where p.id == item.id select p).First();
}
catch (InvalidOperationException)
{
it.id_org = item.id_org;
it.id = item.id;
it.title = item.title;
it.variation_id = item.variation_id;
n.ML_Item.AddObject(it);
n.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Erro na rotina GravaItem", ex);
}
}
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)
{
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();
}
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);
}
}
/// <summary>
/// Recebe um ID e Retona um ML_Order cadastrado no EF
/// </summary>
/// <param name="u">ID do usuário usado na pesquisa</param>
/// <param name="n">Objeto NSAADMEntities onde vai ser pesquisado</param>
/// <returns>Retorna o objeto ML_Usuario casdastrado no EF</returns>
public ML_Usuario RetonarUsuario(decimal ID, NSAADMEntities n)
{
try
{
ML_Usuario m;
m = (from p in n.ML_Usuario where p.id == ID select p).FirstOrDefault();
return m;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetonarUsuario.", ex);
}
}
/// <summary>
/// Recebe um ID e Retona um ML_Item cadastrado no EF
/// </summary>
/// <param name="u">ID do item usado na pesquisa</param>
/// <param name="n">Objeto NSAADMEntities onde vai ser pesquisado</param>
/// <returns>Retorna o objeto ML_Item casdastrado no EF</returns>
public ML_Item RetonarItem(string ID, NSAADMEntities n)
{
try
{
ML_Item m;
m = (from p in n.ML_Item where p.id == ID select p).FirstOrDefault();
return m;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetonarItem.", ex);
}
}
public ML_Item RetornaProduto(string id, NSAADMEntities n)
{
try
{
return (from p in n.ML_Item where p.id == id select p).First();
}
catch (Exception)
{
ML_Item ml = new ML_Item();
ml.title = "Sem venda";
return ml;
}
}
/// <summary>
/// Recebe uma Order e Retona um ML_Order cadastrado no EF
/// </summary>
/// <param name="o">Objeto Order usado na pesquisa</param>
/// <param name="n">Objeto NSAADMEntities onde vai ser pesquisado</param>
/// <returns>Retorna o objeto ML_Order casdastrado no EF</returns>
public ML_Order RetonarOrder(Order o, NSAADMEntities n)
{
try
{
ML_Order mo = (from p in n.ML_Order where p.id == o.id select p).First();
return mo;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetonarOrder.", ex);
}
}
public Object RecuperaEntity(Entities en)
{
Object EF;
if (en == Entities.MercadoLivre)
{
EF = new NSAADMEntities(stringdeconexao());
return (NSAADMEntities)EF;
}
else if (en == Entities.Bot)
{
EF = new BotWoWEntities(stringdeconexao());
return (BotWoWEntities)EF;
}
else
{
throw new Exception("Enumerador inválido");
}
}
public void AtualizaOrdem(ML_Order o, Order oML, NSAADMEntities n1)
{
try
{
if (o.ML_FeedbackBuyer != null)
{
o.ML_FeedbackBuyer.Load();
}
if (o.ML_FeedbackSeller != null)
{
o.ML_FeedbackSeller.Load();
}
if (o.ML_Payment != null)
{
o.ML_Payment.Load();
}
if (oML.status != null)
{
o.status = oML.status;
}
if (oML.status_detail != null)
{
o.status_detail = oML.status_detail.description;
}
AtualizaFeedBackBuyer(o, oML, n1);
AtualizaFeedBackSeller(o, oML, n1);
AtualizaShipping(o, oML, n1);
ML_Payment p = o.ML_Payment.FirstOrDefault();
if (p != null) AtualizaPagamento(p, oML.payments.First(), n1);
}
catch (Exception ex)
{
throw new Exception("Erro na rotina AtualizaOrdem(ML_Order o, Order oML)", ex);
}
}
public void GravaPergunta(ML_Question q, NSAADMEntities n)
{
try
{
var i = (from p in n.ML_Question where p.id == q.id select p).First();
i.Answer_date_created = q.Answer_date_created;
i.Answer_status = q.Answer_status;
i.Answer_text = q.Answer_text;
i.answered_questions = q.answered_questions;
n.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Erro na rotina GravaPergunta(ML_Question q, NSAADMEntities n)", ex);
}
}
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 List<CallBackML> RetornaCallBacks(TipoRetonaCallBacks tcallback, NSAADMEntities n)
{
try{
List<CallBackML> lCall = new List<CallBackML>();
if (tcallback == TipoRetonaCallBacks.PERGUNTAS)
{
lCall = (from p in n.CallBackMLs where p.topic == "questions" select p).ToList();
}
else
{
throw new Exception("Tipo de Retorno CallBack não implementado ou inválido.");
}
return lCall;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetornaCallBacks.", ex);
}
}
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 AtualizaDados(ML_Question q, NSAADMEntities n)
//{
// try
// {
// var i = (from p in n.ML_Question where p.id_question == q.id_question select p).First();
// i.status = q.status;
// i.Answer_date_created = q.Answer_date_created;
// i.Answer_status = q.Answer_status;
// i.Answer_text = q.Answer_text;
// i.answered_questions = q.answered_questions;
// i.date_created = q.date_created;
// i.id_from = q.id_from;
// n.SaveChanges();
// }
// catch (Exception ex)
// {
// throw new Exception("Erro na rotina AtualizaDados", ex);
// }
//}
public ML_Question RetornaPergunta(decimal idQuestion, NSAADMEntities n)
{
ML_Question q;
try
{
q = (from p in n.ML_Question where p.id_question == idQuestion select p).First();
return q;
}
catch (InvalidOperationException iex)
{
throw new Exception("Pergunta não encontrada.", iex);
}
catch (Exception ex)
{
throw new Exception(String.Format("Erro na rotina RetornaPergunta. {0} idQuestion: {1} {0}", Environment.NewLine, idQuestion), ex);
}
}
public List<ML_Question> RetonaPerguntas(decimal IDUsuario, NSAADMEntities n)
{
try
{
List<ML_Question> q = (from p in n.ML_Question where p.id_from == IDUsuario select p).ToList();
return q;
}
catch (InvalidOperationException)
{
return new List<ML_Question>();
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetonaPerguntas.", ex);
}
}
public ML_Shipping ConverteShipping(Order o, NSAADMEntities n)
{
ControlaEndereco ControlEnd = new ControlaEndereco();
if (o.shipping.id != null)
{
//IMPLEMENTAR ENDERECO
ML_Shipping s = new ML_Shipping();
s.cost = o.shipping.cost;
s.currency_id = o.shipping.currency_id;
if (o.shipping.date_created != null)
{
s.date_created = Convert.ToDateTime(o.shipping.date_created);
}
s.id = Convert.ToDecimal(o.shipping.id);
s.shipment_type = o.shipping.shipment_type;
s.status = o.shipping.status;
if (o.shipping.receiver_address != null && o.shipping.receiver_address.id != null)
{
ML_ReceiverAddress rc;
decimal d = Convert.ToDecimal(o.shipping.receiver_address.id);
rc = (from p in n.ML_ReceiverAddress where p.ID == d select p).FirstOrDefault();
if (rc == null)
{
rc = new ML_ReceiverAddress();
rc.address_line = o.shipping.receiver_address.address_line;
rc.comment = o.shipping.receiver_address.comment;
rc.ID = Convert.ToDecimal(o.shipping.receiver_address.id.ToString());
//rc.latitude = o.shipping.receiver_address.latitude.ToString(); Todos vem Null
//rc.longitude = o.shipping.receiver_address.longitude.ToString();
rc.zip_code = o.shipping.receiver_address.zip_code;
rc.ML_State = ControlEnd.RetonarStado(o.shipping.receiver_address.state.id, n);
if (rc.ML_State == null && o.shipping.receiver_address.state.id != null)
{
rc.ML_State = ConverteState(o.shipping.receiver_address.state);
}
rc.ML_City = ControlEnd.RetonarCidade(o.shipping.receiver_address.city.id, n);
if (rc.ML_City == null && o.shipping.receiver_address.city.id != null)
{
rc.ML_City = ConverteCity(o.shipping.receiver_address.city);
}
rc.ML_Country = ControlEnd.RetonarPais(o.shipping.receiver_address.country.id, n);
if (rc.ML_Country == null && o.shipping.receiver_address.country.id != null)
{
rc.ML_Country = ConverteCountry(o.shipping.receiver_address.country);
}
}
s.ML_ReceiverAddress = rc;
}
return s;
}
else
{
return null;
}
}
private void AtualizaPagamento(ML_Payment p, Payment py, NSAADMEntities n)
{
try
{
p.currency_id = py.currency_id;
p.date_created = py.date_created;
p.date_last_updated = py.date_last_updated;
p.status = py.status;
p.transaction_amount = py.transaction_amount;
if (p.id == 0) p.id = py.id;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina AtualziaPagamento.",ex);
}
}
/// <summary>
/// Inclui ou Altera uma ML_Order no banco de dados.
/// </summary>
/// <param name="o">Objeto ML_Order que vai ser inserido ou alterado</param>
/// <param name="n">Objeto NSAADMEntities que vai ser usado para fazer a inclusão ou alteração.</param>
public void GravaOrdem(ML_Order o, NSAADMEntities n)
{
}
/// <summary>
/// Retorna todas as ordens baseadas no filtro informado.
/// </summary>
/// <param name="to">TipoRetornaOrdens, informa quais as ordens devem ser retornadas</param>
/// <param name="n">Objeto NSAADMEntities usado para selecionar as ordens</param>
/// <returns>Retorna um List<ML_Order> com todas as ordens selecionadas</returns>
public List<ML_Order> RetornaOrdens(TipoRetonaOrdens to, NSAADMEntities n)
{
try
{
List<ML_Order> mo = new List<ML_Order>();
if (to == TipoRetonaOrdens.ABERTASPAGAS)
{
mo = (from p in n.ML_Order where p.status == "paid" select p).ToList();
}
else
{
throw new Exception("Tipo de Retorna Order não implementado ou inválido.");
}
return mo;
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetornaOrdens.", ex);
}
}
public Posts(Meli meli, NSAADMEntities nsaadm)
{
m = meli;
n = nsaadm;
}
public List<ML_Question> RetonaPerguntas(TipoRetonaPerguntas t, NSAADMEntities n)
{
try
{
if (t == TipoRetonaPerguntas.NAORESPONDIDA)
{
List<ML_Question> q = (from p in n.ML_Question where p.status == PERGUNTA_NAO_RESPONDIDA select p).ToList();
return q;
}
else
{
throw new Exception("Tipo de Retona Pergunta não implementado ou inválido.");
}
}
catch (InvalidOperationException)
{
return new List<ML_Question>();
}
catch (Exception ex)
{
throw new Exception("Erro na rotina RetonaPerguntas.", ex);
}
}
private void AtualizaFeedBackSeller(ML_Order o, Order oML, NSAADMEntities n)
{
try
{
if (o.ML_FeedbackSeller.Count > 0)
{
if (RetornaFeedBackSeller(oML) != null)
{
ML_FeedbackSeller MLs = o.ML_FeedbackSeller.First();
Sale s = RetornaFeedBackSeller(oML);
MLs.date_created = s.date_created;
MLs.fulfilled = s.fulfilled.ToString();
MLs.rating = s.rating;
o.ML_FeedbackSeller.Add(MLs);
}
}
else
{
if (RetornaFeedBackSeller(oML) != null)
{
ML_FeedbackSeller MLs1 = new ML_FeedbackSeller();
Sale s1 = RetornaFeedBackSeller(oML);
MLs1.date_created = s1.date_created;
MLs1.fulfilled = s1.fulfilled.ToString();
MLs1.rating = s1.rating;
MLs1.id_order = o.id;
o.ML_FeedbackSeller.Add(MLs1);
}
}
}
catch (Exception ex)
{
throw new Exception("Erro na rotina AtualizaFeedBackSeller", ex);
}
}
private void AtualizaFeedBackBuyer(ML_Order o, Order oML, NSAADMEntities n)
{
try
{
if (o.ML_FeedbackBuyer.Count > 0)
{
if (RetornaFeedBackPurchase(oML) != null)
{
ML_FeedbackBuyer b = o.ML_FeedbackBuyer.First();
Purchase p = RetornaFeedBackPurchase(oML);
b.date_created = p.date_created;
b.fulfilled = p.fulfilled.ToString();
b.rating = p.rating;
}
}
else
{
if (RetornaFeedBackPurchase(oML) != null)
{
ML_FeedbackBuyer b1 = new ML_FeedbackBuyer();
Purchase p1 = RetornaFeedBackPurchase(oML);
b1.date_created = p1.date_created;
b1.fulfilled = p1.fulfilled.ToString();
b1.rating = p1.rating;
b1.id_order = o.id;
n.ML_FeedbackBuyer.AddObject(b1);
o.ML_FeedbackBuyer.Add(b1);
}
}
}
catch (Exception ex)
{
throw new Exception("Erro na rotina AtualizaFeedBackBuyer.", ex);
}
}
private void AtualizaShipping(ML_Order o, Order oML, NSAADMEntities n)
{
try
{
if (oML.shipping.id != null)
{
o.ML_Shipping.Load();
ML_Shipping ship;
ship = o.ML_Shipping.FirstOrDefault();
if (ship == null)
{
ship = ConverteShipping(oML, n);
o.ML_Shipping.Add(ship);
}
else
{
ship.status = oML.shipping.status;
ship.shipment_type = oML.shipping.shipment_type;
ship.currency_id = oML.shipping.currency_id;
ship.cost = oML.shipping.cost;
}
}
}
catch (Exception ex)
{
throw new Exception(String.Format("Erro na rotina AtualizaShipping. {0} oML.id = {1} {0}", Environment.NewLine, oML.id), ex);
}
}