/// <summary>
/// ReadIPAMFiles()
/// </summary>
/// <param name="searchFile"></param>
protected void ReadIPAMFiles(string searchFile)
{
try
{
string[] lines = System.IO.File.ReadAllLines(searchFile);
//Fill myIPAMList - LIST<myIPAMClass>
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
myIPAMClass ln = new myIPAMClass
{
ID = i,
IPAddress = cols[0],
Status = "Active",
Description = cols[2],
Hostname = cols[3],
Mac = cols[4],
TheSwitch = "",
Unknown = "",
Port = cols[7],
Note = cols[8],
SerialNumber = cols[9],
DeviceLocation = cols[10]
};
myIPAMList.Add(ln);
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", Length = " + fLine.Length);
//throw;
}
}
}
catch (Exception e)
{
MessageBox.Show("An error occurred while reading the File. Error: " + e.Message);
//throw;
}
}
private void ReadFileColumns(string fn)
{
string[] lines = System.IO.File.ReadAllLines(fn);
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
if (Int32.TryParse(cols[0], out int x))
{
// you know that the parsing attempt was successful
myIPAMClass ln = new myIPAMClass
{
ID = x, //i is current line number
IPAddress = cols[6],
Status = "Active",
Description = cols[1],
Hostname = "CCTV",
Mac = cols[8],
TheSwitch = "",
Unknown = "",
Port = (cols[3] + " & " + cols[2]).ToUpper(), //Switch & Data
Note = "",
SerialNumber = cols[9],
DeviceLocation = cols[1]
};
myIPAMList.Add(ln);
}
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", line # = " + i);
//throw;
}
}
}
/// <summary>
/// ReadXCELFile()
/// </summary>
/// <param name="searchFile"></param>
/// <param name="type"></param>
protected void ReadXCELFile(string searchFile, string type)
{
try
{
string[] lines = System.IO.File.ReadAllLines(searchFile);
//Converts CBS CCTV spreadsheet format to IPAM Import Format
if (type == "CCTV")
{
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
if (Int32.TryParse(cols[0], out int x))
{
// you know that the parsing attempt was successful
myIPAMClass ln = new myIPAMClass
{
ID = x, //i is current line number
IPAddress = cols[6],
Status = "Active",
Description = cols[1],
Hostname = "CCTV",
Mac = cols[8],
TheSwitch = "",
Unknown = "",
Port = (cols[3] + " & " + cols[2]).ToUpper(), //Switch & Data
Note = "",
SerialNumber = cols[9],
DeviceLocation = cols[1]
};
myIPAMList.Add(ln);
}
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", line # = " + i);
//throw;
}
}
}
//Converts CBS Access Control spreadsheet format to IPAM Import Format
if (type == "Access Control")
{
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
if (Int32.TryParse(cols[0], out int x))
{
// you know that the parsing attempt was successful
myIPAMClass ln = new myIPAMClass
{
ID = x,
IPAddress = cols[6],
Status = "Active",
Description = cols[1],
Hostname = "Access Control",
Mac = cols[7],
TheSwitch = "",
Unknown = "",
Port = (cols[2] + " & " + cols[3]).ToUpper(), //Switch & Data
Note = "",
SerialNumber = cols[8],
DeviceLocation = cols[1]
};
myIPAMList.Add(ln);
}
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", line # = " + i);
//throw;
}
}
}
//Converts CBS Workstations spreadsheet format to IPAM Import Format
if (type == "Workstations")
{
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
myIPAMClass ln = new myIPAMClass
{
ID = i,
IPAddress = cols[0],
Status = "Active",
Description = cols[2],
Hostname = cols[3],
Mac = cols[4],
TheSwitch = "",
Unknown = "",
Port = cols[7], //Switch & Data
Note = cols[8],
SerialNumber = cols[9],
DeviceLocation = cols[10]
};
myIPAMList.Add(ln);
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", Length = " + fLine.Length);
//throw;
}
}
}
// No conversion
if (type == "IPAM Import")
{
for (int i = 1; i <= (lines.Count() - 1); i++)
{
string[] cols;
string fLine = "";
try
{
fLine = lines[i].ToString();
cols = fLine.Split(',');
myIPAMClass ln = new myIPAMClass
{
ID = i,
IPAddress = cols[0],
Status = cols[1],
Description = cols[2],
Hostname = cols[3],
Mac = cols[4],
TheSwitch = cols[5],
Unknown = cols[6],
Port = cols[7], //Switch & Data
Note = cols[8],
SerialNumber = cols[9],
DeviceLocation = cols[10]
};
myIPAMList.Add(ln);
}
catch (Exception E1)
{
MessageBox.Show("An error occurred while processing the File. Error: " + E1.Message + ", fLine = " + fLine + ", Length = " + fLine.Length);
//throw;
}
}
}
}
catch (Exception e)
{
MessageBox.Show("An error occurred while reading the File. Error: " + e.Message);
//throw;
}
}
