private void btnAddItem_Click(object sender, RoutedEventArgs e) { var fb = this.DataContext as FormedBasket; 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; } FormedBasket_Item s = new FormedBasket_Item(); s.RelatedItem = i; s.Quantity = 1; (dgSelectedItems.ItemsSource as List <FormedBasket_Item>).Add(s); (lbMainItems.ItemsSource as List <Item>).Remove(i); RefreshPanel(); }
public static bool UpdateData(FormedBasket x) { BaseDataBase._NonQuery("delete from FormedBasket_Item where FormedBasket_Item.FormedBasketID = " + x.Id); bool b = BaseDataBase._StoredProcedure("sp_Update_FormedBasket" , new SqlParameter("@Id", x.Id) , new SqlParameter("@Name", x.Name) , new SqlParameter("@IsActive", x.IsActive) , new SqlParameter("@IsUrgent", x.IsUrgent) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)); foreach (var item in x.FormedBasketItems) { if (item.FormedBasket == null) { item.FormedBasket = x; } FormedBasket_Item.InsertData(item); } if (x.id.HasValue) { FormedBasket_Sector.SaveFormedBasketSectors(x); } return(b); }
public static bool DeleteData(FormedBasket_Item x) { FormedBasket_Item.UpdateData(x); return(BaseDataBase._StoredProcedure("sp_Delete_FormedBasket_Item" , new SqlParameter("@FormedBasketID", x.FormedBasket.Id) , new SqlParameter("@ItemID", x.RelatedItem.Id))); }
public static bool UpdateData(FormedBasket_Item x) { return(BaseDataBase._StoredProcedure("sp_Update_FormedBasket_Item" , new SqlParameter("@FormedBasketID", x.FormedBasket.Id) , new SqlParameter("@ItemID", x.RelatedItem.Id) , new SqlParameter("@Quantity", x.Quantity) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID))); }
private void btnDelItem_Click(object sender, RoutedEventArgs e) { if (dgSelectedItems.SelectedIndex != -1) { txtSearch.Text = string.Empty; FormedBasket_Item s = dgSelectedItems.SelectedItem as FormedBasket_Item; var i = s.RelatedItem; (lbMainItems.ItemsSource as List <Item>).Add(i); (dgSelectedItems.ItemsSource as List <FormedBasket_Item>).Remove(s); RefreshPanel(); } }
internal static List <FormedBasket> GetFormedBasketByFamilyID(int familyID) { List <FormedBasket> xx = new List <FormedBasket>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_All_FormedBasketByFamilyID", con); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.Add(new SqlParameter("@FamilyID", familyID)); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { FormedBasket x = new FormedBasket(); if (!(rd["Id"] is DBNull)) { x.Id = int.Parse(rd["Id"].ToString()); } x.Name = rd["Name"].ToString(); if (!(rd["IsActive"] is DBNull)) { x.IsActive = bool.Parse(rd["IsActive"].ToString()); } if (!(rd["IsUrgent"] is DBNull)) { x.IsUrgent = bool.Parse(rd["IsUrgent"].ToString()); } x.Notes = rd["Notes"].ToString(); if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } x.FormedBasketItems = FormedBasket_Item.GetAllBasket_ItemByBasket(x); xx.Add(x); } rd.Close(); } catch { xx = null; } finally { con.Close(); } return(xx); }
public static FormedBasket GetItemByID(int id) { FormedBasket x = new FormedBasket(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_ID_FormedBasket", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@ID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["Id"] is DBNull)) { x.Id = int.Parse(rd["Id"].ToString()); } x.Name = rd["Name"].ToString(); if (!(rd["IsActive"] is DBNull)) { x.IsActive = bool.Parse(rd["IsActive"].ToString()); } if (!(rd["IsUrgent"] is DBNull)) { x.IsUrgent = bool.Parse(rd["IsUrgent"].ToString()); } x.Notes = rd["Notes"].ToString(); if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } x.FormedBasketItems = FormedBasket_Item.GetAllBasket_ItemByBasket(x); } rd.Close(); } catch { x = null; } finally { con.Close(); } return(x); }
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); }
public static List <FormedBasket_Item> GetAllBasket_ItemByBasket(FormedBasket FormedBasket) { List <FormedBasket_Item> xx = new List <FormedBasket_Item>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_All_FormedBasket_Item_ByFormedBasketID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr1 = new SqlParameter("@FormedBasketID", FormedBasket.Id); com.Parameters.Add(pr1); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { FormedBasket_Item x = new FormedBasket_Item(); x.FormedBasket = FormedBasket; 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()); } xx.Add(x); } rd.Close(); } catch { xx = null; } finally { con.Close(); } return(xx); }
public static bool InsertData(FormedBasket x) { x.Id = BaseDataBase._StoredProcedureReturnable("sp_Add_FormedBasket" , new SqlParameter("@Id", System.Data.SqlDbType.Int) , new SqlParameter("@Name", x.Name) , new SqlParameter("@IsActive", x.IsActive) , new SqlParameter("@IsUrgent", x.IsUrgent) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)); foreach (var item in x.FormedBasketItems) { if (item.FormedBasket == null) { item.FormedBasket = x; FormedBasket_Item.InsertData(item); } } if (x.id.HasValue) { FormedBasket_Sector.SaveFormedBasketSectors(x); } return(x.Id.HasValue); }