public void UpdateResourceJson(Dtos.Resource resource)
{
SqlConnection con = null;
try
{
con = new SqlConnection(System.Environment.GetEnvironmentVariable("ConnectionString", EnvironmentVariableTarget.Process));
con.Open();
using (var db = new Database(con))
{
db.Update(resource);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.TraceError("NosyRepo error in InsertStory. " + ex.ToString());
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public Dtos.Resource GetLastResource()
{
SqlConnection con = null;
List <Dtos.Resource> results = null;;
Dtos.Resource result = null;
try
{
con = new SqlConnection(System.Environment.GetEnvironmentVariable("ConnectionString", EnvironmentVariableTarget.Process));
con.Open();
using (var db = new Database(con))
{
results = db.Fetch <Dtos.Resource>($"SELECT TOP(1) * FROM Resources ORDER BY Timestamp DESC");
}
if (results != null && results.Count > 0)
{
result = results[0];
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.TraceError("NosyRepo error in GetProviders. " + ex.ToString());
}
finally
{
if (con != null)
{
con.Close();
}
}
return(result);
}
public Dtos.Resource GetResource(int Id)
{
SqlConnection con = null;
Dtos.Resource result = null;
try
{
string conString = System.Environment.GetEnvironmentVariable("ConnectionString", EnvironmentVariableTarget.Process);
con = new SqlConnection(conString);
con.Open();
using (var db = new Database(con))
{
result = db.SingleById <Dtos.Resource>(Id);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.TraceError("Error in GetResources. " + ex.ToString());
}
finally
{
if (con != null)
{
con.Close();
}
}
return(result);
}
