public bool Update(TradePointSale sale)
{
if (sale.Id < 0)
{
return(false);
}
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.UpdateTradePointSale(sale), true);
return(true);
}
private void AddFieldsBy(TradePointSale sale)
{
TextBox countTB = new TextBox()
{
Text = sale.Count.ToString(), Margin = new Thickness(5, 5, 5, 5), Width = 200
};
countTB.PreviewTextInput += NumberValidationTextBox;
DatePicker datePicker = new DatePicker()
{
SelectedDate = sale.Date, IsDropDownOpen = false, Margin = new Thickness(5, 5, 5, 5), Width = 200
};
List <TradePoint> tradePoints = TradePointsController.GetInstance().GetTradePoints();
TradePoint currTradePoint;
try
{
currTradePoint = sale.TradePointProduct == null || sale.TradePointProduct.TradePoint == null?tradePoints.First() : tradePoints.Find(x => x.Id == sale.TradePointProduct.TradePoint.Id);
}
catch (Exception ex)
{
currTradePoint = null;
}
ComboBox tradePointCB = GetComboBoxOnData(tradePoints.ToList <object>(), currTradePoint, "FullName");
tradePointCB.SelectionChanged += saleTradePoint_SelectionChanged;
List <TradePointProduct> products = TradePointsController.GetInstance().GetTradePointProducts(currTradePoint);
TradePointProduct currProduct;
try
{
currProduct = sale.TradePointProduct == null?products.First() : products.Find(x => x.Id == sale.TradePointProduct.Id);
}
catch (Exception ex)
{
currProduct = null;
}
ComboBox productCB = GetComboBoxOnData(products.ToList <object>(), currProduct, "FullName");
Elements.Children.Add(datePicker);
Elements.Children.Add(tradePointCB);
Elements.Children.Add(productCB);
Elements.Children.Add(countTB);
textBoxes.Add(countTB);
comboBoxes.Add(tradePointCB);
comboBoxes.Add(productCB);
datePickers.Add(datePicker);
}
internal void EditTradePointSale(TradePointSale tradePointSale)
{
if (tradePointSale == null)
{
return;
}
try
{
bool res = ServerHandler.GetInstance().PostRequest("TradePointsSales/Update", tradePointSale);
}
catch (Exception ex)
{
return;
}
}
internal void DeleteTradePointSale(TradePointSale tradePointSale)
{
if (tradePointSale == null)
{
return;
}
try
{
var sqlResult = ServerHandler.GetInstance().GetRequest("TradePointsSales/Delete/" + tradePointSale.Id).Result;
}
catch (Exception ex)
{
return;
}
return;
}
private void ApplyChangesBy(TradePointSale tradePointSale)
{
tradePointSale.TradePointProduct = comboBoxes[1].SelectedItem as TradePointProduct;
try
{
tradePointSale.Count = Int32.Parse(textBoxes[0].Text);
}
catch (Exception ex)
{
tradePointSale.Count = 0;
}
tradePointSale.Date = datePickers[0].DisplayDate;
if (tradePointSale.Id < 0)
{
TradePointsController.GetInstance().AddTradePointSale(tradePointSale);
}
else
{
TradePointsController.GetInstance().EditTradePointSale(tradePointSale);
}
}
internal static string InsertTradePointSale(TradePointSale sale)
{
return(GetCommand(ref insertTradePointSale, insertTradePointSalePath, new string[] { sale.Count.ToString(), sale.Date.ToString("'yyyy/mm/dd"), sale.TradePointProduct.Id.ToString() }));
}
