private void BtnCancelApplication_Click(object sender, EventArgs e)
        {
            //get checked columns
            DataTable dt = uIUtility.GetCheckedValuesForMail();

            //send to web service
            frmUsageApplicationListController oController = new frmUsageApplicationListController();

            try
            {
                if (dt.Rows.Count > 0)
                {
                    DataTable result = oController.SubmitApplicationCancel(dt, out uIUtility.MetaData);

                    //update data grid view
                    uIUtility.UpdateReturnedresults(result);
                }
            }
            catch (System.TimeoutException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (System.Net.WebException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                Utility.WriteErrorLog(ex.Message, ex, false);
                MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void BtnUpdate_Click(object sender, EventArgs e)
        {
            //get column values where MK not null or empty
            DataTable dt = uIUtility.SubmitChanges();

            //send to web service
            frmUsageApplicationListController oController = new frmUsageApplicationListController();

            try
            {
                DataTable result = oController.Submit(dt, out uIUtility.MetaData);

                //update data grid view
                uIUtility.UpdateReturnedresults(result);
            }
            catch (System.TimeoutException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (System.Net.WebException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                Utility.WriteErrorLog(ex.Message, ex, false);
                MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 //fetch sub program names from this from
 private void getSubProgramNames()
 {
     try
     {
         frmUsageApplicationListController oController = new frmUsageApplicationListController();
         SUBPROGRAMS = oController.getSubProgramList();
     }
     catch (Exception ex)
     {
         Utility.WriteErrorLog(ex.Message, ex, false);
     }
 }
        private void BindGrid()
        {
            try
            {
                string COMPANY_NO_BOX, COMPANY_NAME, CLOSE_FLG, GD, REQUEST_STATUS, REQ_DATE_FROM, REQ_DATE_TO, QUOTATION_DATE_FROM, QUOTATION_DATE_TO, ORDER_DATE_FROM, ORDER_DATE_TO, SYSTEM_SETTING_STATUS;

                if (ValidateInputs(out COMPANY_NO_BOX, out COMPANY_NAME, out CLOSE_FLG, out GD, out REQUEST_STATUS, out REQ_DATE_FROM, out REQ_DATE_TO, out QUOTATION_DATE_FROM, out QUOTATION_DATE_TO, out ORDER_DATE_FROM, out ORDER_DATE_TO, out SYSTEM_SETTING_STATUS))
                {
                    frmUsageApplicationListController oController = new frmUsageApplicationListController();

                    DataTable dt = oController.GetApplicationList(COMPANY_NO_BOX, COMPANY_NAME, CLOSE_FLG, GD, REQUEST_STATUS, REQ_DATE_FROM, REQ_DATE_TO, QUOTATION_DATE_FROM, QUOTATION_DATE_TO, ORDER_DATE_FROM, ORDER_DATE_TO, SYSTEM_SETTING_STATUS, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData);
                    if (dt.Rows.Count > 0)
                    {
                        uIUtility.dtList   = dt;
                        dgvList.DataSource = uIUtility.dtList;
                        uIUtility.dtOrigin = uIUtility.dtList.Copy();

                        //pagination
                        uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords);
                    }
                    else
                    {
                        //clear data except headers
                        uIUtility.ClearDataGrid();
                        uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords);
                    }

                    uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text);

                    //check for disable flag
                    uIUtility.CheckForDisableField();
                    uIUtility.FormatUpdatedat();
                }
            }
            catch (System.TimeoutException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (System.Net.WebException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                Utility.WriteErrorLog(ex.Message, ex, false);
                MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void BtnGDConfirmationComplete_Click(object sender, EventArgs e)
        {
            try
            {
                //get checked columns
                DataTable dt = uIUtility.GetCheckedValuesForMail();

                if (dt.Rows.Count > 0)
                {
                    var confirmResult = MetroMessageBox.Show(this, "\n" + "メール送信しますか?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                    if (confirmResult == DialogResult.OK)
                    {
                        //Show mail progress message
                        Thread mailthread = new Thread(new ThreadStart(ShowMailLoading));
                        mailthread.Start();

                        //send to web service
                        frmUsageApplicationListController oController = new frmUsageApplicationListController();

                        DataTable result = oController.SubmitConfirmationComplete(dt, out uIUtility.MetaData);

                        //update data grid view
                        uIUtility.UpdateReturnedresults(result);

                        mailthread.Abort();
                    }
                }
            }
            catch (System.TimeoutException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (System.Net.WebException)
            {
                MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                Utility.WriteErrorLog(ex.Message, ex, false);
                MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }