protected void Create()
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure("AddUrlCache");
LoadSP(storedProcedure);
storedProcedure.AddParam("dtCreated", DateTime.Now);
storedProcedure.AddParam("dtLastUpdated", DateTime.Now);
db.Get(storedProcedure).Close();
}
}
protected void Load(string Url, string Parameters, string RequestVerb)
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure("GetUrlCacheByUrlParam");
storedProcedure.AddParam("sUrl", Url);
storedProcedure.AddParam("sParameters", Parameters);
storedProcedure.AddParam("sRequestVerb ", RequestVerb);
System.Data.SqlClient.SqlDataReader rs = db.Get(storedProcedure);
while (rs.Read())
{
LoadRS(rs);
}
rs.Close();
}
}
protected void Delete()
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure("DeleteUrlCache");
storedProcedure.AddParam("liUrlCacheID", this.UrlCacheID);
db.Get(storedProcedure).Close();
}
}
protected void Load(int UrlCacheID)
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure("GetUrlCacheByID");
storedProcedure.AddParam("liUrlCacheID", UrlCacheID);
System.Data.SqlClient.SqlDataReader rs = db.Get(storedProcedure);
while (rs.Read())
{
LoadRS(rs);
}
rs.Close();
}
}
private StoredProcedure LoadSP(StoredProcedure storedProcedure)
{
storedProcedure.AddParam("liUrlCacheID", this.UrlCacheID);
storedProcedure.AddParam("sUrl", this.Url);
storedProcedure.AddParam("sContents", this.Contents);
storedProcedure.AddParam("sDomain", this.Domain);
storedProcedure.AddParam("sParameters", this.ParameterString);
storedProcedure.AddParam("sRequestVerb", this.RequestVerbString);
return(storedProcedure);
}
private StoredProcedure LoadSP( StoredProcedure storedProcedure )
{
storedProcedure.AddParam( "liUrlCacheID", this.UrlCacheID );
storedProcedure.AddParam( "sUrl", this.Url );
storedProcedure.AddParam( "sContents", this.Contents );
storedProcedure.AddParam( "sDomain", this.Domain );
storedProcedure.AddParam( "sParameters", this.ParameterString );
storedProcedure.AddParam( "sRequestVerb", this.RequestVerbString );
return storedProcedure;
}
protected void Update()
{
using ( Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure( "UpdateUrlCache" );
LoadSP( storedProcedure );
storedProcedure.AddParam( "dtLastUpdated", DateTime.Now );
db.Get( storedProcedure ).Close();
}
}
protected void Load( string Url, string Parameters, string RequestVerb )
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure( "GetUrlCacheByUrlParam" );
storedProcedure.AddParam( "sUrl", Url );
storedProcedure.AddParam( "sParameters", Parameters );
storedProcedure.AddParam( "sRequestVerb ", RequestVerb );
System.Data.SqlClient.SqlDataReader rs = db.Get( storedProcedure );
while ( rs.Read() )
LoadRS ( rs );
rs.Close();
}
}
protected void Load( int UrlCacheID )
{
using (Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure( "GetUrlCacheByID" );
storedProcedure.AddParam( "liUrlCacheID", UrlCacheID );
System.Data.SqlClient.SqlDataReader rs = db.Get( storedProcedure );
while ( rs.Read() )
LoadRS ( rs );
rs.Close();
}
}
protected void Delete()
{
using ( Database db = new Database( ))
{
StoredProcedure storedProcedure = new StoredProcedure( "DeleteUrlCache" );
storedProcedure.AddParam( "liUrlCacheID", this.UrlCacheID );
db.Get( storedProcedure ).Close();
}
}
