public async Task AddReturnValues(ScriptReturnValue returnValue, string dbConfig) { await Disposable.UsingVoid( () => new SqlConnection(ConfigurationManager.ConnectionStrings[dbConfig].ConnectionString), async connection => { var kernel = new StandardKernel(new AgentDataModule(connection)); var repo = kernel.Get <IScriptCreation>(); await repo.CreateReturnValues(returnValue); }); }
public static ScriptReturnValue CreateReturnValueTemplate(Guid scriptKey, string deviceId) { return(ScriptReturnValue .Build() .WithDeviceId(deviceId) .WithScriptKey(scriptKey) .WithNotEqualKey(new Guid("00000000-0000-0000-0000-000000000000")) .WithEqualKey(new Guid("00000000-0000-0000-0000-000000000000")) .WithReturnValue("SUCCESS") .WithValueOperation("EQ") .Build()); }
public ScriptReturnValue Update(ScriptReturnValue entity) { throw new NotImplementedException(); }
public void Add(ScriptReturnValue enity) { throw new NotImplementedException(); }
public async Task CreateReturnValues(ScriptReturnValue returnValues) { if (string.IsNullOrWhiteSpace(returnValues.DeviceId)) { throw new ArgumentNullException("Please provide a deviceId before adding a record"); } var query = @"INSERT INTO dbo.[dsa_scriptReturnValues] ([dateAdded] ,[dateChanged] ,[lastUserID] ,[deviceID] ,[fieldKey] ,[scriptKey] ,[returnValue] ,[overrideLabel] ,[valueOperation] ,[nextScriptID] ,[mappingValue]) VALUES (GETDATE() ,GETDATE() ,@lastUserID ,@deviceId ,NULL ,@scriptKey ,@returnValue ,NULL ,'EQ' ,@EQScriptKey ,@mappingValue)"; var retrunValue2 = @"INSERT INTO .dbo.[dsa_scriptReturnValues] ([dateAdded] ,[dateChanged] ,[lastUserID] ,[deviceID] ,[fieldKey] ,[scriptKey] ,[returnValue] ,[overrideLabel] ,[valueOperation] ,[nextScriptID] ,[mappingValue]) VALUES (GETDATE() ,GETDATE() ,@lastUserID ,@deviceId ,NULL ,@scriptKey ,@returnValue ,NULL ,'NE' ,@NEGuid ,@mappingValue)"; var p = new DynamicParameters(); p.Add("@lastUserID", "kris.lindsey"); p.Add("@deviceId", returnValues.DeviceId); p.Add("@scriptKey", returnValues.ScriptKey); p.Add("@returnValue", returnValues.ReturnValue); p.Add("@NEGuid", returnValues.NotEquelScriptKey); p.Add("@EQScriptKey", returnValues.EqualScripKey); p.Add("@deviceId", returnValues.DeviceId); p.Add("@mappingValue", returnValues.MappingValue); try { await _db.ExecuteAsync(query, p); await _db.ExecuteAsync(retrunValue2, p); } catch (Exception) { throw; } }
public async Task Create_Tuffs_Script_Test() { var db = new { smartAgentDev = "SmartAgentDev", smartAgentProd = "SmartAgentProd", remixDev = "RemixDb" }; var agentDataSvc = new SmartAgentDataSvc(); int count = 1; var tuffs = new { DeviceId = "TufsNetowr00", WebstieDescription = "TufsNetowrkHealth 00", scripts = new List <Script>(), websitekey = new Guid("e38b2dac-a5e7-e511-8d27-000c29729dff") }; var TuffsScript = new List <Script>(); var loginScript = Script.CreateScript( string.Concat(tuffs.WebstieDescription, count, ": Loginscript, login error check"), TufsNetworkHealth.Login_Script(new InternetExplorer()).ToString(), string.Concat(tuffs.DeviceId, count), "Login", tuffs.websitekey); TuffsScript.Add(loginScript); var goToAuthPage = Script.CreateScript( string.Concat(tuffs.WebstieDescription, HelperMethods.Increment(count), ": Go to authorization page"), TufsNetworkHealth.Goto_Referrals_Auhorizations_PatientSearch_Page().ToString(), string.Concat(tuffs.DeviceId, HelperMethods.Increment(count)), "PatientSearch", tuffs.websitekey); TuffsScript.Add(goToAuthPage); foreach (var script in TuffsScript) { var returnValueCount = 0; var deviceId = string.Concat("TufsNetowr00", returnValueCount); var scriptKey = await agentDataSvc.AddScript(script, db.remixDev); if (scriptKey != null) { var returnValue = ScriptReturnValue .Build() .WithDeviceId(script.DeviceId) .WithScriptKey(scriptKey) .WithNotEqualKey(new Guid("00000000-0000-0000-0000-000000000000")) .WithEqualKey(new Guid("00000000-0000-0000-0000-000000000000")) .WithReturnValue("SUCCESS") .WithValueOperation("EQ") .Build(); await agentDataSvc.AddReturnValues(returnValue, db.remixDev); Console.WriteLine(scriptKey); } else { Console.WriteLine("error adding record", scriptKey); } } }