public DBResult InsertLidarConfig(LidarConfig config)
{
ISqlizable sql = DB.Format(@"
INSERT INTO
sitewerx.lidar_configs (CONFIG_NAM, CONFIG_DATA)
VALUES
('{0}','{1}');
" , config.Name, config.Data);
return(DB.Insert(sql));
}
public DBResult UpdateLidarConfig(LidarConfig config)
{
ISqlizable sql = DB.Format(@"
UPDATE
sitewerx.lidar_configs
SET
CONFIG_DATA = '{1}'
WHERE
CONFIG_ID = {0};
" , config.Id, config.Data);
return(DB.Update(sql));
}
public IEnumerable <LidarConfig> Get()
{
var configFiles = this.GetFilePaths();
List <LidarConfig> configs = new List <LidarConfig>();
foreach (var file in configFiles)
{
string fileContent = File.ReadAllText(file);
dynamic d = JObject.Parse(fileContent);
LidarConfig config = new LidarConfig()
{
Name = d.name,
Data = fileContent
};
configs.Add(config);
}
return(configs);
}
public bool Post([FromBody] LidarConfig config)
{
File.WriteAllText(HostingEnvironment.MapPath("~/Configurations/" + config.Name + ".json"), config.Data);
return(true);
}
