public void RemoveDataSource([FromBody] NovicellMapBuilderDataModel data)
{
using (_db)
{
var sql = string.Format("SELECT * FROM {0} WHERE DataId = {1}", StaticHelper.GetMapsTableName(), data.Id);
var mapsWithDateSource =
_db.Query <NovicellMapBuilderMapsModel>(sql).ToList();
foreach (var map in mapsWithDateSource)
{
map.DataId = -1;
_db.Save(map);
}
_db.Delete(data);
}
}
public ApiResult SaveDataSource([FromBody] NovicellMapBuilderDataModel data)
{
var result = new ApiResult();
try
{
result.Success = true;
using (_db)
{
_db.Save(data);
}
}
catch (Exception e)
{
result.Success = false;
result.ErrorMessage = e.Message;
}
return(result);
}
public ApiResult CreateNewDataSource(string name)
{
var result = new ApiResult();
try
{
result.Success = true;
using (_db)
{
var model = new NovicellMapBuilderDataModel
{
Name = name
};
result.Data = _db.Insert(model);
}
}
catch (Exception e)
{
result.Success = false;
result.ErrorMessage = e.Message;
}
return(result);
}
