/// <summary>
/// Metodo responsavel por salvar o usuario
/// </summary>
/// <param name="Usuario"></param>
/// <returns></returns>
public Usuario SalvaUsuario(Usuario usuario)
{
db.Usuarios.Add(usuario);
db.SaveChanges();
return(usuario);
}
/// <summary>
/// Metodo responsavel por salvar o orgao
/// </summary>
/// <param name="Orgao"></param>
/// <returns></returns>
public Orgao SalvaOrgao(Orgao orgao)
{
db.Orgaos.Add(orgao);
db.SaveChanges();
return(orgao);
}
/// <summary>
/// Metodo responsavel por alterar o orgao
/// </summary>
/// <param name="orgao"></param>
public OrdemCompra AlteraOrdemCompra(OrdemCompra ordemCompra)
{
db.Entry<OrdemCompra>(ordemCompra).State = EntityState.Modified;
db.SaveChanges();
return ordemCompra;
}
static void Main(string[] args)
{
//DateTime StartDate = new DateTime(2018, 6, 1);
//DateTime EndDate = new DateTime(2018, 6, 16);
SampasoftDBEntities db = new SampasoftDBEntities();
//foreach (DateTime dttime in EachDay(StartDate, EndDate))
//{
//var txtData = ((dttime.Day < 10 ? "0" + dttime.Day.ToString() : dttime.Day.ToString()) + (dttime.Month < 10 ? "0" + dttime.Month.ToString() : dttime.Month.ToString()) + dttime.Year.ToString());
//Console.Write("Data: "+ txtData);
var txtData = "01012018";
var webRequest = WebRequest.Create("https://www.bec.sp.gov.br/BEC_API/API/convite_encerrado/OC_encerrada/" + txtData) as HttpWebRequest;
if (webRequest == null)
{
return;
}
webRequest.ContentType = "application/json";
webRequest.UserAgent = "Nothing";
using (var s = webRequest.GetResponse().GetResponseStream())
{
using (var sr = new StreamReader(s))
{
var ocEncerradasAsJson = sr.ReadToEnd();
var ocs = JsonConvert.DeserializeObject <IList <OCEncerrada> >(ocEncerradasAsJson);
foreach (var xOC in ocs.Distinct())
{
if (db != null)
{
Console.WriteLine("OC: " + xOC.OC);
try
{
if (db.OCEncerradas.FirstOrDefault(x => x.OC == xOC.OC) == null)
{
db.OCEncerradas.Add(xOC);
db.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine("ERRO: " + e.ToString());
//Console.ReadLine();
}
}
}
}
}
}
