private void btnAddItem_Click(object sender, RoutedEventArgs e)
{
Item i;
if (lbItemsFiltered.Visibility == Visibility.Visible)
{
if (lbItemsFiltered.SelectedIndex == -1)
{
return;
}
var iFiltered = lbItemsFiltered.SelectedItem as Item;
i = (lbMainItems.ItemsSource as List <Item>).Where(x => x.Id == iFiltered.Id).FirstOrDefault();
txtSearch.Text = string.Empty;
}
else
{
if (lbMainItems.SelectedIndex == -1)
{
return;
}
i = lbMainItems.SelectedItem as Item;
}
Basket_Item bi = new Basket_Item();
bi.RelatedItem = i;
bi.Quantity = 1;
(dgSelectedItems.ItemsSource as List <Basket_Item>).Add(bi);
(lbMainItems.ItemsSource as List <Item>).Remove(i);
RefreshPanel();
}
public static bool DeleteData(Basket_Item x)
{
Basket_Item.UpdateData(x);
return(BaseDataBase._StoredProcedure("sp_Delete_Basket_Item"
, new SqlParameter("@BasketID", x.Basket.Id)
, new SqlParameter("@ItemID", x.RelatedItem.Id)));
}
public static bool UpdateData(Basket_Item x)
{
return(BaseDataBase._StoredProcedure("sp_Update_Basket_Item"
, new SqlParameter("@BasketID", x.Basket.Id)
, new SqlParameter("@ItemID", x.RelatedItem.Id)
, new SqlParameter("@Quantity", x.Quantity)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)));
}
public static Basket_Item GetBasket_ItemByID(int BasketID, int ItemID)
{
Basket_Item x = new Basket_Item();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_ID_Basket_Item", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr1 = new SqlParameter("@BasketID", BasketID);
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["BasketID"] is DBNull))
{
x.Basket = Item.GetItemByID(int.Parse(rd["BasketID"].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);
}
//no need to it
private static List <Basket_Item> GetAllBasket_ItemByItem(Item Item)
{
List <Basket_Item> xx = new List <Basket_Item>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_All_Basket_Item_ByItem", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr1 = new SqlParameter("@ItemID", Item.Id);
com.Parameters.Add(pr1);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
Basket_Item x = new Basket_Item();
if (!(rd["BasketID"] is DBNull))
{
x.Basket = Item.GetItemByID(int.Parse(rd["BasketID"].ToString()));
}
x.RelatedItem = Item;
if (!(rd["Quantity"] is DBNull))
{
x.Quantity = double.Parse(rd["Quantity"].ToString());
}
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
xx.Add(x);
}
rd.Close();
}
catch
{
xx = null;
}
finally
{
con.Close();
}
return(xx);
}
private void btnDelItem_Click(object sender, RoutedEventArgs e)
{
if (dgSelectedItems.SelectedIndex != -1)
{
txtSearch.Text = string.Empty;
Basket_Item bi = dgSelectedItems.SelectedItem as Basket_Item;
var i = bi.RelatedItem;
(lbMainItems.ItemsSource as List <Item>).Add(i);
(dgSelectedItems.ItemsSource as List <Basket_Item>).Remove(bi);
RefreshPanel();
if (bi != null)
{
DeletedItems.Add(bi);
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var i = this.DataContext as Item;
if (i.IsValidate())
{
if (!i.Id.HasValue)
{
if (Item.InsertData(i))
{
MyMessage.InsertMessage();
}
}
else
{
if (Item.UpdateData(i))
{
MyMessage.UpdateMessage();
}
}
foreach (var item in i.BasketItems)
{
if (item.Basket == null)
{
item.Basket = i;
Basket_Item.InsertData(item);
}
else
{
Basket_Item.UpdateData(item);
}
}
foreach (var item in DeletedItems)
{
Basket_Item.UpdateData(item);
Basket_Item.DeleteData(item);
}
}
}
public void GetBasketItems()
{
this.BasketItems = Basket_Item.GetAllBasket_ItemByBasket(this);
}
