private bool UpdateStagedContainer()
        {
            //sol_Stage.UserID = (Guid)membershipUser.ProviderUserKey;
            //sol_Stage.UserName = Properties.Settings.Default.UsuarioNombre;
            //sol_Stage.Date = DateTime.Now;
            //sol_Stage.TagNumber = textBoxTagNumber.Text;

            int intVal = 0;

            Int32.TryParse(comboBoxContainers.SelectedValue.ToString(), out intVal);
            sol_Stage.ContainerID = intVal;

            sol_Stage.ContainerDescription = comboBoxContainers.Text;
            sol_Stage.ProductID            = Int32.Parse(comboBoxProducts.SelectedValue.ToString());
            sol_Stage.ProductName          = comboBoxProducts.Text;

            Int32.TryParse(textBoxDozen.Text, out intVal);
            sol_Stage.Dozen = intVal;

            sol_Stage.Remarks = textBoxRemarks.Text;

            ////include product price
            //Sol_Product_Sp sol_Product_Sp = new Sol_Product_Sp(Properties.Settings.Default.WsirDbConnectionString);
            //Sol_Product sol_Product = sol_Product_Sp.Select(sol_Stage.ProductID);
            //sol_Stage.Price = sol_Product.Price;
            sol_Stage.Price = 0.00m;

            try
            {
                sol_Stage_Sp.Update(sol_Stage);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return(false);
            }

            return(true);
        }
