public static FormedBasket_Item GetBasket_ItemByID(int FormedBasketID, int ItemID) { FormedBasket_Item x = new FormedBasket_Item(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_ID_FormedBasket_Item", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr1 = new SqlParameter("@FormedBasketID", FormedBasketID); com.Parameters.Add(pr1); SqlParameter pr2 = new SqlParameter("@ItemID", ItemID); com.Parameters.Add(pr2); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["FormedBasketID"] is DBNull)) { x.FormedBasket = FormedBasket.GetItemByID(int.Parse(rd["FormedBasketID"].ToString())); } if (!(rd["ItemID"] is DBNull)) { x.RelatedItem = Item.GetItemByID(int.Parse(rd["ItemID"].ToString())); } if (!(rd["Quantity"] is DBNull)) { x.Quantity = double.Parse(rd["Quantity"].ToString()); } if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } } rd.Close(); } catch { x = null; } finally { con.Close(); } return(x); }
private void cmboFormedBasket_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (IsLoaded && cmboFormedBasket.SelectedItem != null) { brdrBack.Visibility = Visibility.Collapsed; var id = (int)(cmboFormedBasket.SelectedItem as DataRowView)["Id"]; var fb = FormedBasket.GetItemByID(id); this.DataContext = null; lbMainItems.ItemsSource = null; dgSelectedItems.ItemsSource = null; this.DataContext = fb; dgSelectedItems.ItemsSource = new List <FormedBasket_Item>(); (dgSelectedItems.ItemsSource as List <FormedBasket_Item>).AddRange(fb.FormedBasketItems); lbMainItems.ItemsSource = (from x in Item.AllItems where !IsItemExist(x) select x).ToList <Item>(); RefreshPanel(); lbSectors.ItemsSource = null; lbSectors.ItemsSource = Sector.GetAllSectorByFormedBasketID(fb.Id.Value); } }