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