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 })); }