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);
            }
        }