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)); }