static Home()
{
dsNBD = new NBDDataSet();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
WORKERTableAdapter daWorker = new WORKERTableAdapter();
PROD_TEAMTableAdapter daProdTeam = new PROD_TEAMTableAdapter();
try
{
daProject.Fill(dsNBD.PROJECT);
daClient.Fill(dsNBD.CLIENT);
daWorker.Fill(dsNBD.WORKER);
daProdTeam.Fill(dsNBD.PROD_TEAM);
}
catch { }
}
static DailyWorkReport()
{
dsNBD = new NBDDataSet();
LABOUR_SUMMARYTableAdapter daLabSum = new LABOUR_SUMMARYTableAdapter();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
TASKTableAdapter daTask = new TASKTableAdapter();
LABOUR_REQUIREMENTTableAdapter daLabourReq = new LABOUR_REQUIREMENTTableAdapter();
PROD_TEAMTableAdapter daProdTeam = new PROD_TEAMTableAdapter();
try
{
daLabSum.Fill(dsNBD.LABOUR_SUMMARY);
daProject.Fill(dsNBD.PROJECT);
daTask.Fill(dsNBD.TASK);
daLabourReq.Fill(dsNBD.LABOUR_REQUIREMENT);
daProdTeam.Fill(dsNBD.PROD_TEAM);
}
catch { }
}
public void GetLabourInfo(int projectID, int type)
{
PROD_TEAMTableAdapter daProdTeam = new PROD_TEAMTableAdapter();
try { daProdTeam.FillBy(dsNBD.PROD_TEAM, projectID, type); }
catch { }
rows = dsNBD.PROD_TEAM.Select();
foreach (DataRow row in rows)
{
if (type == 2)
{
ddlDesign.SelectedValue = row.ItemArray[4].ToString() + " " + row.ItemArray[5].ToString();
txtDesignH.Text = row.ItemArray[9].ToString();
GetWorkerPriceByType("Designer", txtDesignC);
txtDesignTime.Text = row.ItemArray[10].ToString();
ddlDesignTasks.SelectedIndex = Convert.ToInt32(row.ItemArray[8].ToString());
txtDesignE.Text = CalcExtCost(txtDesignH.Text, txtDesignC.Text).ToString();
}
else if (type == 1)
{
ddlProduction.SelectedValue = row.ItemArray[4].ToString() + " " + row.ItemArray[5].ToString();
txtProductionH.Text = row.ItemArray[9].ToString();
GetWorkerPriceByType("Production Worker", txtProductionC);
txtProductionTime.Text = row.ItemArray[10].ToString();
ddlProdTasks.SelectedIndex = Convert.ToInt32(row.ItemArray[8].ToString());
txtProductionE.Text = CalcExtCost(txtProductionH.Text, txtProductionC.Text).ToString();
}
else if (type == 3)
{
ddlHEO.SelectedValue = row.ItemArray[4].ToString() + " " + row.ItemArray[5].ToString();
txtHeoH.Text = row.ItemArray[9].ToString();
GetWorkerPriceByType("Heavy Equipment Operator", txtHeoC);
txtHeoTime.Text = row.ItemArray[10].ToString();
ddlHEOTasks.SelectedIndex = Convert.ToInt32(row.ItemArray[8].ToString());
txtHeoE.Text = CalcExtCost(txtHeoH.Text, txtHeoC.Text).ToString();
}
}
}
