public static void CreateJsonFile(string filepath, List <NBAPlayer> allNbaPlayer)
{
string JSONresult;
int currIndex = 0;
using (var streamWriter = new StreamWriter(filepath, true))
{
streamWriter.Write('[');
foreach (var item in allNbaPlayer)
{
if (currIndex != allNbaPlayer.Count - 1)
{
JSONresult = JsonConvert.SerializeObject(item);
streamWriter.WriteLine(JSONresult.ToString() + ',');
currIndex++;
}
else
{
JSONresult = JsonConvert.SerializeObject(item);
streamWriter.WriteLine(JSONresult.ToString());
streamWriter.Write(']');
streamWriter.Close();
}
}
}
}
private HttpResponseMessage regVentaToApi(int venta, int suc, int cliente)
{
try
{
using (SqlConnection conn = new SqlConnection(DatabaseConnectionString))
{
SqlCommand cmd1 = new SqlCommand("SELECT idProducto AS ean, Cantidad AS cantidad FROM DETALLEPEDIDO WHERE idPedido=@id");
cmd1.Parameters.AddWithValue("@id", venta);
cmd1.Connection = conn;
conn.Open();
using (var reader = cmd1.ExecuteReader())
{
var r = serial.Serialize(reader);
string JSONresult;
JSONresult = JsonConvert.SerializeObject(r);
string jsonText = JSONresult.Replace("\"", "");
string sqlFormattedDate = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.fff");
JObject ven = new JObject();
ven.Add("idCliente", cliente);
ven.Add("idEmpleado", 0);
ven.Add("idSucursal", suc);
ven.Add("productos", JArray.Parse(JSONresult));
ven.Add("tipoPago", 1);
ven.Add("fecha", sqlFormattedDate);
ven.Add("starts", "00:00:00");
ven.Add("ends", "00:00:00");
ven.Add("idcaja", 0);
var httpWebRequest = (HttpWebRequest)WebRequest.Create("http://gsprest.azurewebsites.net/api/Ventas/");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
streamWriter.Write(ven);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
return(Request.CreateResponse(HttpStatusCode.OK, result.Replace("\"", "")));
}
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
