private void LoadYA()
        {
            DataTable dtData = null;

            switch (strFormType)
            {
            case "C":
            case "R":
                EFilingDAL dal = new EFilingDAL();
                dtData = dal.GetYA();
                break;

            case "B":
            case "BE":
            case "M":
                EFilingDALB dalB = new EFilingDALB();
                dtData = dalB.GetYA();
                break;

            case "P":
                EFilingDALB dalP = new EFilingDALB();
                dtData = dalP.GetYA();
                break;

            //PANYW CP204
            case "CP204":
                EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                dtData = dalCP204.GetYA();
                break;

            //PANYW CP204 END
            //NGOHCS CP204A
            case "CP204A":
                EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                dtData = dalCP204A.GetYA();
                break;

            //NGOHCS CP204A END
            default:
                EFilingDAL dalC = new EFilingDAL();
                dtData = dalC.GetYA();
                break;
            }
            toolStripCboYA.Items.Clear();
            foreach (DataRow drData in dtData.Rows)
            {
                toolStripCboYA.Items.Add(drData[0].ToString());
            }
        }
Example #2
0
        private void PopulateTaxPayer()
        {
            dgTaxPayer.DataSource = null;

            switch (cboForm.Text)
            {
            case "C":
            case "R":
                EFilingDAL dal = new EFilingDAL();
                //dgTaxPayer.DataSource = dal.GetTaxPayer(cboYA.Text);
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dal.GetTaxPayer(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dal.GetTaxPayerName(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dal.GetTaxPayerAll(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                break;

            case "B":
            case "BE":
                EFilingDALB dalB = new EFilingDALB();
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalB.GetTaxPayerB(toolStripTxtText.Text.ToString());   //dalB.GetTaxPayerB(cboYA.Text);
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalB.GetTaxPayerBName(toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalB.GetTaxPayerBAll(toolStripTxtText.Text.ToString());
                }
                break;

            case "M":
                EFilingDALB dalM = new EFilingDALB();
                //dgTaxPayer.DataSource = dalM.GetTaxPayerM(cboYA.Text);
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalM.GetTaxPayerM(toolStripTxtText.Text.ToString());   //dalB.GetTaxPayerB(cboYA.Text);
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalM.GetTaxPayerMName(toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalM.GetTaxPayerMAll(toolStripTxtText.Text.ToString());
                }
                break;

            case "P":
                EFilingDALP dalP = new EFilingDALP();
                //dgTaxPayer.DataSource = dalP.GetTaxPayer();
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalP.GetTaxPayer(toolStripTxtText.Text.ToString());   //dalB.GetTaxPayerB(cboYA.Text);
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalP.GetTaxPayerName(toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalP.GetTaxPayerAll(toolStripTxtText.Text.ToString());
                }
                break;

            //PANYW CP204
            case "CP204":
                EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalCP204.GetCP204TaxPayer(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalCP204.GetCP204TaxPayerName(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalCP204.GetCP204TaxPayerAll(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                break;

            //PANYW CP204
            case "CP204A":
                EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalCP204A.GetCP204ATaxPayer(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalCP204A.GetCP204ATaxPayerName(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalCP204A.GetCP204ATaxPayerAll(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                break;

            default:
                EFilingDAL dalC = new EFilingDAL();
                //dgTaxPayer.DataSource = dalC.GetTaxPayer(cboYA.Text);
                if (toolStripCboBy.Text == "Reference No" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalC.GetTaxPayer(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "Name" && toolStripTxtText.Text != "")
                {
                    dgTaxPayer.DataSource = dalC.GetTaxPayerName(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                if (toolStripCboBy.Text == "-All Record-")
                {
                    dgTaxPayer.DataSource = dalC.GetTaxPayerAll(cboYA.Text, toolStripTxtText.Text.ToString());
                }
                break;
            }
        }
Example #3
0
        private void LoadData()
        {
            DataTable dtData = new DataTable();

            cboAuditor.Items.Clear();
            cboTaxAgent.Items.Clear();

            switch (cboForm.Text)
            {
            case "C":
                EFilingDAL dal = new EFilingDAL();
                dtData = dal.GetAuditor();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboAuditor.Items.Add(drData[0].ToString());
                }
                dtData = dal.GetTaxAgent();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboTaxAgent.Items.Add(drData[0].ToString());
                }
                dtData = dal.GetYA();
                break;

            case "R":
                EFilingDAL dalR = new EFilingDAL();
                dtData = dalR.GetAuditor();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboAuditor.Items.Add(drData[0].ToString());
                }
                dtData = dalR.GetYA();
                break;

            case "B":
            case "BE":
            case "M":
                EFilingDALB dalB = new EFilingDALB();
                dtData = dalB.GetTaxAgent();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboTaxAgent.Items.Add(drData[0].ToString());
                }
                dtData = dalB.GetYA();
                break;

            case "P":
                EFilingDALB dalP = new EFilingDALB();
                dtData = dalP.GetTaxAgent();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboTaxAgent.Items.Add(drData[0].ToString());
                }
                dtData = dalP.GetYA();
                break;

            //PANYW CP204
            case "CP204":
                EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                dtData = dalCP204.GetTaxAgent();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboTaxAgent.Items.Add(drData[0].ToString());
                }
                dtData = dalCP204.GetYA();
                break;

            //PANYW CP204 END
            default:
                EFilingDAL dalC = new EFilingDAL();
                dtData = dalC.GetAuditor();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboAuditor.Items.Add(drData[0].ToString());
                }
                dtData = dalC.GetTaxAgent();
                foreach (DataRow drData in dtData.Rows)
                {
                    cboTaxAgent.Items.Add(drData[0].ToString());
                }
                dtData = dalC.GetYA();
                break;
            }
            if (cboTaxAgent.Items.Count > 0)
            {
                cboTaxAgent.SelectedIndex = 0;
            }
            cboYA.Items.Clear();
            foreach (DataRow drData in dtData.Rows)
            {
                cboYA.Items.Add(drData[0].ToString());
                toolStripCboYA.Items.Add(drData[0].ToString());
            }
            //azham change ========================= 16-mar-2016
            if (cboForm.Text == "C")
            {
                toolStripCboYA.Text = "2017";
                cboYA.Text          = "2017";
            }
            else if (cboForm.Text == "R")
            {
                toolStripCboYA.Text = "2017";
                cboYA.Text          = "2017";
            }
            else
            {
                toolStripCboYA.Text = "2016";
                cboYA.Text          = "2016";
            }
            //   toolStripCboYA.Text = string.Format(Date.Now, "yyyy");
            //  cboYA.Text = string.Format(Date.Now, "yyyy");
            //azham change ========================= 16-mar-2016


            if (cboAuditor.Items.Count > 0)
            {
                cboAuditor.SelectedIndex = 0;
            }
        }
        public void PopulateDG()
        {
            dgEFURL.DataSource = null;
            switch (strFormType)
            {
            case "C":
            case "R":
                EFilingDAL dal = new EFilingDAL();
                //PANYW CP204  **Due to CP204
                String[] strArrayCR = new string[2];
                strArrayCR[0]      = "C";
                strArrayCR[1]      = "R";
                dgEFURL.DataSource = dal.LoadAllURL(strArrayCR, toolStripCboYA.Text);
                //PANYW CP204 END
                break;

            case "B":
                EFilingDALB dalB = new EFilingDALB();
                dgEFURL.DataSource = dalB.LoadAllURL("B", toolStripCboYA.Text);
                break;

            case "BE":
                EFilingDALB dalBE = new EFilingDALB();
                dgEFURL.DataSource = dalBE.LoadAllURL("BE", toolStripCboYA.Text);
                break;

            case "M":
                EFilingDALB dalM = new EFilingDALB();
                dgEFURL.DataSource = dalM.LoadAllURL("M", toolStripCboYA.Text);
                break;

            case "P":
                EFilingDALP dalP = new EFilingDALP();
                dgEFURL.DataSource = dalP.LoadAllURL(toolStripCboYA.Text);
                break;

            //PANYW CP204
            case "CP204":
                String[] strArrayCP204 = new string[1];
                strArrayCP204[0] = "CP204";
                EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                dgEFURL.DataSource = dalCP204.LoadAllURL(strArrayCP204, toolStripCboYA.Text);
                break;

            //PANYW CP204
            //NGOHCS CP204A
            case "CP204A":
                String[] strArrayCP204A = new string[1];
                strArrayCP204A[0] = "CP204A";
                EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                dgEFURL.DataSource = dalCP204A.LoadAllURL(strArrayCP204A, toolStripCboYA.Text);
                break;

            //NGOHCS CP204A
            default:
                EFilingDAL dalC = new EFilingDAL();
                dgEFURL.DataSource = dalC.LoadAllURL(toolStripCboYA.Text);
                break;
            }
            dgEFURL.Refresh();
        }
        private void tsbtnDeleteAll_Click(object sender, EventArgs e)
        {
            DialogResult dialogResponse;

            dialogResponse = MessageBox.Show("Delete all record?", "TAXcom E-Filing", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (dialogResponse == DialogResult.Yes)
            {
                string[] strData = new string[2];
                switch (strFormType)
                {
                case "BE":
                case "B":
                case "M":
                    EFilingDALB dalB = new EFilingDALB();
                    strData[0] = toolStripCboYA.Text;
                    strData[1] = strFormType;
                    if (dalB.Execute(strData, "DELALL") > 0)
                    {
                        MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    else
                    {
                        MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "C":
                case "R":
                    EFilingDAL dal = new EFilingDAL();
                    strData[0] = toolStripCboYA.Text;
                    strData[1] = strFormType;
                    if (dal.Execute(strData, "DELALL") > 0)
                    {
                        MessageBox.Show("URL for Form C deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    if (dal.Execute(strData, "DELALLR") > 0)
                    {
                        MessageBox.Show("URL for Form R deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    else
                    {
                        MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "P":
                    EFilingDALP dalP = new EFilingDALP();
                    strData[0] = toolStripCboYA.Text;
                    strData[1] = strFormType;
                    if (dalP.Execute(strData, "DELALL") > 0)
                    {
                        MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    else
                    {
                        MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "CP204":
                    EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                    strData[0] = toolStripCboYA.Text;
                    strData[1] = strFormType;
                    if (dalCP204.Execute(strData, "DELALL") > 0)
                    {
                        MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    else
                    {
                        MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "CP204A":
                    EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                    strData[0] = toolStripCboYA.Text;
                    strData[1] = strFormType;
                    if (dalCP204A.Execute(strData, "DELALL") > 0)
                    {
                        MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        PopulateDG();
                    }
                    else
                    {
                        MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;
                }
            }
        }
        private void tsbtnDelete_Click(object sender, EventArgs e)
        {
            if (dgEFURL.SelectedRows.Count > 0)
            {
                DialogResult dialogResponse;
                dialogResponse = MessageBox.Show("Delete selected record?", "TAXcom E-Filing", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialogResponse == DialogResult.Yes)
                {
                    string[] strData = new string[1];
                    switch (strFormType)
                    {
                    case "C":
                    case "R":
                        EFilingDAL dal = new EFilingDAL();
                        strData[0] = dgEFURL.SelectedRows[0].Cells[2].Value.ToString();
                        if (dal.Execute(strData, "DEL") > 0)
                        {
                            MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            PopulateDG();
                        }
                        else
                        {
                            MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        break;

                    case "B":
                    case "BE":
                    case "M":
                        EFilingDALB dalB = new EFilingDALB();
                        strData[0] = dgEFURL.SelectedRows[0].Cells[2].Value.ToString();
                        if (dalB.Execute(strData, "DEL") > 0)
                        {
                            MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            PopulateDG();
                        }
                        else
                        {
                            MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        break;

                    case "P":
                        EFilingDALP dalP = new EFilingDALP();
                        strData[0] = dgEFURL.SelectedRows[0].Cells[2].Value.ToString();
                        if (dalP.Execute(strData, "DEL") > 0)
                        {
                            MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            PopulateDG();
                        }
                        else
                        {
                            MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        break;

                    //PANYW CP204
                    case "CP204":
                        EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                        strData[0] = dgEFURL.SelectedRows[0].Cells[2].Value.ToString();
                        if (dalCP204.Execute(strData, "DEL") > 0)
                        {
                            MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            PopulateDG();
                        }
                        else
                        {
                            MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        break;

                    //PANYW CP204 END
                    //NGOHCS CP204A
                    case "CP204A":
                        EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                        strData[0] = dgEFURL.SelectedRows[0].Cells[2].Value.ToString();
                        if (dalCP204A.Execute(strData, "DEL") > 0)
                        {
                            MessageBox.Show("URL deleted!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            PopulateDG();
                        }
                        else
                        {
                            MessageBox.Show("Deletes of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        break;
                        //NGOHCS CP204A END
                    }
                }
            }
            else
            {
                MessageBox.Show("Please select a record to delete!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
        private void ProcessFormCP204(mshtml.HTMLDocument htmlDoc, String strPageIndex)
        {
            try
            {
                EFilingDALCP204 dal    = new EFilingDALCP204(strTaxPayer, strYA, strAuditor, strTaxAgent);
                DataSet         dsData = dal.GetFormDataCP204(strPageIndex);
                dal.CloseConn();
                Boolean boolPindaan = false;
                //Boolean boolNoRecord = false;

                if (dsData.Tables["P1_BORANG_CP204"].Rows.Count > 0)
                {
                    #region "INPUT"
                    foreach (mshtml.HTMLInputElement inpElement in htmlDoc.getElementsByTagName("input"))
                    {
                        //switch (strPageIndex)
                        //{
                        #region "Page 1"
                        //case "CP2042009Page1":

                        string[] arrCorrespondAddress  = new string[3];
                        string[] arrCorrespondAddress2 = new string[3];
                        string[] arrTaxAgentAddress    = new string[3];

                        arrCorrespondAddress[0] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[0].ToString();
                        arrCorrespondAddress[1] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[1].ToString();
                        arrCorrespondAddress[2] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[2].ToString();
                        arrCorrespondAddress    = TextSpliterAddress(arrCorrespondAddress, 30);

                        if (!String.IsNullOrEmpty(dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[6].ToString()))
                        {
                            arrCorrespondAddress2[0] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[6].ToString();
                            arrCorrespondAddress2[1] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[7].ToString();
                            arrCorrespondAddress2[2] = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[8].ToString();
                            arrCorrespondAddress2    = TextSpliterAddress(arrCorrespondAddress2, 30);
                            boolPindaan = true;
                        }

                        arrTaxAgentAddress[0] = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[0].ToString();
                        arrTaxAgentAddress[1] = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[1].ToString();
                        arrTaxAgentAddress[2] = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[2].ToString();
                        arrTaxAgentAddress    = TextSpliterAddress(arrTaxAgentAddress, 30);

                        switch (inpElement.name)
                        {
                        case "btnPindaan":
                            FireInpElementEvent(inpElement, "onclick");
                            break;

                        case "txtAlamat1":
                            if (boolPindaan)
                            {
                                inpElement.value = arrCorrespondAddress2[0].ToUpper();
                            }
                            else
                            {
                                inpElement.value = arrCorrespondAddress[0].ToUpper();
                            }
                            break;

                        case "txtAlamat2":
                            if (boolPindaan)
                            {
                                inpElement.value = arrCorrespondAddress2[1].ToUpper();
                            }
                            else
                            {
                                inpElement.value = arrCorrespondAddress[1].ToUpper();
                            }
                            break;

                        case "txtAlamat3":
                            if (boolPindaan)
                            {
                                inpElement.value = arrCorrespondAddress2[2].ToUpper();
                            }
                            else
                            {
                                inpElement.value = arrCorrespondAddress[2].ToUpper();
                            }
                            break;

                        case "txtPoskod":
                            if (boolPindaan)
                            {
                                inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[9].ToString();
                            }
                            else
                            {
                                inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[3].ToString();
                            }
                            break;

                        case "txtBandar":
                            if (boolPindaan)
                            {
                                inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[10].ToString().ToUpper();
                                FireInpElementEvent(inpElement, "onchange");
                            }
                            else
                            {
                                inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[4].ToString().ToUpper();
                                FireInpElementEvent(inpElement, "onchange");
                            }
                            break;

                        case "txtAnggaran_Cukai2":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[12].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        //case "btnPindaanSME": //weihong
                        //if (!String.IsNullOrEmpty(dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[23].ToString()))
                        //{
                        //    FireInpElementEvent(inpElement, "onclick");
                        //}
                        //break;
                        case "txtTarikh_SyktBaru":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[13].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "TxtThnPertama":             //weihong Status SME FROM
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[23].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "TxtThnKedua":             //weihong Status SME TO
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[24].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Perakaunan1":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[15].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Perakaunan2":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[16].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Asas1":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[17].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Asas2":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[18].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Asas3":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[19].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Asas4":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[20].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_Asas5":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[21].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtTmph_asas6":
                            inpElement.value = dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[22].ToString();
                            FireInpElementEvent(inpElement, "onblur");
                            break;

                        case "txtAgAdd1":
                            inpElement.value = arrTaxAgentAddress[0].ToUpper();
                            break;

                        case "txtAgAdd2":
                            inpElement.value = arrTaxAgentAddress[1].ToUpper();
                            break;

                        case "txtAgAdd3":
                            inpElement.value = arrTaxAgentAddress[2].ToUpper();
                            break;

                        case "txtAgPostcode":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[3].ToString();
                            break;

                        case "txtAgCity":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[4].ToString().ToUpper();
                            break;

                        case "txtAgTelephone":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[6].ToString();
                            break;

                        case "txtAgDaftar":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[7].ToString().ToUpper();
                            break;

                        case "txtAgEmail":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[8].ToString().ToUpper();
                            break;

                        case "txtNo_Telefon":
                            inpElement.value = dsData.Tables["P1_FIRM"].Rows[0].ItemArray[6].ToString().ToUpper();
                            break;
                        }
                        //break;

                        #endregion
                        //}
                    }
                    //if (boolNoRecord)
                    //{
                    //    MessageBox.Show("No record found for current document.", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    //}
                    #endregion

                    #region "SELECT"
                    foreach (mshtml.HTMLSelectElement selElement in htmlDoc.getElementsByTagName("select"))
                    {
                        //switch (strPageIndex)
                        //{
                        #region "Page 1"
                        //case "CP2042009Page1":
                        switch (selElement.name)
                        {
                        case "ddlNegeri":
                            if (boolPindaan)
                            {
                                selElement.value = SelectState(dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[11].ToString());
                            }
                            else
                            {
                                selElement.value = SelectState(dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[5].ToString());
                            }
                            break;

                        case "ddlStatus_Akaun":
                            if (dsData.Tables["P1_BORANG_CP204"].Rows[0].ItemArray[14].ToString() == "1")
                            {
                                selElement.value = "Ya";
                                FireSelElementEvent(selElement, "onblur");
                            }
                            else
                            {
                                selElement.value = "Tidak";
                                FireSelElementEvent(selElement, "onblur");
                            }
                            break;

                        case "ddlAgState":
                            selElement.value = SelectState(dsData.Tables["P1_FIRM"].Rows[0].ItemArray[5].ToString());
                            break;
                        }
                        //break;

                        #endregion
                        //}
                    }
                    //if (boolNoRecord)
                    //{
                    //    MessageBox.Show("No record found for current document.", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    //}
                    #endregion
                }
                else
                {
                    MessageBox.Show("No record found for current document.", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Example #8
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (txtURL.Text.Trim().Length > 0 && cboYA.Text.Trim().Length > 0 && cboForm.Text.Length > 0)
            {
                switch (cboForm.Text)
                {
                case "C":
                case "R":
                    EFilingDAL dal = new EFilingDAL();
                    if (dal.VerifyYA(cboYA.Text) == true)
                    {
                        int intStatus;
                        if (boolEditMode)
                        {
                            string[] strData = new string[2];
                            strData[0] = txtURL.Text.Trim().ToLower();
                            strData[1] = strIndex;
                            intStatus  = dal.Execute(strData, "UPD");
                        }
                        else
                        {
                            if (dal.VerifyURL(txtURL.Text.Trim(), cboYA.Text, cboForm.Text) == false)
                            {
                                int      intCount     = int.Parse(dal.GetRecCount(cboYA.Text, cboForm.Text)) + 1;
                                string   strPageIndex = cboForm.Text + cboYA.Text + "Page" + intCount.ToString();
                                string[] strData      = new string[4];
                                strData[0] = txtURL.Text.Trim().ToLower();
                                strData[1] = cboYA.Text;
                                strData[2] = strPageIndex;
                                strData[3] = cboForm.Text;
                                intStatus  = dal.Execute(strData, "ADD");
                            }
                            else
                            {
                                MessageBox.Show("URL existed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                                return;
                            }
                        }

                        if (intStatus > 0)
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("URL updated!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("URL added!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            frmParent.PopulateDG();
                            this.Close();
                        }
                        else
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("Updates of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                            else
                            {
                                MessageBox.Show("Adding of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Invalid Year of Assessment!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                //PANYW CP204
                case "CP204":
                    EFilingDALCP204 dalCP204 = new EFilingDALCP204();
                    if (dalCP204.VerifyYA(cboYA.Text) == true)
                    {
                        int intStatus;
                        if (boolEditMode)
                        {
                            string[] strData = new string[2];
                            strData[0] = txtURL.Text.Trim().ToLower();
                            strData[1] = strIndex;
                            intStatus  = dalCP204.Execute(strData, "UPD");
                        }
                        else
                        {
                            if (dalCP204.VerifyURL(txtURL.Text.Trim(), cboYA.Text, cboForm.Text) == false)
                            {
                                int      intCount     = int.Parse(dalCP204.GetRecCount(cboYA.Text, cboForm.Text)) + 1;
                                string   strPageIndex = cboForm.Text + cboYA.Text + "Page" + intCount.ToString();
                                string[] strData      = new string[4];
                                strData[0] = txtURL.Text.Trim().ToLower();
                                strData[1] = cboYA.Text;
                                strData[2] = strPageIndex;
                                strData[3] = cboForm.Text;
                                intStatus  = dalCP204.Execute(strData, "ADD");
                            }
                            else
                            {
                                MessageBox.Show("URL existed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                                return;
                            }
                        }

                        if (intStatus > 0)
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("URL updated!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("URL added!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            frmParent.PopulateDG();
                            this.Close();
                        }
                        else
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("Updates of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                            else
                            {
                                MessageBox.Show("Adding of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Invalid Year of Assessment!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                //PANYW CP204 END
                case "CP204A":
                    EFilingDALCP204A dalCP204A = new EFilingDALCP204A();
                    if (dalCP204A.VerifyYA(cboYA.Text) == true)
                    {
                        int intStatus;
                        if (boolEditMode)
                        {
                            string[] strData = new string[2];
                            strData[0] = txtURL.Text.Trim().ToLower();
                            strData[1] = strIndex;
                            intStatus  = dalCP204A.Execute(strData, "UPD");
                        }
                        else
                        {
                            if (dalCP204A.VerifyURL(txtURL.Text.Trim(), cboYA.Text, cboForm.Text) == false)
                            {
                                int      intCount     = int.Parse(dalCP204A.GetRecCount(cboYA.Text, cboForm.Text)) + 1;
                                string   strPageIndex = cboForm.Text + cboYA.Text + "Page" + intCount.ToString();
                                string[] strData      = new string[4];
                                strData[0] = txtURL.Text.Trim().ToLower();
                                strData[1] = cboYA.Text;
                                strData[2] = strPageIndex;
                                strData[3] = cboForm.Text;
                                intStatus  = dalCP204A.Execute(strData, "ADD");
                            }
                            else
                            {
                                MessageBox.Show("URL existed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                                return;
                            }
                        }

                        if (intStatus > 0)
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("URL updated!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("URL added!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            frmParent.PopulateDG();
                            this.Close();
                        }
                        else
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("Updates of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                            else
                            {
                                MessageBox.Show("Adding of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Invalid Year of Assessment!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "B":
                case "BE":
                case "M":
                    EFilingDALB dalB = new EFilingDALB();
                    if (dalB.VerifyYA(cboYA.Text) == true)
                    {
                        int intStatus;
                        if (boolEditMode)
                        {
                            string[] strData = new string[2];
                            strData[0] = txtURL.Text.Trim().ToLower();
                            strData[1] = strIndex;
                            intStatus  = dalB.Execute(strData, "UPD");
                        }
                        else
                        {
                            if (dalB.VerifyURL(txtURL.Text.Trim(), cboYA.Text, cboForm.Text) == false)
                            {
                                int      intCount     = int.Parse(dalB.GetRecCount(cboYA.Text, cboForm.Text)) + 1;
                                string   strPageIndex = cboForm.Text + cboYA.Text + "Page" + intCount.ToString();
                                string[] strData      = new string[4];
                                strData[0] = txtURL.Text.Trim().ToLower();
                                strData[1] = cboYA.Text;
                                strData[2] = strPageIndex;
                                strData[3] = cboForm.Text;
                                intStatus  = dalB.Execute(strData, "ADD");
                            }
                            else
                            {
                                MessageBox.Show("URL existed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                                return;
                            }
                        }

                        if (intStatus > 0)
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("URL updated!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("URL added!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            frmParent.PopulateDG();
                            this.Close();
                        }
                        else
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("Updates of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                            else
                            {
                                MessageBox.Show("Adding of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Invalid Year of Assessment!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;

                case "P":
                    EFilingDALP dalP  = new EFilingDALP();
                    EFilingDALB dalB2 = new EFilingDALB();
                    if (dalB2.VerifyYA(cboYA.Text) == true)
                    {
                        int intStatus;
                        if (boolEditMode)
                        {
                            string[] strData = new string[2];
                            strData[0] = txtURL.Text.Trim().ToLower();
                            strData[1] = strIndex;
                            intStatus  = dalP.Execute(strData, "UPD");
                        }
                        else
                        {
                            if (dalP.VerifyURL(txtURL.Text.Trim(), cboYA.Text, cboForm.Text) == false)
                            {
                                int      intCount     = int.Parse(dalP.GetRecCount(cboYA.Text, cboForm.Text)) + 1;
                                string   strPageIndex = cboForm.Text + cboYA.Text + "Page" + intCount.ToString();
                                string[] strData      = new string[4];
                                strData[0] = txtURL.Text.Trim().ToLower();
                                strData[1] = cboYA.Text;
                                strData[2] = strPageIndex;
                                strData[3] = cboForm.Text;
                                intStatus  = dalP.Execute(strData, "ADD");
                            }
                            else
                            {
                                MessageBox.Show("URL existed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                                return;
                            }
                        }

                        if (intStatus > 0)
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("URL updated!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("URL added!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            frmParent.PopulateDG();
                            this.Close();
                        }
                        else
                        {
                            if (boolEditMode)
                            {
                                MessageBox.Show("Updates of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                            else
                            {
                                MessageBox.Show("Adding of URL failed!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Invalid Year of Assessment!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    break;
                }
            }
            else
            {
                MessageBox.Show("Please complete all the fields!", "TAXcom E-Filing", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }