public bool FindThingFromId(string thingId, ref string errorMessage, ref COP.API.Models.Thing results) { bool retVal = true; try { using (COPDBContext.monica_cnetContext context = new COPDBContext.monica_cnetContext()) { //Make query var things = (from d in context.Thing join f in context.ThingTemplates on d.Templateid equals f.Thingtemplateid where d.Thingid == long.Parse(thingId) select new { ogcid = d.Ogcid, id = d.Thingid, name = d.Name, descripton = d.Description, status = d.Status, lat = d.Lat, lon = d.Lon, ThingTemplate = f.Name } ).ToList(); if (things == null) { errorMessage = "No things"; retVal = false; } else { results = new Models.Thing(); var th = things[0]; results.Name = th.name; results.Id = (int)th.id; results.Description = th.descripton; results.Status = th.status; results.Lat = (decimal?)th.lat; results.Lon = (decimal?)th.lon; results.Ogcid = th.ogcid; results.ThingTemplate = th.ThingTemplate; } //Insert role connection; } return(retVal); } catch (Exception e) { errorMessage = "Database Excaption:" + e.Message + " " + e.StackTrace; return(false); } }
public IActionResult Delete(Models.Thing model) { int result = 0; using (MySqlConnection db = new MySqlConnection(_connection)) { var sql = "delete from PaymentDetails where PaymentDetailId=@PaymentDetailId"; result = db.Execute(sql, model); } return(Ok(result)); }
public IActionResult Insert(Models.Thing model) { int result = 0; using (MySqlConnection db = new MySqlConnection(_connection)) { var sql = "insert into PaymentDetails(CardOwnerName, CardNumber, ExpirationDate, SecurityCode)" + " values(@CardOwnerName, @CardNumber, @ExpirationDate, @SecurityCode)"; result = db.Execute(sql, model); } return(Ok(result)); }
public IActionResult Delete(Models.Thing data) { int Result = 0; using (var db = new MySqlConnection(_connection)) { var sql = "delete from thing where id=@id"; Result = db.Execute(sql, data); } return(Ok(Result)); }
public IActionResult Edit(Models.Thing model) { int result = 0; using (MySqlConnection db = new MySqlConnection(_connection)) { var sql = "UPDATE PaymentDetails set CardOwnerName = @CardOwnerName, CardNumber=@CardNumber" + ", ExpirationDate=@ExpirationDate, SecurityCode=@SecurityCode" + " where PaymentDetailId=@PaymentDetailId"; result = db.Execute(sql, model); } return(Ok(result)); }
public IActionResult Update(Models.Thing data) { int Result = 0; using (var db = new MySqlConnection(_connection)) { var sql = "update thing set name=@name, description=@description " + "where id=@id"; Result = db.Execute(sql, data); } return(Ok(Result)); }
public IActionResult Insert(Models.Thing data) { int Result = 0; using (var db = new MySqlConnection(_connection)) { var sql = "insert into thing(name,description) " + "values(@name, @description)"; Result = db.Execute(sql, data); } return(Ok(Result)); }
public bool ListThings(string thingType, ref string errorMessage, ref List <COP.API.Models.Thing> results) { bool retVal = true; try { using (COPDBContext.monica_cnetContext context = new COPDBContext.monica_cnetContext()) { //Make query var things = (from d in context.Thing join f in context.ThingTemplates on d.Templateid equals f.Thingtemplateid where f.Name == thingType select new { ogcid = d.Ogcid, id = d.Thingid, name = d.Name, descripton = d.Description, status = d.Status, lat = d.Lat, lon = d.Lon, ThingTemplate = f.Name } ).ToList(); if (things == null) { errorMessage = "No things"; retVal = false; } else { foreach (var th in things) { COP.API.Models.Thing z = new Models.Thing(); z.Name = th.name; z.Id = (int)th.id; z.Description = th.descripton; z.Status = th.status; z.Lat = (decimal?)th.lat; z.Lon = (decimal?)th.lon; z.ThingTemplate = th.ThingTemplate; z.Ogcid = th.ogcid; results.Add(z); } } //Insert role connection; } return(retVal); } catch (Exception e) { errorMessage = "Database Excaption:" + e.Message + " " + e.StackTrace; return(false); } }
public IActionResult Delete(Models.Thing model) { int result = 0; using (var db = new MySqlConnection(_connection)) { //los @ evita lo sqlInjection var sql = "DELETE from Thing where id=@id"; result = db.Execute(sql, model); /* POR POSTMAN * { * "id": 1 * } */ } return(Ok(result)); }
public IActionResult Edit(Models.Thing model) { int result = 0; using (var db = new MySqlConnection(_connection)) { //los @ evita lo sqlInjection var sql = "UPDATE Thing set name=@name, description=@description" + " where id=@id"; result = db.Execute(sql, model); /* POR POSTMAN * { * "id": 1, * "name": "CARRO", * "description": "Bebida que te manta" * } */ } return(Ok(result)); }
public IActionResult Insert(Models.Thing model) { int result = 0; using (var db = new MySqlConnection(_connection)) { //los @ evita lo sqlInjection var sql = "insert into Thing(name, description)" + " values(@name, @description)"; //return Ok("HolaMundo"); result = db.Execute(sql, model); /* POR POSTMAN * { * "name": "CARRO", * "description": "Una cosa que se mueva" * } */ } return(Ok(result)); }