public void CriarJson()
{
string pathJson = "JSON.txt";
using (var repo = new DBProvaFortesEntities())
{
IList <tbPrestador> prestador = repo.tbPrestador.ToList();
IList <tbTomador> tomador = repo.tbTomador.ToList();
IList <tbNota> nota = repo.tbNota.ToList();
IList <tbItem> item = repo.tbItem.ToList();
foreach (var p in prestador)
{
string x = "";
x = "Prestador {" + Environment.NewLine
+ "\"CNPJ\" : \"" + p.CNPJ + "\"," + Environment.NewLine
+ "\"Nome\" : \"" + p.NOME + "\"," + Environment.NewLine
+ "\"RazaoSocial\" : \"" + p.RAZAOSOCIAL + "\"," + Environment.NewLine
+ "\"Rua\" : \"" + p.RUA + "\"," + Environment.NewLine
+ "\"Numero\" : \"" + p.NUMERO + "\"," + Environment.NewLine
+ "\"Bairro\" : \"" + p.BAIRRO + "\"," + Environment.NewLine
+ "\"UF\": \"" + p.UF + "\"," + Environment.NewLine
+ "\"CEP\" : \"" + p.CEP + "\"," + Environment.NewLine
+ "\"Telefone\" : \"" + p.TELEFONE + "\"," + Environment.NewLine + "}";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var t in tomador)
{
string x = "";
x = "Tomador {" + Environment.NewLine
+ "\"CNPJ\" : \"" + t.CNPJ + "\"," + Environment.NewLine
+ "\"Nome\" : \"" + t.NOME + "\"," + Environment.NewLine
+ "\"Rua\" : \"" + t.RUA + "\"," + Environment.NewLine
+ "\"Numero\" : \"" + t.NUMERO + "\"," + Environment.NewLine
+ "\"Bairro\" : \"" + t.BAIRRO + "\"," + Environment.NewLine
+ "\"UF\": \"" + t.UF + "\"," + Environment.NewLine
+ "\"Telefone\" : \"" + t.TELEFONE + "\"," + Environment.NewLine
+ "\"Email\" : \"" + t.EMAIL + "\"," + Environment.NewLine + "}";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var n in nota)
{
string x = "";
x = "Nota {" + Environment.NewLine
+ "\"Numero\" : \"" + n.NUMERO + "\"," + Environment.NewLine
+ "\"Data\" : \"" + n.DATA + "\"," + Environment.NewLine
+ "\"Valor\" : \"" + n.VALOR + "\"," + Environment.NewLine + "}";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var i in item)
{
string x = "";
x = "Item {" + Environment.NewLine
+ "\"Matricula\" : \"" + i.MATRICULA + "\"," + Environment.NewLine
+ "\"Numero\" : \"" + i.NUMERO + "\"," + Environment.NewLine
+ "\"Nome\" : \"" + i.NOME + "\"," + Environment.NewLine
+ "\"Quantidade\" : \"" + i.QUANTIDADE + "\"," + Environment.NewLine
+ "\"Valor\" : \"" + i.VALOR + "\"," + Environment.NewLine + "}";
;
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
}
}
public void CriarXML()
{
string pathJson = "XML.txt";
using (var repo = new DBProvaFortesEntities())
{
IList <tbPrestador> prestador = repo.tbPrestador.ToList();
IList <tbTomador> tomador = repo.tbTomador.ToList();
IList <tbNota> nota = repo.tbNota.ToList();
IList <tbItem> item = repo.tbItem.ToList();
foreach (var p in prestador)
{
string x = "";
x = "<Prestador Id=\"" + p.ID + "\">\"" + Environment.NewLine
+ " <Prestador>" + Environment.NewLine
+ " <CNPJ>" + p.CNPJ + "</CNPJ>" + Environment.NewLine
+ " <Nome>" + p.NOME + "</Nome>" + Environment.NewLine
+ " <RazaoSocial>" + p.RAZAOSOCIAL + "</RazaoSocial>" + Environment.NewLine
+ " <Rua>" + p.RUA + "</Rua>" + Environment.NewLine
+ " <Numero>" + p.NUMERO + "</Numero>" + Environment.NewLine
+ " <Bairro>: " + p.BAIRRO + "</Bairro>: " + Environment.NewLine
+ " <UF>" + p.UF + "</UF>" + Environment.NewLine
+ " <CEP>" + p.CEP + "</CEP>" + Environment.NewLine
+ " <Telefone>" + p.TELEFONE + "</Telefone>" + Environment.NewLine
+ " </Prestador>" + Environment.NewLine
+ "</Prestador>";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var p in tomador)
{
string x = "";
x = "<Tomador Id=\"" + p.ID + "\">\"" + Environment.NewLine
+ " <Tomador>" + Environment.NewLine
+ " <CNPJ>" + p.CNPJ + "</CNPJ>" + Environment.NewLine
+ " <Nome>" + p.NOME + "</Nome>" + Environment.NewLine
+ " <Rua>" + p.RUA + "</Rua>" + Environment.NewLine
+ " <Numero>" + p.NUMERO + "</Numero>" + Environment.NewLine
+ " <Bairro>: " + p.BAIRRO + "</Bairro>: " + Environment.NewLine
+ " <UF>" + p.UF + "</UF>" + Environment.NewLine
+ " <Telefone>" + p.TELEFONE + "</Telefone>" + Environment.NewLine
+ " <Email>" + p.EMAIL + "</Email>" + Environment.NewLine
+ " </Tomador>" + Environment.NewLine
+ "</Tormador>";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var n in nota)
{
string x = "";
x = "<Nota Id=\"" + n.ID + "\">\"" + Environment.NewLine
+ " <Nota>" + Environment.NewLine
+ " <Numero>" + n.NUMERO + "</Numero>" + Environment.NewLine
+ " <Data>" + n.DATA + "</Data>" + Environment.NewLine
+ " <Valor>" + n.VALOR + "</Valor>" + Environment.NewLine
+ " </Nota>" + Environment.NewLine
+ "</Nota>";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
foreach (var i in item)
{
string x = "";
x = "<Item Id=\"" + i.ID + "\">\"" + Environment.NewLine
+ " <Item>" + Environment.NewLine
+ " <Matricula>" + i.MATRICULA + "</Matricula>" + Environment.NewLine
+ " <Numero>" + i.NUMERO + "</Numero>" + Environment.NewLine
+ " <Nome>" + i.NOME + "</Nome>" + Environment.NewLine
+ " <Quantidade>" + i.QUANTIDADE + "</Quantidade>" + Environment.NewLine
+ " <Valor>" + i.VALOR + "</Valor>" + Environment.NewLine
+ " </Item>" + Environment.NewLine
+ "</Item>";
using (StreamWriter sw = File.AppendText(pathJson))
{
sw.WriteLine(x);
}
}
}
}