private void ApplyChangesBy(TradePointProduct tradePointProduct)
{
tradePointProduct.Supplier = comboBoxes[0].SelectedItem as Supplier;
tradePointProduct.Product = comboBoxes[1].SelectedItem as Product;
try
{
tradePointProduct.Price = Int32.Parse(textBoxes[0].Text);
}
catch (Exception ex)
{
tradePointProduct.Price = 0;
}
try
{
tradePointProduct.Count = Int32.Parse(textBoxes[1].Text);
}
catch (Exception ex)
{
tradePointProduct.Count = 0;
}
tradePointProduct.TradePoint = comboBoxes[2].SelectedItem as TradePoint;
if (tradePointProduct.Id < 0)
{
TradePointsController.GetInstance().AddTradePointProduct(tradePointProduct);
}
else
{
TradePointsController.GetInstance().EditTradePointProduct(tradePointProduct);
}
}
public bool Update(TradePointProduct product)
{
if (product.Id < 0)
{
return(false);
}
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.UpdateTradePointProduct(product), true);
return(true);
}
internal void EditTradePointProduct(TradePointProduct tradePointProduct)
{
if (tradePointProduct == null)
{
return;
}
try
{
bool res = ServerHandler.GetInstance().PostRequest("TradePointsProducts/Update", tradePointProduct);
}
catch (Exception ex)
{
return;
}
}
internal void DeleteTradePointProduct(TradePointProduct tradePointProduct)
{
if (tradePointProduct == null)
{
return;
}
try
{
var sqlResult = ServerHandler.GetInstance().GetRequest("TradePointsProducts/Delete/" + tradePointProduct.Id).Result;
}
catch (Exception ex)
{
return;
}
return;
}
internal static string InsertTradePointProduct(TradePointProduct product)
{
return(GetCommand(ref insertTradePointProduct, insertTradePointProductPath, new string[] { product.TradePoint.Id.ToString(), product.Product.Id.ToString(), product.Supplier.Id.ToString(), product.Count.ToString(), product.Price.ToString() }));
}
private void AddFieldsBy(TradePointProduct product)
{
TextBox priceTB = new TextBox()
{
Text = product.Price.ToString(), Margin = new Thickness(5, 5, 5, 5), Width = 200
};
priceTB.PreviewTextInput += NumberValidationTextBox;
List <TradePoint> tradePoints = TradePointsController.GetInstance().GetTradePoints();
TradePoint currTradePoint;
try
{
currTradePoint = product.TradePoint == null?tradePoints.First() : tradePoints.Find(x => x.Id == product.TradePoint.Id);
}
catch (Exception ex)
{
currTradePoint = null;
}
ComboBox tradePointCB = GetComboBoxOnData(tradePoints.ToList <object>(), currTradePoint, "FullName");
List <Product> products = ProductsController.GetInstance().GetProducts();
Product currProduct;
try
{
currProduct = product.Product == null?products.First() : products.Find(x => x.Id == product.Product.Id);
}
catch (Exception ex)
{
currProduct = null;
}
ComboBox productCB = GetComboBoxOnData(products.ToList <object>(), currProduct, "Name");
List <Supplier> suppliers = SuppliersController.GetInstance().GetSuppliers();
Supplier currSupplier;
try
{
currSupplier = product.Supplier == null?suppliers.First() : suppliers.Find(x => x.Id == product.Supplier.Id);
}
catch (Exception ex)
{
currSupplier = null;
}
ComboBox supplierCB = GetComboBoxOnData(suppliers.ToList <object>(), currSupplier, "Name");
TextBox countTB = new TextBox()
{
Text = product.Count.ToString(), Margin = new Thickness(5, 5, 5, 5), Width = 200
};
countTB.PreviewTextInput += NumberValidationTextBox;
Elements.Children.Add(supplierCB);
Elements.Children.Add(productCB);
Elements.Children.Add(priceTB);
Elements.Children.Add(countTB);
Elements.Children.Add(tradePointCB);
comboBoxes.Add(supplierCB);
comboBoxes.Add(productCB);
textBoxes.Add(priceTB);
textBoxes.Add(countTB);
comboBoxes.Add(tradePointCB);
}
