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