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 { }
}
public void FillProjectMaterialsByType(string p, string t)
{
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
try { daMaterialReq.FillBy(dsNBD.MATERIAL_REQ, Convert.ToInt32(p), t); }
catch { }
rows = dsNBD.MATERIAL_REQ.Select();
foreach (DataRow row in rows)
{
if (t == "Plant")
{
txtPlantQ.Text = row.ItemArray[3].ToString();
ddlPlant.SelectedValue = row.ItemArray[7].ToString();
txtPlantS.Text = row.ItemArray[8].ToString();
lblPlantSU.Text = " " + row.ItemArray[9].ToString();
txtPlantU.Text = row.ItemArray[10].ToString();
txtPlantD.Text = row.ItemArray[1].ToString();
txtPlantI.Text = row.ItemArray[2].ToString();
txtPlantE.Text = row.ItemArray[6].ToString();
int extCost = Convert.ToInt32(row.ItemArray[10]);
int qty = Convert.ToInt32(row.ItemArray[3]);
txtPlantE.Text = (extCost * qty).ToString();
}
else if (t == "Pottery")
{
txtPotteryQ.Text = row.ItemArray[3].ToString();
ddlPottery.SelectedValue = row.ItemArray[7].ToString();
txtPotteryS.Text = row.ItemArray[8].ToString();
lblPotterySU.Text = row.ItemArray[9].ToString();
txtPotteryU.Text = row.ItemArray[10].ToString();
txtPotteryD.Text = row.ItemArray[1].ToString();
txtPotteryI.Text = row.ItemArray[2].ToString();
txtPotteryE.Text = row.ItemArray[6].ToString();
int extCost = Convert.ToInt32(row.ItemArray[10]);
int qty = Convert.ToInt32(row.ItemArray[3]);
txtPotteryE.Text = (extCost * qty).ToString();
}
else if (t == "Materials")
{
txtMaterialQ.Text = row.ItemArray[3].ToString();
ddlMaterial.SelectedValue = row.ItemArray[7].ToString();
txtMaterialS.Text = row.ItemArray[8].ToString();
lblMaterialSU.Text = row.ItemArray[9].ToString();
txtMaterialU.Text = row.ItemArray[10].ToString();
txtMaterialD.Text = row.ItemArray[1].ToString();
txtMaterialI.Text = row.ItemArray[2].ToString();
txtMaterialE.Text = row.ItemArray[6].ToString();
int extCost = Convert.ToInt32(row.ItemArray[10]);
int qty = Convert.ToInt32(row.ItemArray[3]);
txtMaterialE.Text = (extCost * qty).ToString();
}
}
}
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 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 { }
}
public void SubmitProductionPlan()
{
if (ddlProjects.SelectedValue != "-2")
{
//PROJECT ID
int n = Convert.ToInt32(ddlProjects.SelectedValue) - 1;
try
{
//Project Start Date
dsNBD.PROJECT[n].projActStart = txtProjectStart.Text;
PROJECTTableAdapter daProjects = new PROJECTTableAdapter();
daProjects.Update(dsNBD.PROJECT);
}
catch { }
//PLANTS LISTS
List <string> PlantQ = new List <string>();
List <string> PlantDesc = new List <string>();
List <string> PlantD = new List <string>();
List <string> PlantI = new List <string>();
//POTTERY LISTS
List <string> PotteryQ = new List <string>();
List <string> PotteryDesc = new List <string>();
List <string> PotteryD = new List <string>();
List <string> PotteryI = new List <string>();
//MATERIALS LISTS
List <string> MaterialQ = new List <string>();
List <string> MaterialDesc = new List <string>();
List <string> MaterialD = new List <string>();
List <string> MaterialI = new List <string>();
//PLANTS
foreach (TextBox txt in phPlantsOgControls.Controls.OfType <TextBox>())
{
if (txt.ID.Contains("PlantQ"))
{
PlantQ.Add(txt.Text);
}
if (txt.ID.Contains("PlantD"))
{
PlantD.Add(txt.Text);
}
if (txt.ID.Contains("PlantI"))
{
PlantI.Add(txt.Text);
}
}
foreach (DropDownList ddl in phPlantsOgControls.Controls.OfType <DropDownList>())
{
PlantDesc.Add(ddl.SelectedValue);
}
for (int i = 0; i < PlantQ.Count(); i++)
{
//ADDS NEW ROW TO MATERIAL_REQ
NBDDataSet.MATERIAL_REQRow r = dsNBD.MATERIAL_REQ.NewMATERIAL_REQRow();
int matID = 0;
int invID = 0;
DataRow[] rowMatID = dsNBD.MATERIAL.Select("matDesc='" + PlantDesc[i] + "'");
foreach (DataRow row in rowMatID)
{
matID = Convert.ToInt32(row.ItemArray[0].ToString());
}
DataRow[] rowInvID = dsNBD.INVENTORY.Select("materialID=" + matID.ToString());
foreach (DataRow row in rowInvID)
{
invID = Convert.ToInt32(row.ItemArray[0].ToString());
}
r.projectID = Convert.ToInt32(ddlProjects.SelectedValue);
r.inventoryID = invID;
r.mreqDeliver = Convert.ToDateTime(PlantD[i]);
r.mreqInstall = Convert.ToDateTime(PlantI[i]);
r.mreqActQty = Convert.ToInt16(PlantQ[i]);
r.mreqEstQty = Convert.ToInt16(PlantQ[i]);
dsNBD.MATERIAL_REQ.Rows.Add(r);
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
daMaterialReq.Update(dsNBD.MATERIAL_REQ);
ScriptManager.RegisterStartupScript(this, this.GetType(),
"alert",
"alert('Production Plan Submitted!');window.location ='../Home.aspx';",
true);
}
//POTTERY
foreach (TextBox txt in phPotteryOgControls.Controls.OfType <TextBox>())
{
if (txt.ID.Contains("PotteryQ"))
{
PotteryQ.Add(txt.Text);
}
if (txt.ID.Contains("PotteryD"))
{
PotteryD.Add(txt.Text);
}
if (txt.ID.Contains("PotteryI"))
{
PotteryI.Add(txt.Text);
}
}
foreach (DropDownList ddl in phPotteryOgControls.Controls.OfType <DropDownList>())
{
PotteryDesc.Add(ddl.SelectedValue);
}
for (int i = 0; i < PotteryQ.Count(); i++)
{
NBDDataSet.MATERIAL_REQRow r = dsNBD.MATERIAL_REQ.NewMATERIAL_REQRow();
int matID = 0;
int invID = 0;
DataRow[] rowMatID = dsNBD.MATERIAL.Select("matDesc='" + PotteryDesc[i] + "'");
foreach (DataRow row in rowMatID)
{
matID = Convert.ToInt32(row.ItemArray[0].ToString());
}
DataRow[] rowInvID = dsNBD.INVENTORY.Select("materialID=" + matID.ToString());
foreach (DataRow row in rowInvID)
{
invID = Convert.ToInt32(row.ItemArray[0].ToString());
}
r.projectID = Convert.ToInt32(ddlProjects.SelectedValue);
r.inventoryID = invID;
r.mreqDeliver = Convert.ToDateTime(PotteryD[i]);
r.mreqInstall = Convert.ToDateTime(PotteryI[i]);
r.mreqActQty = Convert.ToInt16(PotteryQ[i]);
r.mreqEstQty = Convert.ToInt16(PotteryQ[i]);
dsNBD.MATERIAL_REQ.Rows.Add(r);
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
daMaterialReq.Update(dsNBD.MATERIAL_REQ);
lblMessage.Text = "Production Plan Submitted";
}
//MATERIALS
foreach (TextBox txt in phMaterialsOgControls.Controls.OfType <TextBox>())
{
if (txt.ID.Contains("MaterialQ"))
{
MaterialQ.Add(txt.Text);
}
if (txt.ID.Contains("MaterialD"))
{
MaterialD.Add(txt.Text);
}
if (txt.ID.Contains("MaterialI"))
{
MaterialI.Add(txt.Text);
}
}
foreach (DropDownList ddl in phMaterialsOgControls.Controls.OfType <DropDownList>())
{
MaterialDesc.Add(ddl.SelectedValue);
}
for (int i = 0; i < MaterialQ.Count(); i++)
{
NBDDataSet.MATERIAL_REQRow r = dsNBD.MATERIAL_REQ.NewMATERIAL_REQRow();
int matID = 0;
int invID = 0;
DataRow[] rowMatID = dsNBD.MATERIAL.Select("matDesc='" + MaterialDesc[i] + "'");
foreach (DataRow row in rowMatID)
{
matID = Convert.ToInt32(row.ItemArray[0].ToString());
}
DataRow[] rowInvID = dsNBD.INVENTORY.Select("materialID=" + matID.ToString());
foreach (DataRow row in rowInvID)
{
invID = Convert.ToInt32(row.ItemArray[0].ToString());
}
r.projectID = Convert.ToInt32(ddlProjects.SelectedValue);
r.inventoryID = invID;
r.mreqDeliver = Convert.ToDateTime(MaterialD[i]);
r.mreqInstall = Convert.ToDateTime(MaterialI[i]);
r.mreqActQty = Convert.ToInt16(MaterialQ[i]);
r.mreqEstQty = Convert.ToInt16(MaterialQ[i]);
dsNBD.MATERIAL_REQ.Rows.Add(r);
MATERIAL_REQTableAdapter daMaterialReq = new MATERIAL_REQTableAdapter();
daMaterialReq.Update(dsNBD.MATERIAL_REQ);
lblMessage.Text = "Production Plan Submitted";
}
}
else
{
lblMessage.Text = "Please select a project before attempting to submit.";
}
}