internal void userAccessLoad(SqlConnection Conn,clsMain.clsMain Main,clsTable.clsTable clsTable,string usr,string Environment)
{
listBox1.Enabled = false;
listBox2.Enabled = false;
listBox3.Enabled = false;
BaseConn = Conn;
Base = Main;
TB = clsTable;
strUserid = usr;
strEnvironment = Environment;
DataTable userids = Base.SelectUserAccess(Base.BaseConnectionString);
lstNames = TB.loadDistinctValuesFromColumn(userids, "USERID");
foreach (string s in lstNames)
{
if (s != strUserid)
{
comboBox1.Items.Add(s.ToString().Trim());
}
}
//Fill listbox LEVEL1 with distict values
DataTable level1 = Base.SelectUserAccess(Base.BaseConnectionString);
lstNames = TB.loadDistinctValuesFromColumn(userids, "LEVEL1");
foreach (string s in lstNames)
{
listBox1.Items.Add(s.ToString().Trim());
}
}
internal void AuditLoad(string ConnString, string BConnString, clsBL.clsBL classBL, clsTable.clsTable classTable,
string section)
{
string globalSection = section;
TB = classTable;
BusinessLanguage = classBL;
DBConnString = ConnString;
BaseConnString = BConnString;
sectioncbo = section;
txtUserDetails.Text = BusinessLanguage.Userid + " - " + BusinessLanguage.Region + " - " + BusinessLanguage.BussUnit;
txtMiningType.Text = BusinessLanguage.MiningType;
txtBonusType.Text = BusinessLanguage.BonusType;
txtDatabaseName.Text = TB.DBName;
lstNames = TB.getAllFromSelectedTable(DBConnString, "AUDIT", "Tablename");
foreach (string s in lstNames)
{
cboTableName.Items.Add(s.Trim());
}
}