Example #2
0
        private void buttonSaveAdjustment_Click(object sender, EventArgs e)
        {
            //REMOVE
            if (radioButtonRemove.Checked)
            {
                if (detailsButtonView != StageTypes.Original)
                {
                    MessageBox.Show("You have to be in the Original Container list of Shipment");
                    buttonOriginalRbill.PerformClick();
                    return;
                }



                ListView.CheckedListViewItemCollection checkedItems = listViewContainersOnShipment.CheckedItems; //.SelectedItems;
                if (checkedItems.Count < 1)
                {
                    MessageBox.Show("Please select a Container on Shipment");
                    return;
                }

                if (radioButtonRemoveReturn.Checked &&
                    String.IsNullOrEmpty(textBoxNewTagNumber.Text)
                    )
                {
                    MessageBox.Show("Please supply a new Tag Number for the inventory return");
                    textBoxNewTagNumber.Focus();
                    return;
                }


                //if needed
                CreateShipmentEntry();

                //ListViewItem itm;   // = new ListViewItem();
                foreach (ListViewItem item in checkedItems)
                {
                    //SwitchContainers(ref listViewContainersOnShipment, ref listViewCurrentStagedContainers, item.SubItems[0].Text, false, null);
                    int stageId = 0;
                    int.TryParse(item.SubItems[4].Text, out stageId);

                    if (radioButtonRemoveReturn.Checked)
                    {
                        CreateAdjustment(AdjustmentActionTypes.Return, stageId, 0);
                    }
                    else if (radioButtonRemoveRemove.Checked)
                    {
                        CreateAdjustment(AdjustmentActionTypes.Remove, stageId, 0);
                    }
                }
            } // ADD
            else if (radioButtonAdd.Checked)
            {
                //
                if (detailsButtonView != StageTypes.Original)
                {
                    MessageBox.Show("You have to be in the Original Container list of Shipment");
                    buttonOriginalRbill.PerformClick();
                    return;
                }

                if (comboBoxCurrentStaging.SelectedIndex < 0)
                {
                    MessageBox.Show("Please select a Stage Container");
                    return;
                }

                //comboBoxCurrentStaging.SelectedText = comboBoxCurrentStaging.Text;
                string   fullDescription = comboBoxCurrentStaging.SelectedValue.ToString();
                string[] fields          = fullDescription.Split('-');
                int      stageId         = 0;
                int.TryParse(fields[0], out stageId);
                sol_Stage = sol_Stage_Sp.Select(stageId);
                if (sol_Stage == null)
                {
                    MessageBox.Show("Invalid Stage Contanier");
                    return;
                }

                //if needed
                CreateShipmentEntry();

                sol_Stage.ShipmentID = sol_ShipmentAdjustment.ShipmentID;
                sol_Stage.Status     = "S"; //from "I" to "S"
                sol_Stage_Sp.Update(sol_Stage);

                //sol_Shipment = sol_Shipment_Sp.SelectByRBillNumber(RemoveShipmentPostFix(RBillNumber));
                sol_Stage_SelectAllByAgencyTableAdapter.Fill(
                    this.dataSetStageLookup.sol_Stage_SelectAllByAgency,
                    "I", sol_Shipment.AgencyID);
            } //ADJUST
            else if (radioButtonAdjust.Checked)
            {
                //
                if (detailsButtonView != StageTypes.Original)
                {
                    MessageBox.Show("You have to be in the Original Container list of Shipment");
                    buttonOriginalRbill.PerformClick();
                    return;
                }

                //ListView.SelectedListViewItemCollection selectedItems = listViewContainersOnShipment.SelectedItems;
                ListView.CheckedListViewItemCollection checkedItems = listViewContainersOnShipment.CheckedItems; //.SelectedItems;

                if (checkedItems.Count < 1)
                {
                    MessageBox.Show("Please select a Container on Shipment");
                    return;
                }

                int newQuantityOfDozens = 0;
                int.TryParse(textBoxNewQuantity.Text, out newQuantityOfDozens);
                if (newQuantityOfDozens < 1)
                {
                    MessageBox.Show("Please supply a valid quantity of dozens for adjustment");
                    textBoxNewQuantity.Focus();
                    return;
                }


                //if needed
                CreateShipmentEntry();

                foreach (ListViewItem item in checkedItems)
                {
                    int productId = 0;
                    if (item.SubItems[1].Text != comboBoxNewProduct.SelectedText)
                    {
                        productId = (int)comboBoxNewProduct.SelectedValue;
                    }


                    int stageId = 0;
                    int.TryParse(item.SubItems[4].Text, out stageId);

                    CreateAdjustment(AdjustmentActionTypes.Adjust, stageId, productId);
                }
            } //CHANGE
              //else if (radioButtonChange.Checked)
              //{
              //    if (detailsButtonView != StageTypes.Original)
              //    {
              //        MessageBox.Show("You have to be in the Original Container list of Shipment");
              //        buttonOriginalRbill.PerformClick();
              //        return;
              //    }

            //    //ListView.SelectedListViewItemCollection selectedItems = listViewContainersOnShipment.SelectedItems;
            //    ListView.CheckedListViewItemCollection checkedItems = listViewContainersOnShipment.CheckedItems; //.SelectedItems;

            //    if (checkedItems.Count < 1)
            //    {
            //        MessageBox.Show("Please select a Container on Shipment");
            //        return;
            //    }

            //    //
            //    if (comboBoxNewProduct.SelectedIndex < 0)
            //    {
            //        MessageBox.Show("Please select a new Product");
            //        return;
            //    }

            //    //if needed
            //    CreateShipmentEntry();

            //    int productId = (int)comboBoxNewProduct.SelectedValue;

            //    //ListViewItem itm;   // = new ListViewItem();
            //    foreach (ListViewItem item in checkedItems)
            //    {
            //        //SwitchContainers(ref listViewContainersOnShipment, ref listViewCurrentStagedContainers, item.SubItems[0].Text, false, null);
            //        int stageId = 0;
            //        int.TryParse(item.SubItems[4].Text, out stageId);
            //        CreateAdjustment(AdjustmentActionTypes.Change, stageId, productId);
            //    }

            //} //DELETE
            //else if (radioButtonDelete.Checked)
            //{
            //    if (detailsButtonView != StageTypes.Adjustment)
            //    {
            //        MessageBox.Show("You have to be in the Adjustments list of Shipment");
            //        buttonAdjustments.PerformClick();
            //        return;
            //    }

            //    //ListView.SelectedListViewItemCollection checkedItems = listViewContainersOnShipment.SelectedItems;
            //    ListView.CheckedListViewItemCollection checkedItems = listViewContainersOnShipment.CheckedItems; //.SelectedItems;
            //    if (checkedItems.Count < 1)
            //    {
            //        MessageBox.Show("Please select a Container on Shipment");
            //        return;
            //    }

            //    //ListViewItem itm;   // = new ListViewItem();
            //    foreach (ListViewItem item in checkedItems)
            //    {
            //        //SwitchContainers(ref listViewContainersOnShipment, ref listViewCurrentStagedContainers, item.SubItems[0].Text, false, null);
            //        int stageId = 0;
            //        int.TryParse(item.SubItems[4].Text, out stageId);
            //        DeleteAdjustment(stageId);
            //    }

            //    //if needed
            //    DeleteShipmentEntry();

            //    buttonAdjustments.PerformClick();

            //}

            buttonAdjustments.PerformClick();
            //unselect all items
            foreach (ListViewItem i in listViewContainersOnShipment.Items)
            {
                i.Selected = false;
            }
        }