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