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