private void UpdateWh2View()
{
var command = new OracleCommand("SELECT good_id, good_count FROM WAREHOUSE2");
command.Connection = OracleDbManager.GetConnection();
var oraReader = command.ExecuteReader();
wh2Items = new List <WhItem>();
if (oraReader.HasRows)
{
while (oraReader.Read())
{
WhItem whItem = new WhItem();
whItem.Name = goodsDictionary[oraReader.GetInt32(0)];
whItem.Amount = oraReader.GetInt32(1);
wh2Items.Add(whItem);
}
}
List <string> goodsNames = new List <string>();
foreach (var good in goods)
{
goodsNames.Add(good.Name);
}
wh2DataList.ItemsSource = wh2Items;
wh2GoodCmbBox.ItemsSource = goodsNames;
}
private void Wh1GoodDescriptionChanged(string goodName)
{
WhItem whItem = wh1DataList.SelectedItem as WhItem;
int count;
foreach (var good in wh1Items)
{
if (good.Name.Equals(goodName))
{
addToWh1Btn.Visibility = Visibility.Hidden;
deleteFromWh1Btn.Visibility = Visibility.Visible;
if (!int.TryParse(wh1GoodCountTxtBox.Text, out count))
{
updatePositionWh1Btn.Visibility = Visibility.Hidden;
}
else
{
updatePositionWh1Btn.Visibility = Visibility.Visible;
}
return;
}
}
updatePositionWh1Btn.Visibility = Visibility.Hidden;
deleteFromWh1Btn.Visibility = Visibility.Hidden;
if (goodName == "" || wh1GoodCountTxtBox.Text == "" || !int.TryParse(wh1GoodCountTxtBox.Text, out count))
{
addToWh1Btn.Visibility = Visibility.Hidden;
}
else
{
addToWh1Btn.Visibility = Visibility.Visible;
}
}
private void OnWh2SelectionChanged(object sender, SelectionChangedEventArgs e)
{
WhItem whItem = wh2DataList.SelectedItem as WhItem;
if (whItem != null)
{
updatePositionWh2Btn.Visibility = Visibility.Visible;
addToWh2Btn.Visibility = Visibility.Hidden;
deleteFromWh2Btn.Visibility = Visibility.Visible;
wh2GoodCmbBox.Text = whItem.Name;
wh2GoodCountTxtBox.Text = whItem.Amount.ToString();
}
else
{
updatePositionWh2Btn.Visibility = Visibility.Hidden;
addToWh2Btn.Visibility = Visibility.Hidden;
deleteFromWh2Btn.Visibility = Visibility.Hidden;
wh2GoodCmbBox.Text = "";
wh2GoodCountTxtBox.Text = "";
}
}
