static ViewDesignBid()
{
dsNBD = new NBDDataSet();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
TASKTableAdapter daTask = new TASKTableAdapter();
WORKER_TYPETableAdapter daWorkerType = new WORKER_TYPETableAdapter();
MATERIALTableAdapter daMaterial = new MATERIALTableAdapter();
INVENTORYTableAdapter daInventory = new INVENTORYTableAdapter();
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
LABOUR_SUMMARYTableAdapter daLabourSummary = new LABOUR_SUMMARYTableAdapter();
try
{
daProject.Fill(dsNBD.PROJECT);
daTask.Fill(dsNBD.TASK);
daWorkerType.Fill(dsNBD.WORKER_TYPE);
daMaterial.Fill(dsNBD.MATERIAL);
daInventory.Fill(dsNBD.INVENTORY);
daMaterialReq.Fill(dsNBD.MATERIAL_REQ);
daClient.Fill(dsNBD.CLIENT);
daLabourSummary.Fill(dsNBD.LABOUR_SUMMARY);
}
catch { }
}
static ProjectAdminReportApproval()
{
dsNBD = new NBDDataSet();
PROJECTTableAdapter daProjects = new PROJECTTableAdapter();
LABOUR_SUMMARYTableAdapter daLabourSummary = new LABOUR_SUMMARYTableAdapter();
try
{
daProjects.Fill(dsNBD.PROJECT);
daLabourSummary.Fill(dsNBD.LABOUR_SUMMARY);
}
catch { }
}
static NewProject()
{
dsNBD = new NBDDataSet();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
try
{
daClient.Fill(dsNBD.CLIENT);
daProject.Fill(dsNBD.PROJECT);
}
catch { }
}
//List<string> controlIDList = new List<string>(); //List to store Control IDs
//int counter = 0;
//protected override void LoadViewState(object savedState) //LoadViewState must come before Page_Load
//{
// base.LoadViewState(savedState);
// controlIDList = (List<string>)ViewState["controlIDList"]; //Retrieving stored control ID
// foreach (string Id in controlIDList)
// {
// counter++;
// List<TextBox> txts = new List<TextBox>();
// List<PlaceHolder> phs = new List<PlaceHolder>() { phHTDTask, phHTDDate, phHTDHours, phEHTask,
// phEHDate, phEHHours};
// CreateTextboxes(txts, phs.Count());
// AddTextboxes(Id, phs, txts, false);
// }
//}
////Add Hours to Date Button
//protected virtual void btnAddHTD_Click(object sender, EventArgs e)
//{
// counter++;
// List<TextBox> txts = new List<TextBox>();
// List<PlaceHolder> phs = new List<PlaceHolder>() { phHTDTask, phHTDDate, phHTDHours};
// CreateTextboxes(txts, phs.Count());
// foreach (PlaceHolder p in phs)
// AddTextboxes(p.ID, phs, txts, true);
// ViewState["controlIDList"] = controlIDList; //Storing ID of newly generated textboxes into view state
//}
////Add Estimated Hours to Date button
//protected void btnAddEH_Click(object sender, EventArgs e)
//{
// counter++;
// List<TextBox> txts = new List<TextBox>();
// List<PlaceHolder> phs = new List<PlaceHolder>() { phEHTask, phEHDate, phEHHours};
// CreateTextboxes(txts, phs.Count());
// foreach (PlaceHolder p in phs)
// AddTextboxes(p.ID, phs, txts, true);
// ViewState["controlIDList"] = controlIDList; //Storing ID of newly generated textboxes into view state
//}
//public void CreateTextboxes(List<TextBox> txts, int txtNumber)
//{
// TextBox[] textboxes = new TextBox[txtNumber];
// for (int i = 0; i < txtNumber; i++)
// {
// textboxes[i] = new TextBox();
// }
// foreach (TextBox t in textboxes)
// {
// txts.Add(t);
// }
//}
//public void AddTextboxes(string Id, List<PlaceHolder> phs, List<TextBox> txts, bool btn)
//{
// for (int i = 0; i < phs.Count(); i++)
// {
// if (Id.Contains(phs[i].ID.Substring(2)))
// {
// txts[i].ID = Id;
// if (btn == true)
// txts[i].ID += counter.ToString();
// LiteralControl lineBreak = new LiteralControl("<br /><br />");
// phs[i].Controls.Add(lineBreak);
// phs[i].Controls.Add(txts[i]);
// phs[i].Controls.Add(lineBreak);
// if (btn == true)
// {
// controlIDList.Add(txts[i].ID);
// }
// }
//}
//}
static DesignBudget()
{
//load data at the beginning of the session
dsNBD = new NBDDataSet();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
try
{
daClient.Fill(dsNBD.CLIENT);
daProject.Fill(dsNBD.PROJECT);
}
catch { }
}
static ViewClients()
{
//load data at the beginning of the session
dsClient = new NBDViewClientDataSet();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
try
{
daClient.Fill(dsClient.CLIENT);
daProject.Fill(dsClient.PROJECT);
}
catch { }
}
static ProductionPlanApproval()
{
dsNBD = new NBDDataSet();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
TASKTableAdapter daTask = new TASKTableAdapter();
WORKER_TYPETableAdapter daWorkerType = new WORKER_TYPETableAdapter();
MATERIALTableAdapter daMaterial = new MATERIALTableAdapter();
try
{
daProject.Fill(dsNBD.PROJECT);
daTask.Fill(dsNBD.TASK);
daWorkerType.Fill(dsNBD.WORKER_TYPE);
daMaterial.Fill(dsNBD.MATERIAL);
}
catch { }
}
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 { }
}
protected void BtnShowBid_Click(object sender, EventArgs e)
{
this.lstbidInfo.Items.Clear();
try
{
daproj.Fill(dsnbd.PROJECT, Convert.ToInt32(Session["Data"]));
}
catch { }
foreach (DataRow r in dsnbd.PROJECT)
{
this.lstbidInfo.Items.Add("Project Name:" + r.ItemArray[1].ToString() + " " + "Project Site:" + r.ItemArray[2].ToString() + " " + "Bid Date:" + r.ItemArray[3].ToString());
}
this.lstbidInfo.Visible = true;
this.btnBidReport.Visible = true;
}
static DesignBid()
{
//load data at the beginning of the session
dsNBD = new NBDDataSet();
CLIENTTableAdapter daClient = new CLIENTTableAdapter();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
MATERIAL_REQTableAdapter daMatReq = new MATERIAL_REQTableAdapter();
MATERIALTableAdapter daMaterial = new MATERIALTableAdapter();
try
{
daClient.Fill(dsNBD.CLIENT);
daProject.Fill(dsNBD.PROJECT);
daMatReq.Fill(dsNBD.MATERIAL_REQ);
daMaterial.Fill(dsNBD.MATERIAL);
}
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 { }
}
private void LoadProject()
{
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
try { daProject.Fill(dsNBD.PROJECT); }
catch { }
rows = dsNBD.PROJECT.Select();
foreach (DataRow p in rows)
{
if (Convert.ToInt32(p.ItemArray[0].ToString()) == 2)
{
int id = Convert.ToInt32(p.ItemArray[0]);
double actBudget = Convert.ToDouble(p.ItemArray[9]);
double estBudget = Convert.ToDouble(p.ItemArray[8]);
double difBudget = (actBudget - estBudget);
DateTime estEnd = Convert.ToDateTime(p.ItemArray[5]);
DateTime today = DateTime.Now;
double difDate = (today - estEnd).TotalDays;
lblProject.Text += p.ItemArray[1].ToString();
lblStart.Text += p.ItemArray[6].ToString();
lblEnd.Text += p.ItemArray[5].ToString();
lblBudget.Text += "$" + actBudget.ToString() + "/$" + estBudget.ToString() + " budget spent";
lblTeam.Text += "5 workers in project team";
if ((actBudget / estBudget) > 1)
{
lblBudget.Text += " [$" + difBudget.ToString("#.##") + " OVER BUDGET]";
lblBudget.ForeColor = System.Drawing.Color.Red;
}
if ((today > estEnd))
{
lblEnd.Text += " [" + Math.Floor(difDate) + " DAYS OVERDUE]";
lblEnd.ForeColor = System.Drawing.Color.Red;
}
}
}
}
static ProductionPlan()
{
// Set up data adapters/data set
dsNBD = new NBDDataSet();
PROJECTTableAdapter daProject = new PROJECTTableAdapter();
TASKTableAdapter daTask = new TASKTableAdapter();
WORKER_TYPETableAdapter daWorkerType = new WORKER_TYPETableAdapter();
MATERIALTableAdapter daMaterial = new MATERIALTableAdapter();
INVENTORYTableAdapter daInventory = new INVENTORYTableAdapter();
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
try
{
daProject.Fill(dsNBD.PROJECT);
daTask.Fill(dsNBD.TASK);
daWorkerType.Fill(dsNBD.WORKER_TYPE);
daMaterial.Fill(dsNBD.MATERIAL);
daInventory.Fill(dsNBD.INVENTORY);
daMaterialReq.Fill(dsNBD.MATERIAL_REQ);
}
catch { }
}