using System.Data.OleDb;
using System.Data;
using System;
partial class WebForm1 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e) {
}
public string GetToken(int iSecurityLevel) {
string sMode = GetSecurityTokenMode();
if (((sMode == "1")
|| ((sMode == "2")
|| (sMode == "3")))) {
string sSql = ("exec GetSecurityToken @SecurityLevel=" + iSecurityLevel);
return GetSingleSqlValue(sSql);
}
return "";
}
public string GetSecurityTokenMode() {
return GetSetting("SecurityTokenMode");
}
private string GetSetting(string sKey) {
string sSql = ("SELECT ParamValue FROM AppSettings WHERE Param =\'"
+ (sKey + "\'"));
return GetSingleSqlValue(sSql);
}
public string GetSingleSqlValue(string sSql) {
string sRet;
OleDbConnection cn = GetConnection();
OleDbCommand cmd = new OleDbCommand(sSql, cn);
try {
sRet = (string) cmd.ExecuteScalar();
}
catch (Exception ex) {
throw new Exception((ex.Message + ("; SQL: " + sSql)));
}
cn.Close();
return sRet;
}
private OleDbConnection GetConnection() {
string sFilePath = Server.MapPath("xmla.udl");
string sConnectionString = ("File Name=" + sFilePath);
OleDbConnection cn = new OleDbConnection(sConnectionString);
try {
cn.Open();
}
catch (Exception ex) {
throw new Exception(("Could not connect to the database. Please double click "
+ (sFilePath + " and point it to ReportPortal database. Make sure to save the connection and check the option to \'Al" +
"low saving password\'.")));
}
return cn;
}
public string GetUserList() {
string sSql = "SELECT UserId, UserName FROM AppUser";
OleDbCommand cmd = new OleDbCommand(sSql, GetConnection());
OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
// Details
while (dr.Read()) {
string sUserId = (string) dr.GetValue(dr.GetOrdinal("UserId"));
string sUserName = (string) dr.GetValue(dr.GetOrdinal("UserName"));
sb.Append(("<option value="
+ (sUserId + (">"
+ (sUserName + ("</option>" + "\r\n"))))));
}
dr.Close();
return sb.ToString();
}
}