private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var comboBox = sender as ComboBox;
if (comboBox.SelectedItem != null)
{
LVIssuance item = dgSubject.SelectedItem as LVIssuance;
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
int maxQty = 0;
using (SqlCeCommand cmd = new SqlCeCommand("SELECT qty from ApparatusInventory where name = @name and manuf = @manuf and (size IS null or size = @size)", conn))
{
cmd.Parameters.AddWithValue("@size", item.size);
cmd.Parameters.AddWithValue("@manuf", item.manuf);
cmd.Parameters.AddWithValue("@name", item.inventName);
using (DbDataReader dr = cmd.ExecuteResultSet(ResultSetOptions.Scrollable))
{
if (dr.HasRows)
{
while (dr.Read())
{
int qtyIndex = dr.GetOrdinal("qty");
maxQty = Convert.ToInt32(dr.GetValue(qtyIndex));
}
}
}
if (item.qty > maxQty)
{
var found = items.FirstOrDefault(x => (x.inventName == item.inventName) && (x.manuf == item.manuf) && ((x.size == item.size) || (x.size == null)));
if (found != null)
{
MessageBox.Show("Item " + item.inventName + " size: " + item.size + " manufacturer: " + item.manuf + " has low stocks, quantity has been set to the quantity of available stocks");
found.qty = maxQty;
}
}
}
}
}
private void dgList_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
LVIssuance student = dgList.SelectedItem as LVIssuance;
this.NavigationService.Navigate(new IssuanceRecord(student.lockNo, student.sect, student.sched, student.issuedDate, student.issuedBy, cmbSubject.Text));
}
