private static void HandleFirstRows() { List <string> assemblyEntries = ColumnUtils.FindColumn(_list, "Assembly", out _).GetLastChunk().Entries; List <string> partEntries = ColumnUtils.FindColumn(_list, "Part", out _).GetLastChunk().Entries; List <string> gradeEntries = ColumnUtils.FindColumn(_list, "Grade", out _).GetLastChunk().Entries; List <string> weightEntries = ColumnUtils.FindColumn(_list, "Weight", out _).GetLastChunk().Entries; List <string> lengthEntries = ColumnUtils.FindColumn(_list, "Length", out _).GetLastChunk().Entries; for (int entryIndex = 0; entryIndex < assemblyEntries.Count; entryIndex++) { string partEntry = partEntries.ElementAt(entryIndex); if (!partEntry.Contains(" ")) { string gradeEntry = gradeEntries.ElementAt(entryIndex); assemblyEntries.UpdateElementAt(entryIndex, partEntry); partEntries.UpdateElementAt(entryIndex, ""); weightEntries.InsertAndRemoveLastElement(entryIndex, gradeEntry); gradeEntries.UpdateElementAt(entryIndex, ""); lengthEntries.InsertAndRemoveLastElement(entryIndex, ""); } } }
private static void SetColumnsInOrder() { StringColumn sizeColumn = ColumnUtils.FindColumn(_list, "Size", out _); StringColumn classColumn = GenerateClassColumn(); StringColumn quantityColumn = ColumnUtils.FindColumn(_list, "Quantity", out _); StringColumn standardColumn = ColumnUtils.FindColumn(_list, "Standard", out _); StringColumn notesColumn = GenerateNotesColumn(); _list.Columns = new List <StringColumn>(new [] { sizeColumn, classColumn, quantityColumn, standardColumn, notesColumn }); }
private static void ReplaceTextInSize() { StringColumn sizeColumn = ColumnUtils.FindColumn(_list, "Size", out _); StringColumn standardColumn = ColumnUtils.FindColumn(_list, "Standard", out _); StringColumn nameColumn = ColumnUtils.FindColumn(_list, "Name", out _); for (int chunkIndex = 0; chunkIndex < sizeColumn.Data.Count; chunkIndex++) { DataChunk sizeChunk = sizeColumn.Data.ElementAt(chunkIndex); DataChunk standardChunk = standardColumn.Data.ElementAt(chunkIndex); DataChunk nameChunk = nameColumn.Data.ElementAt(chunkIndex); for (int entryIndex = 0; entryIndex < sizeChunk.Entries.Count; entryIndex++) { string sizeEntry = sizeChunk.Entries.ElementAt(entryIndex); string standardEntry = standardChunk.Entries.ElementAt(entryIndex); string nameEntry = nameChunk.Entries.ElementAt(entryIndex); sizeEntry = sizeEntry.Replace("BOLT", IsHVM(standardEntry) ? "HVM" : "M") .Replace("NUT", "Nakrętka M") .Replace("WASHER", "Podkładka"); while (sizeEntry.Contains(".0")) { sizeEntry = sizeEntry.Replace(".0", "."); } sizeEntry = sizeEntry.Replace(".", string.Empty); if (nameEntry.Contains("HILTI")) { string sizePrefix = nameEntry.Split(" ").ElementAt(1); sizeEntry = sizePrefix + " " + sizeEntry; standardChunk.Entries.Insert(entryIndex, "Kotew HILTI"); standardChunk.Entries.RemoveAt(entryIndex + 1); } if (nameEntry.Contains("ANCHORBAR")) { standardChunk.Entries.Insert(entryIndex, "Pręt gwintowany"); standardChunk.Entries.RemoveAt(entryIndex + 1); } sizeChunk.Entries.Insert(entryIndex, sizeEntry); sizeChunk.Entries.RemoveAt(entryIndex + 1); } } }
private static void FillRemainingColumns() { List <string> assemblyEntries = ColumnUtils.FindColumn(_list, "Assembly", out _).GetLastChunk().Entries; int numAssemblyEntries = assemblyEntries.Count; List <StringColumn> columns = _list.Columns; foreach (StringColumn column in columns) { DataChunk data = column.Data.First(); int numEntries = data.Entries.Count; int remainingEntries = numAssemblyEntries - numEntries; for (int i = 0; i < remainingEntries; i++) { data.Entries.Add(""); } } }
private static BoltsDeliveryContentType GetEntryContentType(int entryIndex) { IEnumerable <StringColumn> columns = _list.Columns; StringColumn sizeColumn = ColumnUtils.FindColumn(_list, "Size", out _); StringColumn nameColumn = ColumnUtils.FindColumn(_list, "Name", out _); StringColumn standardColumn = columns.First(); string sizeEntry = sizeColumn.GetLastChunk().Entries.ElementAt(entryIndex).ToUpper(); string nameEntry = nameColumn.GetLastChunk().Entries.ElementAt(entryIndex).ToUpper(); string standardEntry = standardColumn.GetLastChunk().Entries.ElementAt(entryIndex).ToUpper(); if (standardEntry.Contains("HILTI")) { return(BoltsDeliveryContentType.Null); } if (nameEntry.Contains("HILTI")) { return(BoltsDeliveryContentType.Hilti); } if (nameEntry.Contains("ANCHORBAR")) { return(BoltsDeliveryContentType.Anchorbar); } if (sizeEntry.Contains("BOLT")) { return(BoltsDeliveryContentType.Bolt); } if (sizeEntry.Contains("NUT")) { return(BoltsDeliveryContentType.Nut); } if (sizeEntry.Contains("WASHER")) { return(BoltsDeliveryContentType.Washer); } return(BoltsDeliveryContentType.Null); }
private static void MoveToRightColumns() { List <string> assemblyEntries = ColumnUtils.FindColumn(_list, "Assembly", out _).GetLastChunk().Entries; for (int entryIndex = 0; entryIndex < assemblyEntries.Count; entryIndex++) { List <StringColumn> columns = _list.Columns; for (int columnIndex = columns.Count - 2; columnIndex >= 0; columnIndex--) { List <string> leftEntries = columns.ElementAt(columnIndex).Data.First().Entries; List <string> rightEntries = columns.ElementAt(columnIndex + 1).Data.First().Entries; string leftEntry = leftEntries.ElementAt(entryIndex); leftEntries.RemoveAt(entryIndex); leftEntries.Insert(entryIndex, ""); rightEntries.RemoveAt(entryIndex); rightEntries.Insert(entryIndex, leftEntry); } } }