using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.Common;

/// <summary>
/// Description résumée de GenericDataAccess
/// </summary>
public static class GenericDataAccess
{
	static GenericDataAccess()
	{
	}
    public static DataTable ExecuteSelectCommand(DbCommand command)
    {
        DataTable table;
        try
        {
            command.Connection.Open();
            DbDataReader reader = command.ExecuteReader();
            table = new DataTable();
            table.Load(reader);
            reader.Close();
        }
        catch (Exception ex)
        {
            Utilities.LogError(ex);
            throw ex;
        }
        finally
        {
            command.Connection.Close();
        }
        return table;
    }
    public static DbCommand CreateCommand()
    {
        string dataProviderName = BConfiguration.DbProviderName;//Classe qui renvoie via les propriétés les valeurs
        string connectionString = Configuration.DbConnectionString;
        DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName);
        DbConnection conn = factory.CreateConnection();
        conn.ConnectionString = connectionString;
        DbCommand comm = conn.CreateCommand();
        comm.CommandType = CommandType.StoredProcedure;
        return comm;
    }
    
}