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