public async Task <CriteriaSets> AddCriteriaSetRecord(CriteriaSets criteriaSetRecord)
{
if (criteriaSetRecord.CriteriaSetKey != null)
{
var query = @"INSERT INTO dsa_criteriaSets(lastUserID, deviceID, criteriaSetKey, criteriaSetName, transactionTypeKey, scriptKey, Priority)
VALUES('kris.lindsey',@deviceId, @criteriaSetKey, @criteriaSetName ,'ebcd603b-9fd8-e411-96c2-000c29729dff', @scriptKey, 1)
SELECT criteriaSetKey, CriteriaSetName, ScriptKey, DeviceId FROM dsa_criteriaSets WHERE criteriaSetKey = @criteriaSetKey";
var p = new DynamicParameters();
p.Add("@deviceId", criteriaSetRecord.DeviceId);
p.Add("@criteriaSetKey", criteriaSetRecord.CriteriaSetKey);
p.Add("@criteriaSetName", criteriaSetRecord.CriteriaSetName);
p.Add("@scriptKey", criteriaSetRecord.ScriptKey);
try
{
var criteriaSets = await _db.QueryAsync <CriteriaSets>(query, p);
return(criteriaSets.SingleOrDefault());
}
catch (Exception ex)
{
logger.Debug("Error adding criteria set records: {0}", ex);
throw;
}
}
else
{
throw new ArgumentNullException("Criteria Set records are null or empty.");
}
}
public async Task Move_Single_Set_Of_Criteria_To_Production_From_Development()
{
var criteriaSetKey = new Guid("44529C9F-1727-4E58-B006-9149C5EB92A4");
CriteriaSets criteriaSet = null;
using (IDbConnection devDb = new SqlConnection(ConfigurationManager.ConnectionStrings[_devAppConfigName].ConnectionString))
{
var kernel = new StandardKernel(new RepoTestsModule(devDb));
var repo = kernel.Get <ISmartAgentRepository>();
Assert.IsNotNull(criteriaSet = await repo.FindCriteriaSetRecord(criteriaSetKey));
}
CriteriaSets pordCriteriaSet = null;
// move found dev record to production
using (IDbConnection devDb = new SqlConnection(ConfigurationManager.ConnectionStrings[_prodAppConfigName].ConnectionString))
{
var kernel = new StandardKernel(new RepoTestsModule(devDb));
var repo = kernel.Get <ISmartAgentRepository>();
// Assert.IsNotNull(pordCriteriaSet = await repo.AddCriteriaSetRecord(criteriaSet));
}
Console.WriteLine("Record Added successfully!: {0}", pordCriteriaSet);
}
Task <IEnumerable <Criteria> > ISmartAgentRepository.AddCriteriaSetRecord(CriteriaSets criteriaSetRecord)
{
throw new NotImplementedException();
}
