DataAccess Tier scripts

--------------------------------------------------
using Directives
--------------------------------------------------

using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

//Note: make your class public

--------------------------------------------------
Region Directives 
--------------------------------------------------

#region " Public properties "
 
#endregion

#region " Read methods "

#endregion

#region " Insert methods "

#endregion

#region " Update methods "

#endregion

#region " Delete methods "

#endregion

--------------------------------------------------
Common properties 
--------------------------------------------------


        public static bool pTransactionSuccessful;
        public bool TransactionSuccessful()
        {
            return pTransactionSuccessful;
        }
        public static string pErrorMessage;
        public string ErrorMessage()
        {
            return pErrorMessage;
        }
        public static int pErrorNumber;
        public int ErrorNumber()
        {
            return pErrorNumber;
        }
        public static int pErrorClass;
        public int ErrorClass()
        {
            return pErrorClass;
        }
        public static int pErrorState;
        public int ErrorState()
        {
            return pErrorState;
        }
        public static int pErrorLineNumber;
        public int ErrorLineNumber()
        {
            return pErrorLineNumber;
        }

--------------------------------------------------
Generic read method
--------------------------------------------------


          public DataTable GetSomeResult(int Parameter1, string ConnectionString)
        {
            // Set up parameters in parameter array 
            SqlParameter[] arParms = new SqlParameter[1];

            arParms[0] = new SqlParameter("@Parameter1", SqlDbType.Int);
            arParms[0].Value = Parameter1;

            pTransactionSuccessful = true;

            DataTable dtSomeInfo = new DataTable("SomeInfo");

            try
            {
                DataSet dsSomeInfo = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetSomeInfo", arParms);
                dtSomeInfo = dsSomeInfo.Tables[0];
            }
            catch (SqlException ReadError)
            {
                pErrorMessage = ReadError.Message.ToString();
                pErrorNumber = ReadError.Number;
                pErrorClass = ReadError.Class;
                pErrorState = ReadError.State;
                pErrorLineNumber = ReadError.LineNumber;

                pTransactionSuccessful = false;
            }
            return dtSomeInfo;
        }
        
               public void ValidateUser(string Email, string Password, string ConnectionString)
       {
           // Set up parameters in parameter array 
           SqlParameter[] arParms = new SqlParameter[3];

           arParms[0] = new SqlParameter("@Email", SqlDbType.NVarChar);
           arParms[0].Value = Email;
           arParms[1] = new SqlParameter("@Password", SqlDbType.NVarChar);
           arParms[1].Value = Password;
           arParms[2] = new SqlParameter("@IsFound", SqlDbType.Bit);
           arParms[2].Direction = ParameterDirection.Output;

           pTransactionSuccessful = true;

           try
           {
               SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "ValidateUser", arParms);
           }
           catch (SqlException ReadError)
           {
               pErrorMessage = ReadError.Message.ToString();
               pErrorNumber = ReadError.Number;
               pErrorClass = ReadError.Class;
               pErrorState = ReadError.State;
               pErrorLineNumber = ReadError.LineNumber;

               pTransactionSuccessful = false;
           }
           pIsFound = (bool)arParms[2].Value;
       }

       public DataTable GetUserInfo(string Email, string ConnectionString)
       {
           // Set up parameters in parameter array 
           SqlParameter[] arParms = new SqlParameter[1];

           arParms[0] = new SqlParameter("@Email", SqlDbType.NChar);
           arParms[0].Value = Email;

           pTransactionSuccessful = true;

           DataTable dtUserInfo = new DataTable("UserInfo");

           try
           {
               DataSet dsUserInfo = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetUserInfo", arParms);
               dtUserInfo = dsUserInfo.Tables[0];
           }
           catch (SqlException ReadError)
           {
               pErrorMessage = ReadError.Message.ToString();
               pErrorNumber = ReadError.Number;
               pErrorClass = ReadError.Class;
               pErrorState = ReadError.State;
               pErrorLineNumber = ReadError.LineNumber;

               pTransactionSuccessful = false;
           }
           return dtUserInfo;
       }

--------------------------------------------------
Generic insert/update method
--------------------------------------------------



        public void InsertSomething(string Parameter1, bool Parameter2, string ConnectionString)
        {
            // Set up parameters in parameter array 
            SqlParameter[] arParms = new SqlParameter[2];

            arParms[0] = new SqlParameter("@Parameter1", SqlDbType.NVarChar);
            arParms[0].Value = Parameter1;
            arParms[1] = new SqlParameter("@Parameter2", SqlDbType.bit);
            arParms[1].Value = Parameter2;

            pTransactionSuccessful = true;

            try
            {
                SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "InsertSomething", arParms);
            }
            catch (SqlException InsertError)
            {
                pErrorMessage = InsertError.Message.ToString();
                pErrorNumber = InsertError.Number;
                pErrorClass = InsertError.Class;
                pErrorState = InsertError.State;
                pErrorLineNumber = InsertError.LineNumber;

                pTransactionSuccessful = false;
            }
        }