namespace asp.net
{

        /// <summary>
        /// Summary description for Class1.
        /// </summary>
        public class DL_Bases
        {
                private Logger logger = null;
                protected DS_User _dsUser;
                string sUser = "";
                public DL_Bases(DS_User dsUser)
                {
                        _dsUser = dsUser;
                }
        
                private void CreateLogger()
                {
                        string sUser = _dsUser.UserSurname + "-" + _dsUser.UserId.ToString();
                        if( logger == null)
                        {
                                logger = new Logger();
                                logger.CreateLogger("");
                                //creates a logging oblect on the asp.net web server.
                        }
                }
                protected void Log(LoggerLib.LogLevel level, string user, string sClass, string sLog)
                {
                        if(logger == null)
                                CreateLogger();
                        logger.WriteLog(LogLevel.tDebug, user, sClass, sLog);
                }
                protected void Log(LoggerLib.LogLevel level, string sClass, string sLog)
                {
                        if(logger == null)
                                CreateLogger();
                        logger.WriteLog(LogLevel.tDebug, sUser, sClass, sLog);
                }
                protected DataSet GetDataSet( SqlCommand SqlCmd, string TableName) 
                {
                        SqlConnection SqlConn = null;
                        try
                        {
                                SqlConn = GetSqlConnection();
                                SqlConn.Open();
                                SqlCmd.Connection = SqlConn;
                                SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd);
                                DataSet ds = new DataSet();
                                SqlDa.Fill(ds, TableName);
                                return ds;
                        }
                        catch(SqlException ex)
                        {
                                Log(LogLevel.tDebug, sUser, "DL_Bases", ex.Message);
                                throw new  DataException("Failed to get dataset from table " + TableName, ex);
                        }
                        finally
                        {
                                if (SqlConn != null)
                                        SqlConn.Close();
                        }
                }
                protected DataSet GetDataSet( SqlCommand SqlCmd) 
                {
                        SqlConnection SqlConn = null;
                        try
                        {
                                SqlConn = GetSqlConnection();
                                SqlConn.Open();
                                SqlCmd.Connection = SqlConn;
                                SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd);
                                DataSet ds = new DataSet();
                                SqlDa.Fill(ds);
                                return ds;
                        }
                        catch(SqlException ex)
                        {
                                Log(LogLevel.tDebug, sUser, "DL_Bases", ex.Message);
                                throw new  DataException("Failed to get dataset from table ", ex);
                        }
                        finally
                        {
                                if (SqlConn != null)
                                        SqlConn.Close();
                        }
                }
                protected SqlDataReader GetDataReader( SqlCommand SqlCmd) 
                {                       
                        //If you use this make sure that you close the connection and
                        //Data reader after you have finished with it.
                        SqlConnection SqlConn = null;
                        SqlDataReader SqlDr = null;
                        try
                        {
                                SqlConn = GetSqlConnection();
                                SqlConn.Open();
                                SqlCmd.Connection = SqlConn;
                                SqlDr = SqlCmd.ExecuteReader();
                                return SqlDr;
                        }
                        catch(SqlException ex)
                        {
                                Log(LogLevel.tDebug, sUser, "DL_Bases", ex.Message);
                                throw new  DataException("Failed to get DataReader for sproc " + SqlCmd.CommandText, ex);
                                //this will be caught by the asp.net gui layer and