public SPOStatus(SPO spo, ListView listView1)
{
this.spo = spo;
this.lv = listView1;
InitializeComponent();
SPONo.Text = lv.SelectedItems[0].Text;
SupplierNo.Text = lv.SelectedItems[0].SubItems[1].Text;
CreationDate.Text = lv.SelectedItems[0].SubItems[2].Text;
EffectiveDate.Text = lv.SelectedItems[0].SubItems[3].Text;
BuyerName.Text = lv.SelectedItems[0].SubItems[4].Text;
BillingAddress.Text = lv.SelectedItems[0].SubItems[5].Text;
BuyerAccount.Text = lv.SelectedItems[0].SubItems[6].Text;
RestNo.Text = lv.SelectedItems[0].SubItems[7].Text;
ExpectedDeliveryDate.Text = lv.SelectedItems[0].SubItems[8].Text;
TAC.Text = lv.SelectedItems[0].SubItems[9].Text;
MySqlConnection cnn = new MySqlConnection("server=code4cat.me; user id=jackysc; password=123456; database=procurement;SslMode=none");
cnn.Open();
MySqlDataAdapter getItem = new MySqlDataAdapter("SELECT * FROM SPOLines WHERE SPONo = '" + SPONo.Text + "'", cnn);
DataTable dt = new DataTable();
getItem.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
MySqlCommand getItemName = new MySqlCommand("SELECT ItemDescription FROM SupplierItem si, Item i WHERE si.ItemID = i.ItemID AND si.SupplierNo = '" + SupplierNo.Text + "' AND si.SupplierItemID ='" + dr["SupplierItemID"].ToString() + "'", cnn);
string itemName = getItemName.ExecuteScalar().ToString();
dataGridView1.Rows.Add(itemName, dr["Quantity"].ToString(), dr["UOM"].ToString(), dr["Price"].ToString());
}
SetReadonlyControls(groupBox1.Controls);
}
public SPOEdit(SPO spo, ListView listView1)
{
this.spo = spo;
this.lv = listView1;
InitializeComponent();
SPONo.Text = lv.SelectedItems[0].Text;
SupplierNo.Text = lv.SelectedItems[0].SubItems[1].Text;
CreationDate.Text = lv.SelectedItems[0].SubItems[2].Text;
EffectiveDate.Text = lv.SelectedItems[0].SubItems[3].Text;
BuyerName.Text = lv.SelectedItems[0].SubItems[4].Text;
BillingAddress.Text = lv.SelectedItems[0].SubItems[5].Text;
BuyerAccount.Text = lv.SelectedItems[0].SubItems[6].Text;
RestNo.Text = lv.SelectedItems[0].SubItems[7].Text;
ExpectedDeliveryDate.Text = lv.SelectedItems[0].SubItems[8].Text;
TAC.Text = lv.SelectedItems[0].SubItems[9].Text;
}
private void button2_Click(object sender, EventArgs e)
{
SPO SPO = new SPO(this);
SPO.ShowDialog();
}
