private void Sales_Orders_Load(object sender, EventArgs e)
{
txtdate.Text = System.DateTime.Today.ToString("M/d/yyyy");
DBItem s = new DBItem();
SqlDataReader DR;
DR = s.getName();
while (DR.Read())
{
cmbitemname.Items.Add(DR[0]);
}
}
private void cmbsorder_SelectedIndexChanged(object sender, EventArgs e)
{
int so_no = Convert.ToInt32(cmbsorder.SelectedItem);
DBSales_Item_reference si = new DBSales_Item_reference();
DR = si.getItems(so_no);
int itemno;
String itemname = "";
while (DR.Read())
{
itemno = Convert.ToInt32(DR[0]);
DBItem i = new DBItem();
DR2 = i.getName(itemno);
while (DR2.Read())
{
itemname = DR2[0].ToString();
}
cmbitemname.Items.Add(itemname);
}
}
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DBItem i = new DBItem();
int itemno = Convert.ToInt32(dataGridView2.CurrentRow.Cells["Item_No"].Value);
DR = i.getName(itemno);
while (DR.Read())
{
metroTextBox1.Text = DR[0].ToString();
}
int Qty = Convert.ToInt32(dataGridView2.CurrentRow.Cells["Item_Qty"].Value);
/* DBPurchases pu = new DBPurchases();
* DR = pu.getQty(metroTextBox1.Text.ToString());
* while (DR.Read())
* {
* Qty = Convert.ToInt32(DR[0]);
*
* } */
numQty.Maximum = Qty;
numQty.Value = Qty;
}