public async Task <ScriptCollectionItem> CreateCollectionItems(ScriptCollectionItem collectionItem)
{
if (string.IsNullOrWhiteSpace(collectionItem.DeviceId))
{
throw new ArgumentNullException("Need a deviceId in order to add collection item.");
}
var query = @"INSERT INTO dbo.dsa_scriptCollectionItems
(dateAdded,dateChanged,lastUserID, deviceID, scriptKey, fieldKey,overrideLabel, defaultValue, required,
collectionMask, validationRoutine,Can_Go_back)
VALUES(GetDate(),GetDate(),'kris.lindsey',@deviceId, @scriptKey,@fieldKey,@overideLabel,NULL,1,NULL,NULL, 1)
SELECT scriptKey, fieldKey, deviceId, overrideLabel
FROM dbo.dsa_scriptCollectionItems
WHERE scriptkey = @scriptkey and overrideLabel = @overideLabel";
var parameters = new DynamicParameters();
parameters.Add("@deviceId", collectionItem.DeviceId);
parameters.Add("@scriptKey", collectionItem.ScriptKey);
parameters.Add("@fieldKey", collectionItem.FieldKey);
parameters.Add("@overideLabel", collectionItem.OverrideLabel);
try
{
var record = await _db.QueryAsync <ScriptCollectionItem>(query, parameters);
return(record.SingleOrDefault());
}
catch (SqlException)
{
throw;
}
}
public async Task <ScriptCollectionItem> AddCollectionItems(ScriptCollectionItem collectionItem, string dbConfig)
{
return(await Disposable.UsingAsync(
() => new SqlConnection(ConfigurationManager.ConnectionStrings[dbConfig].ConnectionString),
async connection =>
{
var kernel = new StandardKernel(new AgentDataModule(connection));
var repo = kernel.Get <IScriptCreation>();
return await repo.CreateCollectionItems(collectionItem);
}));
}
