private void btnAddEditActionSale_Click(object sender, RoutedEventArgs e) { ActionSaleDAO actionSaleDAO = new ActionSaleDAO(); if (mode == Mode.ADD) { ActionSale actionSale = new ActionSale() { Name = tbName.Text.Trim(), Discount = decimal.Parse(tbDiscount.Text.Trim()), StartDate = dpStartDate.SelectedDate.Value.Date, EndDate = dpEndDate.SelectedDate.Value.Date }; MainWindow.actionSalesList.Add(actionSale); actionSaleDAO.Add(actionSale); } else { actionSale.Name = tbName.Text.Trim(); actionSale.Discount = decimal.Parse(tbDiscount.Text.Trim()); actionSale.StartDate = dpStartDate.SelectedDate.Value.Date; actionSale.EndDate = dpEndDate.SelectedDate.Value.Date; actionSaleDAO.Update(actionSale); } Close(); }
private void tbSearchActions_TextChanged(object sender, TextChangedEventArgs e) { actionSalesView.Filter = x => { ActionSale asale = x as ActionSale; return(asale.Name.ToLower().Contains(tbSearchActions.Text.ToLower().Trim())); }; }
public ObservableCollection <Furniture> GetAll() { ObservableCollection <Furniture> furniture = new ObservableCollection <Furniture>(); string commandText = @"SELECT * FROM Furniture WHERE Deleted = 0"; //Treba mi SqlConnection, SqlCommand i DataReader using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["FurnitureStore"].ConnectionString)) { con.Open(); SqlCommand command = con.CreateCommand(); command.CommandText = commandText; SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { int id = (int)dataReader["Id"]; string name = (string)dataReader["Name"]; int quantity = (int)(Int16)dataReader["Quantity"]; decimal price = (decimal)dataReader["Price"]; int furnitureTypeId = (int)dataReader["FurnitureTypeId"]; FurnitureType furnitureType = new FurnitureTypeDAO().Get(furnitureTypeId); int actionSaleId; try { actionSaleId = (int)dataReader["ActionSaleId"]; } catch (Exception exc) { Console.WriteLine(exc.Message); actionSaleId = -1; } ActionSale actionSale = actionSaleId == -1 ? null : new ActionSaleDAO().Get(actionSaleId); bool deleted = (bool)dataReader["Deleted"]; furniture.Add(new Furniture() { Id = id, Name = name, Quantity = quantity, Price = price, FurnitureType = furnitureType, ActionSale = actionSale, Deleted = deleted }); } } dataReader.Close(); } return(furniture); }
private void btnDeleteActionSale_Click(object sender, RoutedEventArgs e) { ActionSale actionSale = (ActionSale)dgActionSales.SelectedItem; if (MessageBox.Show($"Are you sure you want to delete : {actionSale.Name} ?", "Deleting", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { actionSalesList.Remove(actionSale); actionSalesView.Refresh(); new ActionSaleDAO().Delete(actionSale); } }
public Furniture Get(int furnitureId) { string commandText = @"SELECT * FROM Furniture WHERE Id = @Id"; using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["FurnitureStore"].ConnectionString)) { con.Open(); SqlCommand command = con.CreateCommand(); command.CommandText = commandText; command.Parameters.Add(new SqlParameter("@Id", furnitureId)); using (SqlDataReader dataReader = command.ExecuteReader()) { if (dataReader.Read()) { int id = (int)dataReader["Id"]; string name = (string)dataReader["Name"]; int quantity = (int)(Int16)dataReader["Quantity"]; decimal price = (decimal)dataReader["Price"]; int furnitureTypeId = (int)dataReader["FurnitureTypeId"]; FurnitureType furnitureType = new FurnitureTypeDAO().Get(furnitureTypeId); int actionSaleId; try { actionSaleId = (int)dataReader["ActionSaleId"]; } catch (Exception exc) { Console.WriteLine(exc.Message); actionSaleId = -1; } ActionSale actionSale = actionSaleId == -1 ? null : new ActionSaleDAO().Get(actionSaleId); bool deleted = (bool)dataReader["Deleted"]; return(new Furniture() { Id = id, Name = name, Quantity = quantity, Price = price, FurnitureType = furnitureType, ActionSale = actionSale, Deleted = deleted }); } } return(null); } }
public ActionSaleWindow(ActionSale actionSale, Mode mode = Mode.ADD) { InitializeComponent(); this.actionSale = actionSale; this.mode = mode; if (mode == Mode.EDIT) { tbName.DataContext = actionSale; tbDiscount.DataContext = actionSale; dpStartDate.DataContext = actionSale; dpEndDate.DataContext = actionSale; btnAddEditActionSale.Content = "Edit"; } }