private InventoryOrderItem buildItem()
        {
            InventoryOrderItem Item = new InventoryOrderItem();

            Item.description = descriptiontxt.Text;

            Item.quantity   = quantitytxt.Text;
            Item.unit       = (string)unittxt.SelectedItem;
            Item.unit_price = ParseFloat(unitpricetxt.Text);
            Item.total      = ParseFloat(itemtotaltxt.Text);

            Item.designation = designationcmb.Text;
            Item.category    = "Flat Sheets";
            Item.status      = statuscmb.Text;

            Item.material  = materialcmb.Text;
            Item.gauge     = gaugecmb.Text;
            Item.color     = colorcmb.Text;
            Item.width     = ParseFloat(widthtxt.Text);
            Item.height    = ParseFloat(heighttxt.Text);
            Item.size_unit = sizeunitcmb.Text;

            Item.isMaterial = true;

            return(Item);
        }
Exemple #2
0
 public PurchaseOrderItem()
 {
     for (int i = 0; i < 16; i++)
     {
         orderItem[i] = new InventoryOrderItem();
     }
 }
Exemple #3
0
        private InventoryOrderItem buildItem()
        {
            InventoryOrderItem Item = new InventoryOrderItem();

            Item.description = descriptiontxt.Text;

            Item.quantity   = quantitytxt.Text;
            Item.unit       = unittxt.Text;
            Item.unit_price = ParseFloat(unitpricetxt.Text);
            Item.total      = ParseFloat(itemtotaltxt.Text);

            Item.designation = designationcmb.Text;
            Item.category    = categorycmb.Text;
            Item.status      = statuscmb.Text;

            Item.material  = "-";
            Item.gauge     = "-";
            Item.color     = "-";
            Item.width     = 0;
            Item.height    = 0;
            Item.size_unit = "-";

            Item.isMaterial = false;

            return(Item);
        }
Exemple #4
0
        public void SetParent(Form_Main p, int i, InventoryOrderItem ioi)
        {
            this.mParentForm = p;
            this.mIndex      = i;
            this.mParentForm.Hide();

            descriptiontxt.Text = ioi.description;
            quantitytxt.Text    = ioi.quantity;
            //unittxt.Text = item.unit;
            unitpricetxt.Text = ioi.unit_price.ToString();
            itemtotaltxt.Text = ioi.total.ToString();

            designationcmb.SelectedItem = ioi.designation;
            categorycmb.SelectedItem    = ioi.category;
            statuscmb.SelectedItem      = ioi.status;
        }
        public void SetParent(Form_Main p, int i, InventoryOrderItem ioi)
        {
            this.mParentForm = p;
            this.mIndex      = i;
            this.mParentForm.Hide();

            descriptiontxt.Text = ioi.description;
            quantitytxt.Text    = ioi.quantity;
            unittxt.Text        = ioi.unit;
            unitpricetxt.Text   = ioi.unit_price.ToString();
            itemtotaltxt.Text   = ioi.total.ToString();

            designationcmb.SelectedItem = ioi.designation;
            statuscmb.SelectedItem      = ioi.status;

            materialcmb.SelectedText = ioi.material;
            gaugecmb.SelectedItem    = ioi.gauge;
            colorcmb.SelectedItem    = ioi.color;
            widthtxt.Text            = ioi.width.ToString();
            heighttxt.Text           = ioi.height.ToString();
            sizeunitcmb.SelectedItem = ioi.size_unit;
        }
Exemple #6
0
        public void ReturnItem(InventoryOrderItem ioi, int index)
        {
            if (index < 0)
            {
                // item is new
                mOrderItems.Add(ioi);
            }
            else
            {
                // item is existing
                mOrderItems[index] = ioi;
            }

            orderitemlist.Items.Clear();
            for (int i = 0; i < mOrderItems.Count; i++)
            {
                string price = "$" + mOrderItems[i].total;
                int    steps = 15 - price.Length;
                string str   = price;
                for (int j = 0; j < steps; j++)
                {
                    str += " ";
                }

                string qty = mOrderItems[i].quantity;
                steps = 10 - qty.Length;
                str  += qty;
                for (int k = 0; k < steps; k++)
                {
                    str += " ";
                }
                str += mOrderItems[i].description;
                orderitemlist.Items.Add(str);
                // orderitemlist.Items.Add(mOrderItems[i].description);
            }

            calctotal();
        }
Exemple #7
0
        private void SubmitMaterialItem(InventoryOrderItem ioi, POInformation p)
        {
            string queue = BuildQueue.buildQueueMaterial(ioi, p);

            mPurchasers = new List <Purchaser>();
            try
            {
                var command = new OleDbCommand();
                command.Connection  = connection;
                command.CommandText = queue;

                connection.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Submitting Material Item. " + ex);
            }
            finally
            {
                connection.Close();
            }
        }
