Exemplo n.º 1
0
        public Delivery GetDelivery(int docNbr)
        {
            Delivery myOrder = new Delivery();
               string _cmd = "Select * from " + PODConstants.DELIVERY_TABLE_NAME + " WHERE DocNum = " + docNbr.ToString() + " and DocType = 13"; ;
               DataTable _table = Utilities.DataBaseUtility.GetTable(_cmd);

                int nrows = _table.Rows.Count;
                if (nrows != 1) return myOrder;

                myOrder.DocNumber = Convert.ToInt32(_table.Rows[0][0]);
                myOrder.SupplierID = Convert.ToInt32(_table.Rows[0]["ExtRef"]);
                myOrder.PO_Date = Convert.ToDateTime(_table.Rows[0]["TextValue2"]);
                myOrder.DeliveryDate = Convert.ToDateTime(_table.Rows[0]["TextValue1"]);
             //   myOrder.PurchaseQuotedPrice  = Convert.ToDouble(_table.Rows[0]["QuotedPrice"]);
                myOrder.Status = Convert.ToInt32(_table.Rows[0]["status"]);
                return myOrder;
        }
        private void button_SubmitOrder_Click(object sender, EventArgs e)
        {
            Delivery del = new Delivery();
            int order_no = 0;
            int.TryParse(textBox_DocNumber.Text, out order_no);
            if (order_no == 0) { MessageBox.Show("Invalid Order Number"); return; }
            del.DocNumber = order_no;
            del.SupplierID = comboBox_Supplier.SelectedIndex = 1;
            del.Status = comboBox_Status.SelectedIndex;
            del.PO_Date = dateTimePicker1.Value;
            del.DeliveryDate = dateTimePicker2.Value;

               // textBox_Employee.Text
            //          _action = new Utilities.Action();
            //_action.DocNumber = order_no;
            //_action.ActionType = 2;
            //_action.EmployeeID = Int32.Parse(textBox_Employee.Text);
            //_action.DepartmentID = 1;    //  not textBox_Role.Text;
            //_action.ActionDate = DateTime.Now;
            //_action.Status = 2;
            //_action.Command = "";
            //_action.Comment = textBox_Comment.Text;
            Purchases.PurchaseOrder po = new Purchases.PurchaseOrder();
            po.PO_ID = order_no;
            po.SupplierID = comboBox_Supplier.SelectedIndex + 0;
            po.PO_Status = comboBox_Status.SelectedIndex;
            po.EmployeeID = Int32.Parse(textBox_Employee.Text);
            po.PO_Date = dateTimePicker1.Value;
            po.DeliveryDate = dateTimePicker2.Value;
            po.Comment = textBox_Comment.Text;
            if (po.Comment.Length < 1)
                po.Comment = "create PO " + po.PO_ID.ToString();
            if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
            {
                MessageBox.Show("Start Date should not be greater than End Date"); return;
            }
            string[] cmds = textBox_Details.Text.Split(';');
            int last = cmds.Length - 1;
            for (int i = 0; i < last; i++)
            {
                //action.Command = ;
                DataBaseUtility.Execute(cmds[i].Trim(), _ident);
            }
            ////     if (po.Comment.Length < 1)
               //         po.Comment = "create PO " + po.PO_ID.ToString();
               //     if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
               //     {
               //         MessageBox.Show("Start Date should not be greater than End Date"); return;
               //     }
            cmds = textBox_Details.Text.Split(';');
            last = cmds.Length - 1;
            for (int i = 0; i < last; i++)
            {
              //  _action.Command = cmds[i];
              //  DataBaseUtility.Execute(_action, _ident);
            }
        }
        //private void FillProductDetails(int _id)
        //{
        //    listBox_Products.Items.Clear();
        //    //   listBox_Quant.Items.Clear();
        //    //   listBox_Cost.Items.Clear();
        //    foreach (DataRow drProdut in dt_PurchaseOrder.Rows)
        //    {
        //        listBox_Products.Items.Add(Convert.ToString(drProdut["Name"]));
        //        //     listBox_Quant.Items.Add(Convert.ToString(drProdut["Qty"]).PadLeft(5, ' '));
        //        //     listBox_Cost.Items.Add(Convert.ToString(drProdut["Cost"]).PadLeft(5, ' '));
        //    }
        //}
        private void button_Preview_Click(object sender, EventArgs e)
        {
            if (radioButton_SQL.Checked) radioButton_SQL_CheckedChanged(this, null);
            del = new Delivery(textBox_Details.Text );
            //int order_no = 0;
            //int.TryParse(textBox_DocNumber.Text, out order_no);
            //if (order_no == 0) { MessageBox.Show("Invalid Order Number"); return; }
            textBox_DocNumber.Text = del.DocNumber.ToString();  // = order_no;
            textBox_Supplier.Text = del.SupplierID.ToString();  // = Int32.Parse(textBox_Supplier.Text);
              //  comboBox_Supplier.SelectedIndex = del.SupplierID;
            comboBox_Status.SelectedIndex = del.Status;
            textBox_Comment.Text = del.Comment;
            textBox_Employee.Text = del.EmployeeID.ToString();   // _ident.UserID.ToString();
            textBox_AuthLevel.Text = _ident.ActionLevel.ToString();
            textBox_Role.Text = _ident.Role;
            dateTimePicker1.Value = DateTime.Now;  // Parse(_po.PO_Date).ToShortDateString();
              //  dateTimePicker1.Text = DateTime.Parse(_po.PO_Date).ToShortDateString();
            if (_del.SupplierID > 0)
            {
                _supplierID = _del.SupplierID;
                textBox_Supplier.Text = _supplierID.ToString();
                FillSupplier(_supplierID.ToString());
            }
            for (int i = 0; i < del.DeliveryDetails.Count; i++)
            {
                dataGridResults.Rows.Add();
                Del_DetailItem det = del.DeliveryDetails[i];
                dataGridResults.Rows[i].Cells[0].Value = det.Del_ID;
                dataGridResults.Rows[i].Cells[1].Value = det.ProductID ;
                dataGridResults.Rows[i].Cells[2].Value = det.Quantity ;
                dataGridResults.Rows[i].Cells[3].Value = det.Price ;

            }
            //dateTimePicker1.Value  = (DateTime) del.PO_Date.ToOADate();
            //del.DeliveryDate = dateTimePicker2.Value ;
            //del.PO_Date = dateTimePicker1.Value;
            //del.DeliveryDate = dateTimePicker2.Value ;
            //del.Comment = textBox_Comment.Text;
            //if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
            //{
            //    MessageBox.Show("Start Date should not be greater than End Date"); return;
            //}
            //    string part1 = "INSERT into Deliveries values (";
        }
        private void button_FromPO_Click(object sender, EventArgs e)
        {
            //List<string> poStr = Utilities.DataBaseUtility.GetList("Select * from purchaseOrders where docnum = " + textBox_DocNumber.Text );
             //string[] fields = poStr[1].Split('\t');
             // _po = new PurchaseOrder(fields);
             // _del = new Delivery(fields);
             _ident = new IdentityObject();
             _poID_Str = textBox_DocNumber.Text.Trim();
             _poRecord = Utilities.DataBaseUtility.GetList("select * from PURCHASE_ORDERS where docnum = " + _poID_Str,',');
             if (_poRecord.Count != 2)
             {
                 MessageBox.Show("could not find purchase order :  " + _poID_Str);
                 return;
             }
             textBox_Details.Text = _poRecord[1] + "\r\n";
             //    _po = new PurchaseOrder(_poRecord[1]);
             _del = new Delivery(_poRecord[1]);
             textBox_Supplier.Text = _del.SupplierID.ToString();
             if (_ident == null) _ident = new IdentityObject("111", "Johnson", "clerk", 1, 2);
             textBox_Employee.Text = _ident.UserID.ToString();  // _del.EmployeeID.ToString();
             dateTimePicker1.Value  = DateTime.Now;  //.ToShortDateString();
             //  dateTimePicker1.Text = DateTime.Now.ToShortDateString();
             //   Parse(_po.PO_Date).ToShortDateString ();
             if (_del.SupplierID > 0)
             {
                 _supplierID = _del.SupplierID;
                 textBox_Supplier.Text = _supplierID.ToString();
                 FillSupplier(_supplierID.ToString());
                 FillProducts(_supplierID);
             }
             textBox_Comment.Text = "P. O. " + _poID_Str  + " delivery";
             // NewDelivery(_ident);
             // string _titles = String.Format("{0}\t{1}\t{2}\t{3}", "Del.ID", "prod.ID", "Quant.", "Cost");
             // textBox_Details.Text = _titles;
             List<string> detailRecords = Utilities.DataBaseUtility.GetList("select * from PurchaseOrderDetails where docnum = " + _poID_Str, ',');
             for (int i = 1; i < detailRecords.Count; i++)
             {
                 textBox_Details.Text += detailRecords[i] + "\r\n";

             }
        }
        private void button_Display_Click(object sender, EventArgs e)
        {
            try
            {

                Delivery _order = new Delivery();
                string _cmd = "Select * from " + PODConstants.DELIVERY_TABLE_NAME + " WHERE DocNum = " + textBox_DocNumber.Text + " and DocType = 13";
                DataTable _table = Utilities.DataBaseUtility.GetTable(_cmd);
                dataGridView1.DataSource = _table;
                string _supplierID = "3";
                if (_table != null && _table.Rows != null && _table.Rows.Count > 0)
                    _supplierID = _table.Rows[0][2].ToString();
                string supplierCmd = "Select * from suppliers WHERE supplierID = " + _supplierID;
                DataTable supplierTable = Utilities.DataBaseUtility.GetTable(supplierCmd);
                dataGridView2.DataSource = supplierTable;
                string detailsCmd = "Select * from " + PODConstants.DELIVERY_DETAILS_TABLE_NAME + " WHERE DocNum = " + Convert.ToInt32(textBox_DocNumber.Text) + " and DocType = 13";
                detailsTable = Utilities.DataBaseUtility.GetTable(detailsCmd);
                gboOrderStatus.Visible = true;

                _order = _order.GetDelivery(Convert.ToInt32(textBox_DocNumber.Text));
                string _supplierName = Convert.ToString(supplierTable.Rows[0]["Name"]);
                string _supplierAddress = Convert.ToString(supplierTable.Rows[0]["Address"]);
                string _supplierAddress2 = Convert.ToString(supplierTable.Rows[0]["City"]) + ", " + Convert.ToString(supplierTable.Rows[0]["State"]) + " " + Convert.ToString(supplierTable.Rows[0]["PostalCode"]);
                string _supplierPhone = Convert.ToString(supplierTable.Rows[0]["Phone"]);
                string _supplierEmail = Convert.ToString(supplierTable.Rows[0]["WebAddress"]);

                lblInvNumValue.Text = textBox_DocNumber.Text;    //_ Convert.ToString(_order.DeliveryID);
                //label_PO_Info.Text = _supplierName + "\r\n";
                label_SupplierName.Text = _supplierName;
                label_SupplierAddr.Text = _supplierAddress;
                label_SupplierAddress2.Text = _supplierAddress2;
                lblPhone.Text = Convert.ToString(_supplierPhone);
                label_ShipName.Text = "Local Bikes";
                label_ShippingAddr2.Text = "2700 Bay Area Blvd";
                label_ShipAddress.Text = "Houston, TX, 77058";
                lblDateValue.Text = _order.PO_Date.ToShortDateString();
                label_SupplierEmail.Text = _supplierEmail;
                comboBox2.SelectedIndex = _order.Status;
                label_Status.Text = "Status: " + comboBox2.SelectedItem.ToString();
                label_deliverydate.Text = _order.DeliveryDate.ToShortDateString();
                gboOrderStatus.Visible = true;
                int recnbr1 = 0;
                double partsTotal = 0.0;  //           double partsTax = 0.0;
                lvProducts.Items.Clear();
                while (recnbr1 < detailsTable.Rows.Count)
                {
                    string productCode = detailsTable.Rows[recnbr1][2].ToString();
                    _product_Names = Utilities.DataBaseUtility.GetList("Select productName from products where productID = " + productCode);
                    ListViewItem lvi = lvProducts.Items.Add(productCode);  //detailsTable.Rows[recnbr1][1].ToString());
                    if (_product_Names.Count > 1 && _product_Names[1] != null)
                    {
                        lvi.SubItems.Add(_product_Names[1]);
                    }
                    //else
                    //{
                    //    MessageBox.Show("Please check the products and inventory data, the inventory product " + productCode + " not available in products table");
                    //}
                    //lvi.SubItems.Add(detailsTable.Rows[recnbr1][2].ToString());
                    double _price = Double.Parse(detailsTable.Rows[recnbr1][6].ToString());
                    double _quant = Double.Parse(detailsTable.Rows[recnbr1][5].ToString());
                    lvi.SubItems.Add(_quant.ToString());
                    lvi.SubItems.Add(string.Format("{0:C}", _price));
                    lvi.SubItems.Add(string.Format("{0:C}", 0.00));
                    double _total = _quant * _price;
                    lvi.SubItems.Add(string.Format("{0:C}", _total));

                    partsTotal += _total;    // order.POProdDetails[recnbr1].DetailProductLineTotal;
                    recnbr1++;
                }

                lblPartsSubTotalValue.Text = string.Format("{0:C}", partsTotal);

                // int recnbr2 = 0;
                // double serviceTotal = 0.0;

                lblShippingCostValue.Text = string.Format("{0:C}", partsTotal * .04);
                double _totalCost = partsTotal + partsTotal * .04;
                lblGrandTotalValue.Text = string.Format("{0:C}", _totalCost);

                // pnlService.Visible = true;

            }
            catch (Exception ex) { MessageBox.Show("Due to invalid or old data in Database, Application could not load the Delivery doc."); }
        }
        private void LoadDelivery()
        {
            //   int poNum;
            Delivery _order = new Delivery();

            List<string> _ids = Utilities.DataBaseUtility.GetList("Select DocNum from " + PODConstants.DELIVERY_TABLE_NAME + " Where DocType = 13"); //order by PurchasOrderID");
            comboBox1.Items.Clear();
            for (int i =1; i< _ids.Count; i++)
                comboBox1.Items.Add(_ids[i]);
        }