Optimistic Concurrency with C# using the IOC and DI Design Patterns

using System;
using System.Collections.Generic;
using System.Text;
using System.Resources;

namespace WFrmAppIOC
{
    /// <summary>
    /// ClsUser
    /// </summary>
    public class ClsUser
    {
        private iDatabase idb;
        /// <summary>
        /// ClsUser
        /// </summary>
        public ClsUser()
        {
            idb = new Postgres();
            idb.DBName = "CONNC";
            idb.Server = "localhost";
            idb.SAUserName = "postgres";
            idb.SAPassword = "Password1";
        }
        /// <summary>
        /// GetUserPassword
        /// </summary>
        /// <param name="userName"></param>
        /// <returns></returns>
        public string GetUserPassword(string userName)
        {
            string password = "";
            // check to see of the connection is set
            try
            {
                idb.CheckDBConnectionInfo();
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }
            // get the users password
            try
            {
                password = idb.GetUserPassword(userName);
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }
            return (password);
        }
        /// <summary>
        /// UpdateUser
        /// </summary>
        /// <param name="ud"></param>
        /// <returns></returns>
        public int UpdateUser(UserData ud)
        {
            int ires = -1;
            // check to see of the connection is set
            try {
                idb.CheckDBConnectionInfo();
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }
            // update the users data
            try
            {
                ires = idb.UpdateUser(ud);
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }
            return (ires);
        }
        /// <summary>
        /// AddUser
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="Password"></param>
        /// <param name="ModUSer"></param>
        /// <returns></returns>
        public int AddUser(string userName, string Password, string ModUSer)
        {
            int ires = -1;
            // check to see of the connection is set
            try
            {
                idb.CheckDBConnectionInfo();
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }

            try
            {
                ires = idb.AddUser(userName, Password, ModUSer); 
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return (ires);
        }
        /// <summary>
        /// GetUser
        /// </summary>
        /// <param name="userName"></param>
        /// <returns></returns>
        public UserData GetUser(string userName)
        {
            UserData ud;
            // check to see of the connection is set
            try
            {
                idb.CheckDBConnectionInfo();
            }
            catch (Exception ex)
            {
                string ostr;
                // show where the error came from. Get the class and methodname to display in the log file. 
                ostr = string.Format("{0}{1}", this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name);
                LogFile.WriteError(ostr, ex.Message);
                throw;
            }
            // Get the users data
            try
            {
                ud = idb.GetUser(userName);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return (ud);
        }
    }
}