//Add materials to the prodcution plan
protected void btnAddMaterialProduction_Click(object sender, EventArgs e)
{
try
{
//Create instance of material_req
MATERIAL_REQ mr = new MATERIAL_REQ();
//Gather all information needed to create material_req
mr.projectID = Convert.ToInt32(this.ddlProjectID.SelectedValue);
mr.inventoryID = this.ddlMaterialDescProduction.SelectedIndex + 1;
mr.mreqEstQty = Convert.ToInt16(this.txtQtyEstProduction.Text);
mr.mreqDeliver = Convert.ToDateTime(this.txtMaterialDeliverProduction.Text);
mr.mreqInstall = Convert.ToDateTime(this.txtMaterialInstallProduction.Text);
//Save material_req to database
db.MATERIAL_REQ.Add(mr);
db.SaveChanges();
//Refresh Gridview
gvMaterialReqProduction.DataBind();
}
catch
{
lblErrormsgProductionMaterials.Text = "Something went wrong!";
}
//Set textboxes and dropdownlists back to default
this.ddlMaterialDescProduction.SelectedIndex = 0;
this.txtQtyEstProduction.Text = "";
this.txtMaterialDeliverProduction.Text = "";
this.txtMaterialInstallProduction.Text = "";
}
//Adds materials_req for design bid
protected void btnAddMaterial_Click(object sender, EventArgs e)
{
try
{
//Add instance for material_req
MATERIAL_REQ mr = new MATERIAL_REQ();
//gather information to insert a new material_req for specefic project
mr.projectID = Convert.ToInt32(this.ddlProjectID.SelectedValue);
mr.inventoryID = this.ddlMaterialDescDesign.SelectedIndex + 1;
mr.mreqEstQty = Convert.ToInt16(this.txtQtyEstDesign.Text);
//add material_req to the database
db.MATERIAL_REQ.Add(mr);
db.SaveChanges();
//refresh the gridview
gvMaterialReqDesign.DataBind();
}
catch
{
lblErrormsgMaterialReqDesign.Text = "Something went wrong!";
}
//set the textboxes and dropdown back to defaults
ddlMaterialDescDesign.SelectedIndex = 0;
txtQtyEstDesign.Text = "";
}
protected void btnSubProductionMaterials_Click(object sender, EventArgs e)
{
try
{
//Create instance of materal_req with ID of textbox value
var mr = new MATERIAL_REQ { ID = Convert.ToInt32(txtSubProductionMaterials) };
//Attach records
db.MATERIAL_REQ.Attach(mr);
//Remove record
db.MATERIAL_REQ.Remove(mr);
db.SaveChanges();
//Refresh gridview
gvMaterialReqProduction.DataBind();
}
catch
{
lblErrormsgProductionMaterials.Text = "Please select a valid row to delete!";
}
//Set textbox back to default
txtSubProductionMaterials.Text = "";
}
