public List <VMItemSupplierItem> SelectItemSuppliersBySupplierID(int supplierID)
{
/// <summary>
/// Eric Bostwick
/// Created 2/26/2019
/// Gets list of itemsuppliers from itemsupplier table
/// using the supplierID
/// </summary>
/// <returns>
/// List of ItemSupplier Objects
/// </returns>
List <VMItemSupplierItem> itemSuppliers = new List <VMItemSupplierItem>();
var conn = DBConnection.GetDbConnection();
var cmdText = @"sp_select_itemsuppliers_by_supplierid"; //sp_retrieve_itemsuppliers_by_itemid
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SupplierID", supplierID);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
VMItemSupplierItem itemSupplier = new VMItemSupplierItem();
itemSupplier.ItemID = reader.GetInt32(reader.GetOrdinal("ItemID"));
itemSupplier.SupplierID = reader.GetInt32(reader.GetOrdinal("SupplierID"));
itemSupplier.PrimarySupplier = reader.GetBoolean(reader.GetOrdinal("PrimarySupplier"));
itemSupplier.LeadTimeDays = reader.GetInt32(reader.GetOrdinal("LeadTimeDays"));
itemSupplier.UnitPrice = (decimal)reader.GetSqlMoney(reader.GetOrdinal("UnitPrice"));
itemSupplier.Name = reader["Name"].ToString();
itemSupplier.Description = reader["Description"].ToString();
itemSupplier.ItemSupplierActive = reader.GetBoolean(reader.GetOrdinal("Active"));
itemSupplier.ItemType = reader["ItemTypeID"].ToString();
itemSupplier.OnHandQty = reader.GetInt32(reader.GetOrdinal("OnHandQty"));
itemSupplier.ReorderQty = reader.GetInt32(reader.GetOrdinal("ReOrderQty"));
itemSupplier.SupplierItemID = reader.GetInt32(reader.GetOrdinal("SupplierItemID"));
itemSuppliers.Add(itemSupplier);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(itemSuppliers);
}
/// <summary>
/// Eric Bostwick
/// 2/27/2019
/// Double click the grid to edit the line
/// It will remove the item from the grid so it can be readded
/// the item combo box
/// </summary>
private void DgOrderLines_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
_supplierOrderLine = (SupplierOrderLine)dgOrderLines.SelectedItem;
_supplierOrderLines.Remove(_supplierOrderLine);
dgOrderLines.Items.Refresh();
_itemSuppliers = _supplierOrderManager.RetrieveAllItemSuppliersBySupplierID(_supplier.SupplierID);
_itemSupplier = _itemSuppliers.Find(s => s.ItemID == _supplierOrderLine.ItemID);
txtUnitPrice.Text = _supplierOrderLine.UnitPrice.ToString();
this.txtOrderQuantity.Text = _supplierOrderLine.OrderQty.ToString();
this.lblItemDescription.Visibility = Visibility.Visible;
this.txtItemDescription.Visibility = Visibility.Visible;
this.lblOrderQty.Visibility = Visibility.Visible;
this.txtOrderQuantity.Visibility = Visibility.Visible;
this.lblUnitPrice.Visibility = Visibility.Visible;
this.txtUnitPrice.Visibility = Visibility.Visible;
this.txtUnitPrice.IsReadOnly = true;
this.txtExtendedPrice.Visibility = Visibility.Visible;
this.lblExtendedPrice.Visibility = Visibility.Visible;
this.dgOrderLines.Visibility = Visibility.Visible;
}
/// <summary>
/// Eric Bostwick
/// 2/27/2019
/// Sets the local item variable based upon the selection from
/// the item combo box
/// </summary>
private void SetSelectedItemSupplier(string itemSelected)
{
int itemID = int.Parse(itemSelected.Substring(0, 6));
_itemSupplier = _itemSuppliers.Find(i => i.ItemID == itemID);
}
