/// <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());
}