public void EditUserCredentials(IUserCredentialsDO iUserCredentials)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(_ConnectionString))
                {
                    using (SqlCommand createComm = new SqlCommand("sp_UserCredentialsAddOrEdit", conn))
                    {
                        try
                        {
                            createComm.CommandType    = CommandType.StoredProcedure;
                            createComm.CommandTimeout = 35;
                            createComm.Parameters.AddWithValue("@CreatedByUserId", SqlDbType.Int).Value      = iUserCredentials.UserCredentailsID;
                            createComm.Parameters.AddWithValue("@TeamId", SqlDbType.Int).Value               = iUserCredentials.UserID_FK;
                            createComm.Parameters.AddWithValue("@parmUserPassword", SqlDbType.VarChar).Value = iUserCredentials.UserPassword;
                            createComm.Parameters.AddWithValue("@parmSalt", SqlDbType.VarChar).Value         = iUserCredentials.Salt;
                        }
                        catch (Exception ex)
                        {
                            ErrorLogger.LogError(ex, "CreateUserCredentials", "nothing");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ErrorLogger.LogError(ex, "CreateUserCredentials", "nothing");
            }

            finally
            {
            }
        }
        public static UserCredentialPO MapUserCredentialsDOtoPO(IUserCredentialsDO userCredentialsDO)
        {
            var oUserCredentials = new UserCredentialPO();

            oUserCredentials.UserCredentailsID = userCredentialsDO.UserCredentailsID;
            oUserCredentials.UserPassword      = userCredentialsDO.UserPassword;
            oUserCredentials.UserID_FK         = userCredentialsDO.UserID_FK;
            oUserCredentials.Salt = userCredentialsDO.Salt;

            return(oUserCredentials);
        }