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);
}
}
}
