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