protected void btnCreateProj_Click(object sender, EventArgs e) { try { NBDDataSet.PROJECTRow r = dsNBD.PROJECT.NewPROJECTRow(); //r.ID = Convert.ToInt32(this.txtID.Text); r.projName = this.txtProjectName.Text; r.projSite = this.txtProjectSite.Text; r.projBidDate = DateTime.Parse(this.txtProjBidDate.Text); r.clientID = Convert.ToInt32(ddlClient.SelectedValue); r.designerID = 3; dsNBD.PROJECT.Rows.Add(r); PROJECTTableAdapter daProject = new PROJECTTableAdapter(); daProject.Update(dsNBD.PROJECT); ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('New Project Created!');window.location ='../Home.aspx';", true); } catch (Exception ex) { this.lblMessage.Text = "Unable to create new project." + ex.ToString(); } }
public void SubmitProductionPlan(bool approved, bool Unapproved) { // Project Row # int n = Convert.ToInt32(ddlProjects.SelectedValue) - 1; try { // Project Start Date dsNBD.PROJECT[n].projActStart = txtProjectStart.Text; if (approved == true) { dsNBD.PROJECT[n].projCurrentPhase = "P"; } if (Unapproved == true) { dsNBD.PROJECT[n].projCurrentPhase = "D"; } PROJECTTableAdapter daProjects = new PROJECTTableAdapter(); daProjects.Update(dsNBD.PROJECT); if (approved == true) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Production Plan Has Been Approved!');window.location ='../Home.aspx';", true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Work Report Has Been Marked As Unapproved!');window.location ='../Home.aspx';", true); } } 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."; } }