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()); } }
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; } }
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()); } }
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); } }