Exemple #8
0
        public static string buildQueueMaterial(InventoryOrderItem i, POInformation p)
        {
            string QA, QB;

            QA = "INSERT INTO MaterialInventory (";
            QB = "VALUES('";

            QA = QA + "PO_NUMBER,";
            QB = QB + p.OrderNumber + "','";

            QA = QA + "ORDER_BY,";
            QB = QB + p.Purchaser + "','";

            QA = QA + "DATE_ORDERED,";
            QB = QB + p.OrderDate + "','";

            QA = QA + "PROJECT,";
            QB = QB + p.ProjectName + "','";

            QA = QA + "JOB_NUMBER,";
            QB = QB + p.JobNumber + "','";

            QA = QA + "VENDOR,";
            QB = QB + p.Vendor + "','";

            QA = QA + "GAUGE,";
            QB = QB + i.gauge + "','";

            QA = QA + "DESCRIPTION,";
            QB = QB + i.description + "','";

            QA = QA + "SHEET_SIZE,";
            QB = QB + i.width.ToString() + " x " + i.height.ToString() + " " + i.size_unit + "','";

            QA = QA + "MATERIAL,";
            QB = QB + i.material + "','";

            QA = QA + "ETA,";
            QB = QB + p.DeliveryDate + "','";

            QA = QA + "ATA,";
            QB = QB + "1900-01-01" + "','";
            //------------------------------------------------------------
            QA = QA + "QUANTITY,";
            QB = QB + i.quantity + "','";

            QA = QA + "INVENTORY_QUANTITY,";
            QB = QB + "-" + "','";

            QA = QA + "UNIT_COST,";
            QB = QB + i.unit_price + "','";

            QA = QA + "UNIT,";
            QB = QB + "-" + "','"; //ioi.unit + "','";

            QA = QA + "TOTAL,";
            QB = QB + i.total + "','";

            QA = QA + "COLOR,";
            QB = QB + i.color + "','";

            QA = QA + "MATERIAL_ITEM,"; //category;
            QB = QB + i.category + "','";

            QA = QA + "STOCK_ITEM,"; //designation;
            QB = QB + i.designation + "','";

            QA = QA + "STATUS";
            QB = QB + i.status;

            QA = QA + ")";
            QB = QB + "')";

            //QB.Replace("''", "'-'");
            return(QA + " " + QB);
        }
Exemple #9
0
        public List <InventoryOrderItem> GetMaterialItems(string p)
        {
            List <InventoryOrderItem> ioi = new List <InventoryOrderItem>();

            connection.Open();
            var command = new OleDbCommand();

            command.Connection  = connection;
            command.CommandText = "select * from MaterialInventory";
            var reader = command.ExecuteReader();

            try
            {
                while (reader.Read())
                {
                    var ponum = reader.GetString(1);
                    if (ponum == p)
                    {
                        InventoryOrderItem i = new InventoryOrderItem();
                        // ID
                        // PO NUMBER
                        // PURCHASER
                        // DATE
                        // PROJECT
                        // JOB NUMBER
                        // VENDOR
                        i.gauge        = reader.GetString(7);                        // GAUGE
                        i.description  = reader.GetString(8);                        // DESCRIPTION
                        i.sheetsize    = reader.GetString(9);                        // SHEET SIZE
                        i.material     = reader.GetString(10);                       // MATERIAL
                        i.deliveryDate = reader.GetDateTime(11).ToShortDateString(); // ETA
                        // ATA
                        i.quantity = reader.GetString(13);                           // QUANTITY
                        // INVENTORY QUANTITY
                        var decunit = reader.GetDecimal(15);                         // -> i.unit_price = reader.GetFloat(15);     // UNIT COST
                        i.unit_price = (float)decunit;

                        i.unit = reader.GetString(16);                                  // UNIT

                        var dectotal = reader.GetDecimal(17);                           // -> i.total = reader.GetFloat(17);          // TOTAL
                        i.total = (float)dectotal;

                        i.color       = reader.GetString(18);   // COLOR
                        i.category    = reader.GetString(19);   // MATERIAL ITEM
                        i.designation = reader.GetString(20);   // STOCK ITEM
                        i.status      = reader.GetString(21);   // STATUS

                        if (i.category == "Flat Sheets")
                        {
                            i.isMaterial = true;
                        }
                        else
                        {
                            i.isMaterial = false;
                        }

                        ioi.Add(i);
                    }
                }
            }
            catch (Exception e) {
                Console.WriteLine("error" + e);
            }
            finally {
                reader.Close();
                connection.Close();
            }
            return(ioi);
        }