private void populateItemCombo() { FOBActualCostDAO actualcostOject = new FOBActualCostDAO(); cmbSelectItem.ItemsSource = actualcostOject.getItems(); }
private void populateTypeCombo() { FOBActualCostDAO actualcostOject = new FOBActualCostDAO(); cmbAccTypes.ItemsSource = actualcostOject.getAccTypes(); cmbFabTypes.ItemsSource = actualcostOject.getFabTypes(); }
private void addActDetails() { if (lstBoxFabCost.Items.Count != 0 && lstBoxAccCostPI.Items.Count != 0 && cmbCurrency.SelectedIndex != -1) { ActualCostHandle actCostHandle = new ActualCostHandle(); FOBActualCostDAO daoObject = new FOBActualCostDAO(); string cmx = cmbCurrency.Text; double total = actCostHandle.calTotalCost(lstBoxFabCost, lstBoxAccCostPI); if (daoObject.addActualCost(total, cmx)) { string ActCostId = daoObject.getLastActualCostId(); bool getverificatio1 = false, getverificatio2 = false; AccessoryCostData accCostData = new AccessoryCostData(); FabricCostData fabCostData = new FabricCostData(); int size = lstBoxAccCostPI.Items.Count; for (int i = 0; i < size; i++) { accCostData.Unit = actCostdao.getuntype(lstBoxAccType.Items[i].ToString()); //accCostData.Unit = actCostHandle.getUnitType(lstBoxAccType.Items[i].ToString()); accCostData.Amount = Convert.ToDouble(lstBoxAccAmt.Items[i].ToString()); accCostData.Type = lstBoxAccType.Items[i].ToString(); accCostData.Cost = Convert.ToDouble(lstBoxAccCostPI.Items[i].ToString()); accCostData.WeightPItem = Convert.ToDouble(lstBoxAccWPI.Items[i].ToString()); accCostData.AcostID = ActCostId; accCostData.Chg = Convert.ToDouble(lstBoxAccCostForH.Items[i].ToString()); getverificatio1 = daoObject.addAccessoryCost(accCostData); } size = lstBoxFabCost.Items.Count; for (int i = 0; i < size; i++) { fabCostData.Type = lstBoxFabType.Items[i].ToString(); fabCostData.Amount = Convert.ToDouble(lstBoxFabComsup.Items[i].ToString()); fabCostData.Cost = Convert.ToDouble(lstBoxFabCost.Items[i].ToString()); fabCostData.CostPyard = Convert.ToDouble(lstBoxFabCPY.Items[i].ToString()); fabCostData.ACostID = ActCostId; getverificatio2 = daoObject.addFabricCost(fabCostData); } if (getverificatio1 && getverificatio2 && daoObject.updateStock(cmbSelectItem.Text.ToString().Split('|')[1], ActCostId)) { _context.SaveChanges(); _context.ActualCosts.Load(); this.actualCostDataGrid.Items.Refresh(); actCostdao.updateSearchComboBox(cmbEditAcost); actCostdao.getTotal(ActCostId, lblCmDisplay, lblActCost_Display, true); populateItemCombo(); clearAcc(); MessageBox.Show("Successfully Added", "Successful", MessageBoxButton.OK, MessageBoxImage.Information); } } else { } } else if (cmbCurrency.SelectedIndex == -1) { MessageBox.Show("Please Select CM", "Select", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("Please Add values to the Fabrics and Accessories", "Empty fileds available", MessageBoxButton.OK, MessageBoxImage.Error); } }