public void CRUD()
{
e.features obj = new e.features()
{
type = "testing",
coordinatesx = 34.8001090000001f,
coordinatesy = 32.008471f,
name = "testing name",
place = "testing place",
comments = "testing comments",
pointx = 32.008471f,
pointy = 34.800109f,
fromtime = 1584691200000,
totime = 1584709200000,
sourceoid = 1,
staytimes = "10:00 - 15:00",
remark = "remark"
};
//Create
e.shared.ActionResult insert_result = d.features.Insert(obj).Result;
//Read
obj = d.features.Get(int.Parse(insert_result.Value.ToString())).Result;
//Read all
IEnumerable <e.features> objs = d.features.Get().Result;
//Update
obj.name = "testing update";
e.shared.ActionResult update_result = d.features.Update(obj).Result;
//Delete
e.shared.ActionResult delete_result = d.features.Delete(int.Parse(insert_result.Value.ToString())).Result;
}
public async Task <IActionResult> Put([FromBody] e.features obj)
{
try
{
e.shared.ActionResult result = await d.features.Update(obj);
return(Ok(obj));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static async Task <e.shared.ActionResult> Update(e.features obj)
{
using (var db = d.ConnectionFactory())
{
obj.modified_date = DateTime.Now;
await db.ExecuteAsync(d.Update <e.features>(), obj);
return(new e.shared.ActionResult {
Status = e.shared.Status.Success
});
}
}
public async Task <IActionResult> Post([FromBody] e.features obj)
{
try
{
e.shared.ActionResult result = await d.features.Insert(obj);
obj.feature_id = int.Parse(result.Value.ToString());
return(Ok(obj));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static async Task <e.shared.ActionResult> Insert(e.features obj)
{
using (var db = d.ConnectionFactory())
{
obj.creation_date = DateTime.Now;
obj.modified_date = DateTime.Now;
long id = await db.ExecuteScalarAsync <int>(d.InsertAutoId <e.features>(), obj);
return(new e.shared.ActionResult {
Status = e.shared.Status.Success, Value = id
});
}
}
