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());
}
}
internal void PayrollSendLoad(SqlConnection myConn, SqlConnection BConn, clsBL.clsBL classBL, clsTable.clsTable classTable, clsTableFormulas classTableFormulas, clsMain.clsMain Main, string section)
{
if (section == "MANUAL")
{
globalSection = section;
Base = Main;
TBFormulas = classTableFormulas;
TB = classTable;
BusinessLanguage = classBL;
tstConn = myConn;
BaseConn = BConn;
txtBussUnit.Text = BusinessLanguage.BussUnit + " - " + BusinessLanguage.Region;
txtBussUnit.Enabled = false;
cboPayrollGroup.Text = TB.TBName.Trim();
DateTime today = DateTime.Today;
strDay = strDay.Substring(0, 2 - today.Day.ToString().Trim().Length) + today.Day.ToString().Trim();
strMonth = strMonth.Substring(0, 2 - today.Month.ToString().Trim().Length) + today.Month.ToString().Trim();
cboMiningType.Text = BusinessLanguage.MiningType;
cboBonusType.Text = BusinessLanguage.BonusType; //amp
cboSection.Text = globalSection;
earnCode = TB.createDataTableWithAdapterSelectAll(Base.DBConnectionString, "EARNINGSCODES", " Where Tablename = 'MANUALPAY'"); //amp
List<string> employeeType = TB.loadDistinctValuesFromColumn(earnCode, "EMPLOYEETYPE");
foreach (string s in employeeType)
{
cboEmployeeType.Items.Add(s.ToString().Trim());
}
txtPeriod.Text = Base.Period;
cboPayRollInd.Enabled = false;
cboEarningsCode.Enabled = false;
cboMiningType.Enabled = false;
cboBonusType.Enabled = false;
cboSection.Enabled = false;
btnGenerate.Visible = false;
}
else
{
btnManual.Visible = false;
globalSection = section;
Base = Main;
TBFormulas = classTableFormulas;
TB = classTable;
BusinessLanguage = classBL;
tstConn = myConn;
BaseConn = BConn;
txtBussUnit.Text = BusinessLanguage.BussUnit + " - " + BusinessLanguage.Region;
txtBussUnit.Enabled = false;
cboPayrollGroup.Text = TB.TBName.Trim();
DateTime today = DateTime.Today;
strDay = strDay.Substring(0, 2 - today.Day.ToString().Trim().Length) + today.Day.ToString().Trim();
strMonth = strMonth.Substring(0, 2 - today.Month.ToString().Trim().Length) + today.Month.ToString().Trim();
cboMiningType.Text = BusinessLanguage.MiningType;
cboBonusType.Text = BusinessLanguage.BonusType;
cboSection.Text = globalSection;
//dt = Base.GetDataByRegion(BusinessLanguage.Region, Base.DBConnectionString);
earnCode = TB.createDataTableWithAdapterSelectAll(Base.DBConnectionString, "EARNINGSCODES", "Where Tablename != 'MANUALPAY'");
List<string> employeeType = TB.loadDistinctValuesFromColumn(earnCode, "EMPLOYEETYPE");
foreach (string s in employeeType)
{
cboEmployeeType.Items.Add(s.ToString().Trim());
}
txtPeriod.Text = Base.Period;
cboPayRollInd.Enabled = false;
cboEarningsCode.Enabled = false;
cboMiningType.Enabled = false;
cboBonusType.Enabled = false;
cboSection.Enabled = false;
}
}
