private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show($"Are you sure that you want to delete this?", "Delete", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (dgFurniture.Visibility.Equals(Visibility.Visible))
{
FurnitureDAO.Delete(SelectedFurniture);
}
else if (dgFurnitureType.Visibility.Equals(Visibility.Visible))
{
FurnitureTypeDAO.Delete(SelectedFurnitureType);
}
else if (dgSales.Visibility.Equals(Visibility.Visible))
{
SaleDAO.Delete(SelectedSale);
SaleDAO.DeleteFurnitureSale(SelectedSale);
}
else if (dgUsers.Visibility.Equals(Visibility.Visible))
{
UserDAO.Delete(SelectedUser);
}
else if (dgAdditionalService.Visibility.Equals(Visibility.Visible))
{
AdditionalServiceDAO.Delete(SelectedAdditionalService);
}
}
}
private void DeleteFurnitureType(object sender, RoutedEventArgs e)
{
FurnitureType furnitureType = (FurnitureType)dgFurnitureTypes.SelectedItem;
int furnitureTypeId = furnitureType.Id;
if (MessageBox.Show($"Are you sure you want to delete : {furnitureType.Name} ?", "Deleting", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
FurnitureDAO furnitureDAO = new FurnitureDAO();
ftList.Remove(furnitureType);
ftView.Refresh();
//Posle brisanja tipa namjestaja implementirati brisanje svih namhjestaja koji pripadaju tom tipu namjestaja
foreach (Furniture item in furnitureList)
{
if (item.FurnitureType.Id == furnitureTypeId)
{
furnitureList.Remove(item);
furnitureView.Refresh();
}
}
/*
* Nakon uklanjanja tipa namjestaja iz radne memorije, zatim uklanjanja svih namjestaja koji pripadaju tom tipu i iz radne memorije
* uklanjam i sam tip namjestaja iz baze.
*/
new FurnitureTypeDAO().Delete(furnitureType);
}
}
public static void DeleteSoldFurniture()
{
foreach (var fur in Project.Instance.FurnitureList)
{
if (fur.Quantity == 0)
{
FurnitureDAO.Delete(fur);
}
}
}
private void btnAddEditFurniture_Click(object sender, RoutedEventArgs e)
{
FurnitureDAO furnitureDAO = new FurnitureDAO();
FurnitureType furnitureType;
ActionSale actionSale;
try
{
furnitureType = new FurnitureTypeDAO().Get((int)cbFurnitureType.SelectedValue);
actionSale = cbActionSale.SelectedItem == null ? null : new ActionSaleDAO().Get((int)cbActionSale.SelectedValue);
}
catch (Exception)
{
furnitureType = null;
actionSale = null;
}
if (mode == Mode.ADD)
{
Furniture furniture = new Furniture()
{
Name = tbName.Text.Trim(),
Price = decimal.Parse(tbPrice.Text.Trim()),
Quantity = int.Parse(tbQuantity.Text.Trim()),
FurnitureType = furnitureType,
ActionSale = actionSale
};
MainWindow.furnitureList.Add(furniture);
furnitureDAO.Add(furniture);
}
else
{
furniture.Name = tbName.Text.Trim();
furniture.Price = decimal.Parse(tbPrice.Text.Trim());
furniture.Quantity = int.Parse(tbQuantity.Text.Trim());
furniture.FurnitureType = furnitureType;
furniture.ActionSale = actionSale;
furnitureDAO.Update(furniture);
}
Close();
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
if (IsValid() == false)
{
return;
}
switch (operation)
{
case Operation.ADD:
FurnitureDAO.Create(furniture);
break;
case Operation.EDIT:
foreach (var f in Project.Instance.FurnitureList)
{
if (f.ID == furniture.ID)
{
var pricePrim = furniture.Price;
f.Name = furniture.Name;
f.ProductCode = furniture.ProductCode;
f.Price = furniture.Price;
if (f.Sales != null)
{
foreach (var s in f.Sales)
{
f.PriceOnSale = pricePrim - (pricePrim / 100 * s.Discount);
pricePrim = f.PriceOnSale;
}
}
f.Quantity = furniture.Quantity;
f.FurnitureType = furniture.FurnitureType;
f.Deleted = furniture.Deleted;
break;
}
FurnitureDAO.Update(furniture);
}
break;
}
this.Close();
}
private void BtnAddSale_Click(object sender, RoutedEventArgs e)
{
SaleDAO.AddFurnitureSale(SelectedSale, furniture);
furniture.Sales.Add(SelectedSale);
var pricePrim = furniture.Price;
if (furniture.Sales != null)
{
foreach (var s in furniture.Sales)
{
furniture.PriceOnSale = pricePrim - (pricePrim / 100 * s.Discount);
pricePrim = furniture.PriceOnSale;
}
}
FurnitureDAO.Update(furniture);
MessageBox.Show("Success!", "Congratulations", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
private void PrintBill_Click(object sender, RoutedEventArgs e)
{
if (Project.Instance.Bill.FullPrice == 0)
{
MessageBox.Show("Bill cannot be empty", "Congratulations", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
if (IsValid() == false)
{
return;
}
Project.Instance.Bill.DateOfSale = DateTime.Now;
Project.Instance.Bill.BillNo = DateTime.Now.Millisecond;
BillDAO.Create(Project.Instance.Bill);
foreach (var b in Project.Instance.Bill.FurnitureForSaleList)
{
foreach (var f in Project.Instance.FurnitureList)
{
if (f.ID == b.ID)
{
BillDAO.AddFurnitureOnBill(Project.Instance.Bill, f);
f.Quantity -= b.Quantity;
FurnitureDAO.Update(f);
}
}
}
foreach (var b in Project.Instance.Bill.AdditionalServiceList)
{
foreach (var a in Project.Instance.AdditionalServicesList)
{
BillDAO.AddAdditionalServiceOnBill(Project.Instance.Bill, a);
}
}
MessageBox.Show("Success!", "Congratulations", MessageBoxButton.OK, MessageBoxImage.Information);
Project.Instance.Bill = new Bill();
MainWindow.DeleteSoldFurniture();
this.Close();
}
