StoredProcedures.cs :  » Persistence-Frameworks » ORM.NET » ORMBiz » C# / CSharp Open Source

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Reflection;

using OrmLib;

namespace ORMBiz{
  /// <summary>
  /// Wraps stored proceedure calls
  /// </summary>
  public class StoredProcedures 
  {
    private  static DataManager dm;
    /// <summary>
    /// Wraps stored proceedure calls
    /// </summary>
    static StoredProcedures() { dm = new DataManager(Config.Dsn);}
  
    /// <summary>
    /// Calls DeleteDatabase, returning a DataSet of any rows returned 
    /// from the stored proceedure.
    /// </summary>
    /// <returns>DataSet</returns>
    public static DataSet DeleteDatabase(  System.Int32 FKDatabaseID )
    {
      ArrayList arrayParams = new ArrayList();
  
      SqlParameter paramFKDatabaseID = new SqlParameter( "@FKDatabaseID", FKDatabaseID);
      paramFKDatabaseID.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "int", true);
      paramFKDatabaseID.Direction = ParameterDirection.Input;
      paramFKDatabaseID.Size = 4;
      arrayParams.Add( paramFKDatabaseID );


      DataSet ds = dm.ExecuteProcedure("DeleteDatabase", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
      
      return ds;
    }

    /// <summary>
    /// Calls sp_LogMetrics, returning a DataSet of any rows returned 
    /// from the stored proceedure.
    /// </summary>
    /// <returns>DataSet</returns>
    public static DataSet sp_LogMetrics(  System.Guid instanceId,
  System.String traceMsg )
    {
      ArrayList arrayParams = new ArrayList();
  
      SqlParameter paraminstanceId = new SqlParameter( "@instanceId", instanceId);
      paraminstanceId.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "uniqueidentifier", true);
      paraminstanceId.Direction = ParameterDirection.Input;
      paraminstanceId.Size = 16;
      arrayParams.Add( paraminstanceId );

      SqlParameter paramtraceMsg = new SqlParameter( "@traceMsg", traceMsg);
      paramtraceMsg.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "varchar", true);
      paramtraceMsg.Direction = ParameterDirection.Input;
      paramtraceMsg.Size = 200;
      arrayParams.Add( paramtraceMsg );


      DataSet ds = dm.ExecuteProcedure("sp_LogMetrics", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
      
      return ds;
    }

    /// <summary>
    /// Calls ProcessSchemaUpdate, returning a DataSet of any rows returned 
    /// from the stored proceedure.
    /// </summary>
    /// <returns>DataSet</returns>
    public static DataSet ProcessSchemaUpdate(  System.String xml,
  System.Int32 FKDatabaseID )
    {
      ArrayList arrayParams = new ArrayList();
  
      SqlParameter paramxml = new SqlParameter( "@xml", xml);
      paramxml.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "text", true);
      paramxml.Direction = ParameterDirection.Input;
      paramxml.Size = 16;
      arrayParams.Add( paramxml );

      SqlParameter paramFKDatabaseID = new SqlParameter( "@FKDatabaseID", FKDatabaseID);
      paramFKDatabaseID.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "int", true);
      paramFKDatabaseID.Direction = ParameterDirection.Input;
      paramFKDatabaseID.Size = 4;
      arrayParams.Add( paramFKDatabaseID );


      DataSet ds = dm.ExecuteProcedure("ProcessSchemaUpdate", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
      
      return ds;
    }

    /// <summary>
    /// Calls test, returning a DataSet of any rows returned 
    /// from the stored proceedure.
    /// </summary>
    /// <returns>DataSet</returns>
    public static DataSet test(  )
    {
      ArrayList arrayParams = new ArrayList();
  

      DataSet ds = dm.ExecuteProcedure("test", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
      
      return ds;
    }


  }
}