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