/// <summary> /// Get system code for language /// </summary> /// <param name="lang"></param> /// <param name="connString">DB comm str</param> /// <returns></returns> public static long GetLanguageCode(string lang, string connString) { using (var connection = new SqlConnection(connString)) { connection.Open(); var id = (long)SqlExecHelper.SqlExecScalar(connection, string.Format("select dbo.fnGetLanguageCode('{0}')", lang)); return(id); } }
static public string GetUserName(long id) { object result; using (var conn = new SqlConnection(m_ConnectionString)) { var strSQL = string.Format("SELECT TOP 1 strAccountName FROM tstUserTable WHERE idfUserID = {0}", id); conn.Open(); result = SqlExecHelper.SqlExecScalar(conn, strSQL); conn.Close(); } return(result.ToString()); }