private void processClientExcel() { //parse data from file OpenFileDialogOpen.InitialDirectory = @"C:\"; OpenFileDialogOpen.Title = "Browse CSV Files"; OpenFileDialogOpen.DefaultExt = "csv"; OpenFileDialogOpen.Filter = "csv files (*.csv)|*.csv|All files (*.*)|*.*"; OpenFileDialogOpen.CheckFileExists = true; OpenFileDialogOpen.CheckPathExists = true; OpenFileDialogOpen.Multiselect = false; List <CliMat> cliMatList = new List <CliMat>(); if (OpenFileDialogOpen.ShowDialog() == DialogResult.OK) { int lineNum = 0; var fileStream = new FileStream(OpenFileDialogOpen.FileName, FileMode.Open, FileAccess.Read); using (var streamReader = new StreamReader(fileStream)) { string line; while ((line = streamReader.ReadLine()) != null) { lineNum++; if (lineNum > 1) // ignore header line { TextFieldParser parser = new TextFieldParser(new StringReader(line)); // You can also read from a file // TextFieldParser parser = new TextFieldParser("mycsvfile.csv"); parser.HasFieldsEnclosedInQuotes = true; parser.SetDelimiters(","); string[] fields; while (!parser.EndOfData) { fields = parser.ReadFields(); CliMat cm = new CliMat(); cm.clicode = fields[0]; cm.name = fields[1].Replace("%", "").Replace("'", ""); cm.clisys = getCliSysNbr(cm.clicode); //cm.remarks = fields[3].Replace("%", "").Replace("'", "").Replace('\u00A0', ' '); string cleaned = ""; string pattern = @"[^\u0000-\u007F]+"; string replacement = " "; Regex rgx = new Regex(pattern); cleaned = rgx.Replace(fields[3].Replace("%", "").Replace("'", ""), replacement); cm.remarks = cleaned; cm.branch = fields[2].Replace("%", "").Replace("'", ""); cliMatList.Add(cm); } parser.Close(); } } } //change tab defaults //order all items by client and matter code var finalList = cliMatList.OrderBy(x => x.clicode).ToList(); int total = finalList.Count; int runningTotal = 0; foreach (CliMat cc in finalList) { if (cc.clisys != 0) { processSingleClient(cc); } else { ErrorLog er = new ErrorLog(); er.client = cc.clicode; er.message = "Client " + cc.clicode + " does not appear to be a valid client. Check that the entered code matches what is displayed in Core exactly." + "\r\n" + "\r\n"; //still close client even with no matters errorList.Add(er); } runningTotal++; UpdateStatus("Updating....", runningTotal, total); } showFinish(); errorList.Clear(); clientFilePath = ""; matterFilePath = ""; } }
private void DoDaFix() { switch (activeTab) // 0 client, 1 matter { case 0: if (checkClientBoxesForInfo()) { CliMat cm = new CliMat(); cm.clicode = textBoxClientText.Text; cm.name = textBoxCliName.Text.Replace("%", "").Replace("'", ""); cm.remarks = richTextBoxCliRemarks.Text.Replace("%", "").Replace("'", "").Replace("\"", ""); cm.branch = textBoxCliBranch.Text.Replace("%", "").Replace("'", ""); processSingleClient(cm); showFinish(); } break; case 1: if (checkMatterBoxesForInfo()) { CliMat cm = new CliMat(); cm.clicode = textBoxClientMatter.Text; cm.matcode = textBoxMatterText.Text; cm.name = ""; if (!string.IsNullOrEmpty(richTextBoxRemarksMatter.Text.Replace("%", "").Replace("'", ""))) { cm.remarks = richTextBoxRemarksMatter.Text.Replace("%", "").Replace("'", ""); } else { cm.remarks = ""; } cm.branch = ""; cm.matsys = getMatSysNbr(cm.clicode, cm.matcode); cm.clisys = getCliSysNbr(cm.clicode); if (cm.clisys != 0 && cm.matsys != 0) { processSingleMatter(cm.matsys, cm.remarks); } else { ErrorLog er = new ErrorLog(); er.client = cm.clicode; er.matter = cm.matcode; er.message = "Cannot close matter because client/matter " + cm.clicode + "/" + cm.matcode + " does not exist. \r\n" + "\r\n"; errorList.Add(er); } showFinish(); } // 0 is simply a place holder for method...means nothing break; } errorList.Clear(); clientFilePath = ""; matterFilePath = ""; textBoxClientText.Text = ""; textBoxCliBranch.Text = ""; textBoxCliName.Text = ""; richTextBoxCliRemarks.Text = ""; textBoxMatterText.Text = ""; richTextBoxRemarksMatter.Text = ""; textBoxClientMatter.Text = ""; }