private void Add_Data_Line(TestDataFileParser parser) { SqlConnection sqlConnectionString = new SqlConnection(this.ConnectionString); string sqlString = "insert into ParserTable(Clinic_Number, Barcode, Patient_Id, Patient_Name, Dob, Gender, Collection_Date, Collection_Time, Test_Code, Test_Name, Result, Unit, Refrange_Low, Refrange_High, Note, Non_Spec_Ref) VALUES(@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16)"; using (SqlCommand cmd = new SqlCommand(sqlString, sqlConnectionString)) { cmd.Parameters.AddWithValue("@param1", parser.Clinic_Number); cmd.Parameters.AddWithValue("@param2", parser.BarCode); cmd.Parameters.AddWithValue("@param3", parser.PatientId); cmd.Parameters.AddWithValue("@param4", parser.PatientName); cmd.Parameters.AddWithValue("@param5", parser.Dob); cmd.Parameters.AddWithValue("@param6", parser.Gender); cmd.Parameters.AddWithValue("@param7", parser.CollectionDate); cmd.Parameters.AddWithValue("@param8", parser.CollectionTime); cmd.Parameters.AddWithValue("@param9", parser.TestCode); cmd.Parameters.AddWithValue("@param10", parser.TestName); cmd.Parameters.AddWithValue("@param11", parser.Result); cmd.Parameters.AddWithValue("@param12", parser.Unit); cmd.Parameters.AddWithValue("@param13", parser.RefrangeLow); cmd.Parameters.AddWithValue("@param14", parser.RefrangeHigh); cmd.Parameters.AddWithValue("@param15", parser.Note); cmd.Parameters.AddWithValue("@param16", parser.NonSpecRef); cmd.CommandType = CommandType.Text; try { sqlConnectionString.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error Message"); } } }
private void Read_File(string fileName) { String currentDirectory = Directory.GetCurrentDirectory(); DirectoryInfo currentDirectoryInfo = new DirectoryInfo(currentDirectory); String filePath = currentDirectoryInfo.Parent.Parent.FullName + "\\" + fileName; TestDataFileParser parser = new TestDataFileParser(); using (var fileStream = File.OpenRead(filePath)) using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true)) { String line; int lineNumber = 0; while ((line = streamReader.ReadLine()) != null) { lineNumber++; if (lineNumber > 1) { string[] valuesArray = line.Split('|'); parser.Clinic_Number = valuesArray[0]; parser.BarCode = valuesArray[1]; parser.PatientId = valuesArray[2]; parser.PatientName = valuesArray[3]; parser.Dob = valuesArray[4]; parser.Gender = valuesArray[5]; parser.CollectionDate = valuesArray[6]; parser.CollectionTime = valuesArray[7]; parser.TestCode = valuesArray[8]; parser.TestName = valuesArray[9]; parser.Result = valuesArray[10]; parser.Unit = valuesArray[11]; parser.RefrangeLow = valuesArray[12]; parser.RefrangeHigh = valuesArray[13]; parser.Note = valuesArray[14]; parser.NonSpecRef = valuesArray[15]; this.Add_Data_Line(parser); } } } }