private void CalcIR(object sender, EventArgs e, out string path, out XmlDocument xDoc, out string finalgenericone, out string hmrcirmark) { string subAsAgentIndi = ""; using (var context = new Database1Entities()) { ((System.Data.SqlClient.SqlConnection)context.Database.Connection).ConnectionString = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=" + GlobalConstants.commondocsCOMPANYDBpath + "; integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework"; var gg = from client in context.GGCredentials where client.Fk_Client_Id == GlobalConstants.clientid select new { client.ggid, client.ggpassword, client.subas, client.amend, client.savecredentials, }; if (gg.ToList().Count != 0) { if (gg.ToList()[0].subas == "" || gg.ToList()[0].subas == null) { subAsAgentIndi = "Individual"; } else { subAsAgentIndi = gg.ToList()[0].subas; } if (gg.ToList()[0].amend == "yes") { GlobalConstants.blnAmendedReturn = true; } else { GlobalConstants.blnAmendedReturn = false; } } } GlobalConstants.cl2tagappended = false; GlobalConstants.fromfbi = true; MainIndividual objMainIndividual = new MainIndividual(); objMainIndividual.btnsa302_Click(sender, e); FILINGtoHMRC objFILINGtoHMRC = new FILINGtoHMRC(); objFILINGtoHMRC.PrepareXml(); GlobalConstants.commondocsSubmissionspath = GlobalConstants.commondocsCOMPANYpath + "\\FBI.xml"; path = GlobalConstants.commondocsSubmissionspath; xDoc = new XmlDocument(); using (FileStream fs = new FileStream(path, FileMode.Open)) { xDoc.Load(fs); } //CreateIRMark(); // IDFFCYFJ6UFNDM6DLM442WLUHTBHZI3N lastsuccess byte[] hashValue; XmlDocument xDocforir = xDoc; XmlNode bodynode = xDocforir.ChildNodes.Item(1).ChildNodes.Item(3); XmlNode removeirnode = bodynode.ChildNodes.Item(0).ChildNodes.Item(0).ChildNodes.Item(2); removeirnode.ParentNode.RemoveChild(removeirnode); string postDatair = bodynode.OuterXml; int sa100end = postDatair.LastIndexOf("<MTR>"); string bodyonly = postDatair.Insert(sa100end + 5, GlobalConstants.sa102fbi); bodyonly = bodyonly.Replace("SHINTU1000000241", GlobalConstants.UTR); if (GlobalConstants.strAttach == "") { bodyonly = bodyonly.Replace("<AttachedFiles>SHINTUathachmntsSHINTU</AttachedFiles>", ""); } else { bodyonly = bodyonly.Replace("SHINTUathachmntsSHINTU", GlobalConstants.strAttach); } if (GlobalConstants.blnAmendedReturn) { bodyonly = bodyonly.Replace("<MTR>", "<MTR AmendedReturn=\"yes\">"); } if (subAsAgentIndi == "Agent") { bodyonly = bodyonly.Replace("<IndividualDeclaration>yes</IndividualDeclaration>", "<AgentDeclaration>yes</AgentDeclaration>"); } //if (cmbIndorAgent.SelectedItem.ToString() == "Agent") //{ // bodyonly = bodyonly.Replace("<IndividualDeclaration>yes</IndividualDeclaration>", "<AgentDeclaration>yes</AgentDeclaration>"); //} XmlDocument xmlDoctttt = new XmlDocument(); xmlDoctttt.LoadXml(bodyonly); XmlDsigC14NTransform xmlTransform = new XmlDsigC14NTransform(); xmlTransform.LoadInput(xmlDoctttt); MemoryStream memoryStream = (MemoryStream)xmlTransform.GetOutput(); hashValue = SHA1.Create().ComputeHash(memoryStream); finalgenericone = Convert.ToBase64String(hashValue); string b64 = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/="; string b32 = "ABCDEFGHIJKLMNOPQRSTUVWXYZ234567="; hmrcirmark = ""; string gentobytes = ""; foreach (char c in finalgenericone) { int number = b64.IndexOf(c); var binary = Convert.ToString(number, 2); gentobytes = gentobytes + binary.PadLeft(6, '0'); } for (int i = 0; i < 32; i++) { string input = gentobytes.Substring(i * 5, 5); int output = Convert.ToInt32(input, 2); hmrcirmark += b32.Substring(output, 1); } GlobalConstants.IRMARK = hmrcirmark; }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { Cursor.Current = Cursors.WaitCursor; if (e.ColumnIndex == 3) { DataGridViewRow selectedRow = null; if (dataGridView1.SelectedRows.Count > 0) { selectedRow = dataGridView1.SelectedRows[0]; } if (selectedRow == null) { return; } clientid = Convert.ToInt32(selectedRow.Cells["Reference"].Value); SAONE.GlobalConstants.clientid = clientid; MainIndividual objindividual = new MainIndividual(clientid); objindividual.ShowDialog(); } if (e.ColumnIndex == 4) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the selected Taxpayer?", GlobalConstants.prodname, MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { DataGridViewRow selectedRow = null; if (dataGridView1.SelectedRows.Count > 0) { selectedRow = dataGridView1.SelectedRows[0]; } if (selectedRow == null) { return; } clientid = Convert.ToInt32(selectedRow.Cells["Reference"].Value); SAONE.GlobalConstants.clientid = clientid; using (var context = new Database1Entities()) { ((System.Data.SqlClient.SqlConnection)context.Database.Connection).ConnectionString = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=" + GlobalConstants.commondocsCOMPANYDBpath + "; integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework"; SqlConnection CN = new SqlConnection(); CN.ConnectionString = ((System.Data.SqlClient.SqlConnection)context.Database.Connection).ConnectionString; DataTable dt = new DataTable(); CN.Open(); // SqlCommand sqlcmd = new SqlCommand("delete from SA102 where Fk_Client_Id=" + clientid, CN); SqlCommand sqlcmd = new SqlCommand("delete from client where Pk_Client_Id=" + clientid, CN); int x = sqlcmd.ExecuteNonQuery(); if (x == 1) { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); MessageBox.Show("Taxpayer deleted successfully.", GlobalConstants.prodname, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (dialogResult == DialogResult.No) { return; } } Cursor.Current = Cursors.Default; }
private void SA110_Load(object sender, EventArgs e) { // panel1.Visible = false; GlobalConstants.activeform = "sa110o"; using (var context = new Database1Entities()) { ((System.Data.SqlClient.SqlConnection)context.Database.Connection).ConnectionString = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=" + GlobalConstants.commondocsCOMPANYDBpath + "; integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework"; var sa102 = from client in context.SA110 where client.Fk_Client_Id == GlobalConstants.clientid select new { client.CAL1, client.CAL2, client.CAL3, client.CAL4, client.CAL4p1, client.CAL5, client.CAL6, client.CAL7, client.CAL8, client.CAL9, client.CAL10, client.CAL11, client.CAL12, client.CAL13, client.CAL14, client.CAL15, client.CAL16, client.CAL17, }; if (sa102.ToList().Count == 0) { return; } CAL1.MyText = sa102.ToList()[0].CAL1; CAL2.MyText = sa102.ToList()[0].CAL2; CAL3.MyText = sa102.ToList()[0].CAL3; CAL4.MyText = sa102.ToList()[0].CAL4; CAL4p1.MyText = sa102.ToList()[0].CAL4p1; CAL5.MyText = sa102.ToList()[0].CAL5; CAL6.MyText = sa102.ToList()[0].CAL6; GlobalConstants.fromfbi = true; MainIndividual objMainIndividual = new MainIndividual(); objMainIndividual.btnsa302_Click(sender, e); CAL1.MyText = GlobalConstants.CAL1 >= 0 ? string.Format("{0:F2}", GlobalConstants.CAL1) : ""; CAL2.MyText = GlobalConstants.CAL1 < 0 ? string.Format("{0:F2}", Math.Abs(GlobalConstants.CAL1)) : ""; CAL3.MyText = GlobalConstants.CAL3 > 0 ? string.Format("{0:F2}", GlobalConstants.CAL3) : ""; CAL4.MyText = GlobalConstants.CAL4 >= 0 ? string.Format("{0:F2}", GlobalConstants.CAL4) : ""; CAL5.MyText = GlobalConstants.CAL5 > 0 ? string.Format("{0:F2}", GlobalConstants.CAL5) : ""; CAL6.MyText = GlobalConstants.CAL6 > 0 ? string.Format("{0:F2}", GlobalConstants.CAL6) : ""; CAL7.MyText = sa102.ToList()[0].CAL7; CAL8.MyText = sa102.ToList()[0].CAL8; CAL9.MyText = sa102.ToList()[0].CAL9; if (sa102.ToList()[0].CAL10 == "yes") { CAL10.Checked = true; } CAL11.MyText = sa102.ToList()[0].CAL11; CAL12.MyText = sa102.ToList()[0].CAL12; CAL13.MyText = sa102.ToList()[0].CAL13; CAL14.MyText = sa102.ToList()[0].CAL14; CAL15.MyText = sa102.ToList()[0].CAL15; CAL16.MyText = sa102.ToList()[0].CAL16; CAL17.Text = sa102.ToList()[0].CAL17; } }