private void ChangeProduct(ref Prdct product, string propertyToNotify)
{
var viewModel = new ChangeProductViewModel();
if (_dialogService.ShowDialog(viewModel) == true)
{
product = viewModel.SelectedProduct;
Notify(propertyToNotify);
}
}
public EditPackageViewModel(Dlvr delivery)
{
_delivery = delivery;
_product1 = _delivery.PRD_LN_1 == null ? null : DBHelper.GetProduct(_delivery.PRD_LN_1.Value);
_product2 = _delivery.PRD_LN_2 == null ? null : DBHelper.GetProduct(_delivery.PRD_LN_2.Value);
_product3 = _delivery.PRD_LN_3 == null ? null : DBHelper.GetProduct(_delivery.PRD_LN_3.Value);
_product4 = _delivery.PRD_LN_4 == null ? null : DBHelper.GetProduct(_delivery.PRD_LN_4.Value);
Amount1 = _delivery.PRD_LN_1_AMN == null ? 0 : int.Parse(_delivery.PRD_LN_1_AMN);
Amount2 = _delivery.PRD_LN_2_AMN == null ? 0 : int.Parse(_delivery.PRD_LN_2_AMN);
Amount3 = _delivery.PRD_LN_3_AMN == null ? 0 : int.Parse(_delivery.PRD_LN_3_AMN);
Amount4 = _delivery.PRD_LN_4_AMN == null ? 0 : int.Parse(_delivery.PRD_LN_4_AMN);
CostEstimate = _delivery.ESTM_CLM;
OkCommand = new Command(Save);
CancelCommand = new Command(() => DialogResult = false);
ChangeProduct1Command = new Command(() => ChangeProduct(ref _product1, nameof(Product1Name)));
ChangeProduct2Command = new Command(() => ChangeProduct(ref _product2, nameof(Product2Name)));
ChangeProduct3Command = new Command(() => ChangeProduct(ref _product3, nameof(Product3Name)));
ChangeProduct4Command = new Command(() => ChangeProduct(ref _product4, nameof(Product4Name)));
RecalculateCostCommand = new Command(RecalculateCost);
}
public static void UpdateDelivery(int id, Prdct product1, int amount1, Prdct product2, int amount2, Prdct product3, int amount3, Prdct product4, int amount4, double costEstimate)
{
using (var connection = new SqlConnection(_connectionString))
{
string query = @"
UPDATE [dbo].[DLVR_TBL]
SET PRD_LN_1 = @PRD_LN_1, PRD_LN_1_AMN = @PRD_LN_1_AMN, PRD_LN_2 = @PRD_LN_2, PRD_LN_2_AMN = @PRD_LN_2_AMN, ESTM_CLM = @ESTM_CLM, STS = 'R'
WHERE NMB_CLM = @NMB_CLM
IF EXISTS (SELECT TOP 1 1 FROM [dbo].[DLVR_TBL2] WHERE NMB_CLM = @NMB_CLM)
BEGIN
UPDATE [dbo].[DLVR_TBL2]
SET PRD_LN_3 = @PRD_LN_3, PRD_LN_3_AMN = @PRD_LN_3_AMN, PRD_LN_4 = @PRD_LN_4, PRD_LN_4_AMN = @PRD_LN_4_AMN
WHERE NMB_CLM = @NMB_CLM
END
ELSE
BEGIN
INSERT [dbo].[DLVR_TBL2] (NMB_CLM, PRD_LN_3, PRD_LN_3_AMN, PRD_LN_4, PRD_LN_4_AMN)
VALUES (@NMB_CLM, @PRD_LN_3, @PRD_LN_3_AMN, @PRD_LN_4, @PRD_LN_4_AMN)
END";
connection.Execute(query, new
{
NMB_CLM = id,
PRD_LN_1 = product1?.NMB_CM,
PRD_LN_1_AMN = amount1,
PRD_LN_2 = product2?.NMB_CM,
PRD_LN_2_AMN = amount2,
PRD_LN_3 = product3?.NMB_CM,
PRD_LN_3_AMN = amount3,
PRD_LN_4 = product4?.NMB_CM,
PRD_LN_4_AMN = amount4,
ESTM_CLM = costEstimate
});
}
}
