private void ApplyChangesBy(TradePointRequest tradePointRequest)
{
SupplierProduct supplierProduct = tradePointRequest.Product ?? new SupplierProduct();
supplierProduct.Supplier = comboBoxes[0].SelectedItem as Supplier;
supplierProduct.Product = comboBoxes[1].SelectedItem as Product;
try
{
supplierProduct.Count = Int32.Parse(textBoxes[0].Text);
}
catch (Exception ex)
{
supplierProduct.Count = 0;
}
tradePointRequest.Product = supplierProduct;
tradePointRequest.TradePoint = comboBoxes[2].SelectedItem as TradePoint;
if (tradePointRequest.Id < 0)
{
TradePointsController.GetInstance().AddTradePointRequest(tradePointRequest);
}
else
{
TradePointsController.GetInstance().EditTradePointRequest(tradePointRequest);
}
}
private void AddFieldsBy(TradePointRequest request)
{
List <TradePoint> tradePoints = TradePointsController.GetInstance().GetTradePoints();
TradePoint currTradePoint;
try
{
currTradePoint = request.TradePoint == null?tradePoints.First() : tradePoints.Find(x => x.Id == request.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 = request.Product == null || request.Product.Product == null?products.First() : products.Find(x => x.Id == request.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 = request.Product == null || request.Product.Supplier == null?suppliers.First() : suppliers.Find(x => x.Id == request.Product.Supplier.Id);
}
catch (Exception ex)
{
currSupplier = null;
}
ComboBox supplierCB = GetComboBoxOnData(suppliers.ToList <object>(), currSupplier, "Name");
int count = request.Product == null ? 0 : request.Product.Count;
TextBox countTB = new TextBox()
{
Text = 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(countTB);
Elements.Children.Add(tradePointCB);
comboBoxes.Add(supplierCB);
comboBoxes.Add(productCB);
comboBoxes.Add(tradePointCB);
textBoxes.Add(countTB);
}
public bool Update(TradePointRequest request)
{
if (request.Id < 0)
{
return(false);
}
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.UpdateTradePointRequest(request), true);
return(true);
}
internal void EditTradePointRequest(TradePointRequest tradePointRequest)
{
if (tradePointRequest == null)
{
return;
}
try
{
bool res = ServerHandler.GetInstance().PostRequest("TradePointsRequests/Update", tradePointRequest);
}
catch (Exception ex)
{
return;
}
}
internal void DeleteTradePointRequest(TradePointRequest tradePointRequest)
{
if (tradePointRequest == null)
{
return;
}
try
{
var sqlResult = ServerHandler.GetInstance().GetRequest("TradePointsRequests/Delete/" + tradePointRequest.Id).Result;
}
catch (Exception ex)
{
return;
}
return;
}
internal static string InsertTradePointRequest(TradePointRequest request)
{
return(GetCommand(ref insertTradePointRequest, insertTradePointRequestPath, new string[] { request.TradePoint.Id.ToString(), request.Product.Product.Id.ToString(), request.Product.Count.ToString(), request.Product.Supplier.Id.ToString() }));
}