public async Task <IActionResult> Get()
{
var array = Enumerable.Range(0, name.Length - 1).Select(index => new BranchOffice
{
nombre = name[index],
provincia = province[index],
canton = state[index],
distrito = district[index],
telefono = phones[index]
})
.ToArray();
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/BranchOffice",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All workers.", items = array })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All workers.", items = array }));
}
public async Task <IActionResult> Get()
{
Worker[] response = new Worker[5];
for (int i = 0; i < response.Length; i++)
{
response[i] = new Worker
{
Cedula = id[i],
nacimiento = birthdate[i],
ingreso = firstdate[i],
nombre = firstName[i],
salario_h = hourSalary[i],
apellidos = lastName[i],
salario_m = monthSalary[i],
pass = password[i]
};
}
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Workers",
Request = "",
Response = JsonConvert.SerializeObject(new { result = 200, items = response })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = 200, items = response }));
}
public async Task <IActionResult> Get()
{
var array = Enumerable.Range(0, names.Length - 1).Select(index => new Products
{
Nombre = names[index],
Desc = description[index],
barcode = barcodes[index],
Descuento = discounts[index],
Precio = prices[index],
Cant = quantities[index],
Impuesto = taxes[index]
})
.ToArray();
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Products",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All products.", items = array })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All products.", items = array }));
}
public async Task <IActionResult> Get()
{
object[] p = { new
{
delivery = DateTime.Parse("2020-06-20"),
compra = DateTime.Parse("2020-06-10"),
description = "Paquete que alguien compró",
multa = 3,
state = 1,
trackingID = 238947629
} };
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Packages",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All packages", items = p })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All packages", items = p }));
}
public async Task <IActionResult> Get([FromBody] Salesman salesman)
{
Salesman[] s =
{
new Salesman
{
nombre = "Carl",
cedula = 234564
},
new Salesman
{
nombre = "John",
cedula = 653464
}
};
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Salesmen",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All salesman", items = s })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All salesman", items = s }));
}
public async Task <IActionResult> Get()
{
object[] p =
{
new
{
id = 235345,
distritos = new[]{ "SJ", "CARTAGO" }
},
new
{
id = 58234790,
distritos = new[]{ "Alajuela", "Guana" }
}
};
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Routes",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All routes.", items = p })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All routes.", items = p }));
}
public IActionResult Get()
{
string[] roles = new[]
{
"Administrador", "Repartidor", "Bodeguero"
};
string[] desc = new[]
{
"Rol de admin", "Rol de repartidor", "Rol de bodeguero"
};
string[] union1 =
{
roles[0],
desc[0]
};
string[] union2 =
{
roles[1],
desc[1]
};
string[] union3 =
{
roles[2],
desc[2]
};
object[] r1 =
{
union1,
union2,
union3
};
string r = JsonConvert.SerializeObject(r1);
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Roles",
Request = "",
Response = JsonConvert.SerializeObject(new { result = r })
};
context.Add(LogReg);
context.SaveChanges();
return(Ok(new { result = r }));
}
public async Task <IActionResult> Get()
{
Client[] response = new Client[5];
for (int i = 0; i < response.Length; i++)
{
response[i] = new Client
{
cedula = ids[i],
nombre = names[i],
correo = emails[i],
casillero = lockers[i],
celular = cellphones[i],
habitacion = phones[i],
usuario = users[i],
pass = passwords[i],
provincia = provinces[i],
canton = states[i],
distrito = districts[i],
otras = others[i]
};
}
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Clients",
Request = "",
Response = JsonConvert.SerializeObject(new { result = 200, items = response })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = 200, items = response }));
}
private void QueryLog(bool includeInfo, bool includeWarn, bool includeError)
{
String filter = " ";
if (!includeInfo)
{
filter += "AND level!='INFO' ";
}
if (!includeWarn)
{
filter += "AND level!='WARN' ";
}
if (!includeError)
{
filter += "AND level!='ERROR' ";
}
LogDatabase.Clear();
MySqlDataReader reader = null;
try
{
String sql = "SELECT date,millisecond,level,message,location FROM loginfo WHERE id='" + crawlId + "'" + filter + " ORDER BY date DESC LIMIT 1024;";
MySqlCommand cmd = new MySqlCommand(sql, database);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Log log = new Log();
log.Date = reader.GetDateTime(0);
log.Millisecond = reader.GetInt16(1);
log.Level = reader.GetString(2);
log.Message = reader.GetString(3);
log.Location = reader.GetString(4);
LogDatabase.Add(log);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public async Task <IActionResult> Post([FromBody] Buy value)
{
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "POST",
ReqPath = "/Compras",
Request = JsonConvert.SerializeObject(value, Formatting.Indented),
Response = JsonConvert.SerializeObject(new { result = "Compra realizada." })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "Compra realizada." }));
}
public async Task <IActionResult> Get()
{
Sale[] s =
{
new Sale
{
barcode = 52435234,
cant = 54,
desc = "Productos electrónicos",
descuento = 0,
impuesto = 0.13,
nombre = "Televisores",
precio = 2958376,
vendidos = 20
},
new Sale
{
barcode = 673356756,
cant = 54,
desc = "Joyería",
descuento = 0,
impuesto = 0.13,
nombre = "Collares",
precio = 2958376,
vendidos = 20
}
};
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Sales",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All sales.", items = s })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All sales.", items = s }));
}
public async Task <IActionResult> Get()
{
object[] p =
{
new
{
id = 5347895,
desc = "Paquets extraños",
estado = 1,
compra = "2020-03-02",
entrega = "2020-07-02",
multas = 1,
ced = 562783
},
new
{
id = 627549789,
desc = "Comida",
estado = 2,
compra = "2020-03-02",
entrega = "2020-07-02",
multas = 1,
ced = 562783
}
};
var LogReg = new LogReg
{
id = Guid.NewGuid(),
HttpMethod = "GET",
ReqPath = "/Reparto",
Request = "",
Response = JsonConvert.SerializeObject(new { result = "All packages", paq = p })
};
context.Add(LogReg);
await context.SaveChangesAsync();
return(Ok(new { result = "All packages", paq = p }));
}