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