/// <summary>
/// Retrives the values of the worksheet named "EngAssist" and saves them on the DBMaker EngValues list
/// </summary>
public static void EngAssist()
{
if (TreeViewManager.FilePath != "" && System.IO.File.Exists(TreeViewManager.FilePath))
{
int sheetCounter = 1;
int rowCounter = 4;
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(TreeViewManager.FilePath);
foreach (Excel.Worksheet sheet in xlWorkbook.Worksheets)
{
if (sheet.Name.Contains("EngAssist"))
{
DBMaker.EngValues.Clear();
while (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 2).Value != null)
{
if (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 2).Value != null)
{
arbeitsgruppe = xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 2).Value.ToString();
}
if (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 3).Value != null)
{
schutzkreis = xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 3).Value.ToString();
}
if (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 4).Value != null)
{
station = xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 4).Value.ToString();
}
if (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 5).Value == null)
{
stationsbez = "";
}
else
{
stationsbez = xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, 5).Value.ToString();
}
EngAssist Value = new EngAssist(arbeitsgruppe, schutzkreis, station, stationsbez);
int column = 8;
while (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, column).Value != null)
{
Value.Parts.Add(xlWorkbook.Sheets[sheetCounter].Cells(rowCounter, column).Value.ToString());
column += 1;
}
column = 8;
while (xlWorkbook.Sheets[sheetCounter].Cells(rowCounter + 1, column).Value != null)
{
Value.Valves.Add(xlWorkbook.Sheets[sheetCounter].Cells(rowCounter + 1, column).Value.ToString());
column += 1;
}
DBMaker.EngValues.Add(Value);
rowCounter += 2;
}
}
sheetCounter += 1;
}
xlWorkbook.Close(0);
xlApp.Quit();
}
}
/// <summary>
/// Retrives the values of the worksheet named "EngAssisst" and saves them on the DBMaker EngValues list
/// </summary>
public static void EngAssist(object[,] Matriz)
{
int rowCounter = 4;
DBMaker.EngValues.Clear();
while (Matriz[rowCounter, 2] != null)
{
if (Matriz[rowCounter, 2] != null)
{
arbeitsgruppe = Matriz[rowCounter, 2].ToString().Replace(" ", string.Empty);
}
if (Matriz[rowCounter, 3] != null)
{
schutzkreis = Matriz[rowCounter, 3].ToString().Replace(" ", string.Empty);
}
if (Matriz[rowCounter, 4] != null)
{
station = Matriz[rowCounter, 4].ToString().Replace(" ", string.Empty);
}
if (Matriz[rowCounter, 5] == null)
{
stationsbez = "";
}
else
{
stationsbez = Matriz[rowCounter, 5].ToString().Replace(" ", string.Empty);
}
EngAssist Value = new EngAssist(arbeitsgruppe, schutzkreis, station, stationsbez);
int column = 8;
while (Matriz[rowCounter, column] != null)
{
Value.Parts.Add(Matriz[rowCounter, column].ToString().Replace(" ", string.Empty));
column += 1;
if (column > Matriz.GetLength(0))
{
break;
}
}
column = 8;
while (Matriz[rowCounter + 1, column] != null)
{
Value.Valves.Add(Matriz[rowCounter + 1, column].ToString().Replace(" ", string.Empty));
column += 1;
if (column > Matriz.GetLength(0))
{
break;
}
}
DBMaker.EngValues.Add(Value);
rowCounter += 2;
if (rowCounter > Matriz.GetLength(0))
{
break;
}
}
}
