public void getPartINFO(int inHouse, int outsourced, string companyName, int machineID)
{
if (inHouse == 1)
{
house = true;
Inhouse inHouseINFO = new Inhouse();
inHouseINFO.setInhouse(inHouse);
inHouseINFO.setMachineID(machineID);
inHouseINFO.setoutsourced(outsourced);
//return inHouseINFO;
info = inHouseINFO;
}
else
{
house = false;
Outsourced outSourceINFO = new Outsourced();
outSourceINFO.setInhouse(inHouse);
outSourceINFO.setoutsourced(outsourced);
outSourceINFO.setCompanyName(companyName);
infoO = outSourceINFO;
}
}
public ModifyPart(int partID)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
variableChange();
modifyPart.setPartID(partID);
SqlConnection con = new System.Data.SqlClient.SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB; AttachDbFilename=" + Application.StartupPath + "\\DB.mdf; Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select * from partTable WHERE partID = @partID";
cmd.Parameters.AddWithValue("@partID", partID);
String ID;
String name;
String price;
String inStock;
String min;
String max;
SqlDataReader rdr = cmd.ExecuteReader();
// Fill the strings with the values retrieved, convert to types as needed
while (rdr.Read())
{
ID = rdr["partID"].ToString();
modifyPart.setPartID(Convert.ToInt32(ID));
idTextbox.Text = ID;
name = rdr["name"].ToString();
modifyPart.setName(name);
partNameTextbox.Text = name;
price = rdr["price"].ToString();
modifyPart.setPrice(Convert.ToDouble(price));
priceCostTextbox.Text = price;
inStock = rdr["inStock"].ToString();
modifyPart.setinStock(Convert.ToInt32(inStock));
invTextbox.Text = inStock;
min = rdr["min"].ToString();
modifyPart.setMin(Convert.ToInt32(min));
minTextbox.Text = min;
max = rdr["max"].ToString();
modifyPart.setMax(Convert.ToInt32(max));
maxTextbox.Text = max;
inHouseValue = rdr["inHouse"].ToString();
//modifyInHouse.setInhouse(Convert.ToInt32(inHouseValue));
inHouseRadio.Checked = Convert.ToBoolean(Convert.ToInt32(inHouseValue));
outSourceValue = rdr["outSourced"].ToString();
// modifyInHouse.setInhouse(Convert.ToInt32(outSourceValue));
outsourcedRadio.Checked = Convert.ToBoolean(Convert.ToInt32(outSourceValue));
if (inHouseRadio.Checked == true)
{
machineID = rdr["machineID"].ToString();
modifyInHouse.setMachineID(Convert.ToInt32(machineID));
variableTextbox.Text = machineID;
}
else
{
companyName = rdr["companyName"].ToString();
//modifyInHouse.setMachineID(Convert.ToInt32(machineID));
variableTextbox.Text = companyName;
}
}
con.Close();
}