/// <summary> /// Tax -Adds a employer quarter data in agent list to create file /// </summary> /// <returns></returns> public ArrayList AddEmployerToAgentList() { ArrayList larrResult = new ArrayList(); ValidateForm(); iclbAgentData = new Collection <busWageFileGeneratorEmployerData>(); busWageFileGeneratorEmployerData lbusWageFileGeneratorEmployerData = new busWageFileGeneratorEmployerData(); busAgentFileDataItems lbusAgentFileDataItem = iclbAgentFileData.Pop(); lbusWageFileGeneratorEmployerData.istrEAN = lbusAgentFileDataItem.istrEAN; lbusWageFileGeneratorEmployerData.istrFEIN = lbusAgentFileDataItem.istrFEIN; int.TryParse(lbusAgentFileDataItem.istrReportQuarter, out iintQuarter); lbusWageFileGeneratorEmployerData.iintReportQuarter = iintQuarter; int.TryParse(lbusAgentFileDataItem.istrReportYear, out iintYear); lbusWageFileGeneratorEmployerData.iintReportYear = iintYear; int.TryParse(lbusAgentFileDataItem.istrSSNCounts, out iintSSNCounts); lbusWageFileGeneratorEmployerData.iintSSNCounts = iintSSNCounts; lbusWageFileGeneratorEmployerData.istrEmployerName = istrEmployerAgentName; iclbAgentData.Add(lbusWageFileGeneratorEmployerData); istrReportYear = istrReportQuarter = istrSSNCount = iintEAN = istrFEIN = string.Empty; return(larrResult); }
private void btnGenerate_Click(object sender, EventArgs e) { string[] strArr; InitiliazeDataConnection(); connection.Open(); objWageFileGenerator.iclbAgentFileData = new Stack <busAgentFileDataItems>(); int i = 0, j = 0; // 1. Check if file is present and is not empty foreach (string line in File.ReadLines(FName)) { if (i == 0) { strArr = line.Split(','); // 2. Check if first element matches one of the predefined file types // 3. Check if second element matches one of the predefined user types (employer/agent) objWageFileGenerator.istrFileType = strArr[0].ToUpper(); objWageFileGenerator.istrUserType = strArr[1].ToLower(); Array.Clear(strArr, 0, strArr.Length); i++; } else if (objWageFileGenerator.istrUserType == "employer") { // 4. Validate all the data. strArr = line.Split(','); objWageFileGenerator.iintEAN = strArr[0]; objWageFileGenerator.istrFEIN = strArr[1]; objWageFileGenerator.istrReportQuarter = strArr[2]; objWageFileGenerator.istrReportYear = strArr[3]; objWageFileGenerator.istrSSNCount = strArr[4]; dataExist = true; using (SqlCommand command = new SqlCommand( "select employer_account_id, fein " + "from sgt_employer where employer_account_id = @ean", connection)) { //connection.Open(); command.Parameters.Add(new SqlParameter("ean", objWageFileGenerator.iintEAN)); reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { if ((reader.GetInt32(0) != Int32.Parse(objWageFileGenerator.iintEAN)) || (reader.GetString(1) != objWageFileGenerator.istrFEIN)) { MessageBox.Show(objWageFileGenerator.iintEAN + " does not exist in the database"); dataExist = false; } } } else { MessageBox.Show(objWageFileGenerator.iintEAN + " does not exist in the database"); dataExist = false; } reader.Close(); } if (dataExist == true) { objWageFileGenerator.GenerateFile(); Thread.Sleep(2000); Array.Clear(strArr, 0, strArr.Length); } else { dataExist = true; } } else if (objWageFileGenerator.istrUserType == "agent") { if (j == 0) { strArr = line.Split(','); objWageFileGenerator.istrAgentFEIN = strArr[0]; objWageFileGenerator.istrEANCount = strArr[1]; Int32.TryParse(objWageFileGenerator.istrEANCount, out j); } else if (j > 0) { objAgentFileDataItems = new busAgentFileDataItems(); strArr = line.Split(','); objAgentFileDataItems.istrEAN = strArr[0]; objAgentFileDataItems.istrReportQuarter = strArr[1]; objAgentFileDataItems.istrReportYear = strArr[2]; objAgentFileDataItems.istrSSNCounts = strArr[3]; objWageFileGenerator.iclbAgentFileData.Push(objAgentFileDataItems); Array.Clear(strArr, 0, strArr.Length); if (j == 1) { objWageFileGenerator.GenerateFile(); Thread.Sleep(2000); } j--; } } } MessageBox.Show("Done"); connection.Close(); }