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(); } } }