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());
}
}
private void UpdateClockedShifts()
{
clsMain.clsMain Base = new clsMain.clsMain();
#region Extract dates
//Load the section's first and last shift date
DateTime dteFSH = dateTimePicker1.Value;
DateTime dteLSH = dateTimePicker2.Value;
//Load the clocked shifts' from and end date
object tempObj = Base.ScalarQuery(Base.DBConnectionString, "select distinct datefrom from clockedshifts");
string tempdte = (string)tempObj;
string convdte = tempdte.Substring(0, 4) + "-" + tempdte.Substring(4, 2) + "-" + tempdte.Substring(6, 2);
DateTime dteDateFrom = Convert.ToDateTime(convdte.Trim());
tempObj = Base.ScalarQuery(Base.DBConnectionString, "select distinct dateend from clockedshifts");
tempdte = (string)tempObj;
convdte = tempdte.Substring(0, 4) + "-" + tempdte.Substring(4, 2) + "-" + tempdte.Substring(6, 2);
DateTime dteDateEnd = Convert.ToDateTime(convdte.Trim());
int intstart = dteDateFrom.Subtract(dteFSH).Days + 1;
int intend = dteLSH.Subtract(dteDateFrom).Days + 2;
#endregion
}
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;
}
}
