Esempio n. 1
0
        private void btnUpdateField_Click(object sender, EventArgs e)
        {
            // testing purposes
            foreach (DataRow dr in currentDataSet.Rows)
            {
                string t1 = dr[1].ToString();
                Console.WriteLine("data table row => " + t1);
            }

            if (datagridDidPress)
            {
                try
                {
                    string cbText = cbUpdateField.SelectedItem.ToString();
                    Console.WriteLine("CB update => " + cbText);

                    if (JRF.GotInListStr(currentUpdateOption, cbText))
                    {
                        // proceed MySql operation
                        Console.WriteLine("update panel => " + currentPanel + "=> " + currentID);
                        switch (currentPanel)
                        {
                        case "Order":
                            int haha = JobOp.UpdateOrder(currentID, cbText);
                            try
                            {
                                currentDataSet = JRFdataset.Table.getAllOrders().Tables[0];
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show("No Data");
                            }

                            MessageBox.Show("Update Done");
                            dgvDbTable.DataSource = currentDataSet;
                            dgvDbTable.Refresh();
                            break;

                        default: break;
                        }
                    }
                    else
                    {
                        ErrorMsg.UpdateOptionInvalid();
                    }
                }
                catch (Exception ex)
                {
                    ErrorMsg.UpdateOptionNoSelect();
                }
            }
            else
            {
                ErrorMsg.PlsSelectRow();
            }
        }