public async Task <IEnumerable <ScriptMaster> > GetScripts(Guid websiteKey)
{
if (StaticHelpers.CheckForNullOrWhiteSpace(websiteKey))
{
throw new ArgumentNullException();
}
var query = @"SELECT scriptKey, scriptDesc, ScriptCode, websiteKey
FROM ScriptingAgentDatabase.dbo.dsa_scriptMaster
WHERE websiteKey = @websiteKey
ORDER BY scriptDesc";
var p = new DynamicParameters();
p.Add("@websiteKey", websiteKey);
try {
return(await _db.QueryAsync <ScriptMaster>(query, p));
}
catch (Exception) {
throw;
}
}
