public bool Farmacia(farmaciasAPI farmaciass, string tipo)
{
switch (tipo)
{
case "insert":
api = new APIModel();
farmaciasAPI far;
far = (farmaciasAPI)farmaciass;
bool v = false;
string[] listado = new string[1000];
string[] insert = new string[10000];
int incrementable = 0;
int incrementable1 = 0;
for (int i = 0; i < far.result.records.Count(); i++)
{
bool f = api.farmacia_get(far.result.records[i]._id); // Valida si existe el registro anteriormente
if (!f)
{
v = api.farmacia_insert(far.result.records[i]._id, far.result.records[i].local_nombre, far.result.records[i].local_lat, far.result.records[i].local_lng, far.result.records[i].fk_localidad);
if (!v)
{
listado[incrementable] = far.result.records[i]._id.ToString(); //Registeo de las farmacias no creadas.
incrementable++;
}
else
{
insert[incrementable1] = far.result.records[i]._id.ToString(); //Registeo de las farmacias creadas.
incrementable1++;
}
}
}
if (incrementable1 > 0)
{
return(true);
}
else
{
return(false);
}
//return v;
break;
default:
string[] listado1 = new string[1000];
return(false);
break;
}
}
public ActionResult getSectores()
{
// Create a request using a URL that can receive a post.
string uri = "http://datos.gob.cl/api/action/datastore_search_sql?sql=SELECT%20localidad_nombre,fk_localidad,fk_region%20from%20%22a60f93af-6a8a-45b6-85ff-267f5dd37ad6%22%20";
// Set the Method property of the request to POST.
var request = (HttpWebRequest)WebRequest.Create(uri);
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
farmaciasAPI esto = JsonConvert.DeserializeObject <farmaciasAPI>(responseString);
ViewData["Data_insert"] = responseString;
Sectores(esto, "insert");
return(View());
}
// [HttpPost]
public ActionResult get_List_Farmacias()
{
// Create a request using a URL that can receive a post.
string uri = "http://datos.gob.cl/api/action/datastore_search_sql?sql=SELECT%20*%20from%20%22a60f93af-6a8a-45b6-85ff-267f5dd37ad6%22%20";
// Set the Method property of the request to POST.
var request = (HttpWebRequest)WebRequest.Create(uri);
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
farmaciasAPI mi_respuesta = JsonConvert.DeserializeObject <farmaciasAPI>(responseString);
//ViewData["wrGETURL"] = esto;
ViewBag.res = Farmacia(mi_respuesta, "insert");
return(RedirectToAction("../Home"));
//return View();
}
public bool Sectores(farmaciasAPI farmaciass, string tipo)
{
switch (tipo)
{
case "insert":
api = new APIModel();
//farmaciass esto = new farmaciass();
farmaciasAPI far;
far = (farmaciasAPI)farmaciass;
bool v = false;
for (int i = 0; i < far.result.records.Count(); i++)
{
bool e = api.sector_get(far.result.records[i].fk_localidad);
if (!e)
{
v = api.sector_insert(far.result.records[i].localidad_nombre, far.result.records[i].fk_localidad, far.result.records[i].fk_region);
}
}
return(v);
break;
case "update":
Console.WriteLine("Case 2");
return(false);
break;
default:
Console.WriteLine("Default case");
return(false);
break;
}
}
