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.";
}
}
