/// Unpacks and writes out the FullNetwork file, returns the filepath
/// </summary>
/// <param name="Network"></param>
/// <param name="Path"></param>
public string WriteOutExcelDocument(FullNetwork Network, string FileName)
{
// Build data table from the Network
DataTable Table = new DataTable();
Table.Columns.Add("Network ID");
Table.Columns.Add("First Usable");
Table.Columns.Add("Last Usable");
Table.Columns.Add("Broadcast Address");
foreach (var subnet in Network.Subnets)
{
// Add the data to each collumn
DataRow Row = Table.NewRow();
Row[0] = subnet.NetworkId;
Row[1] = subnet.FirstUsable;
Row[2] = subnet.LastUsable;
Row[3] = subnet.BroadcastAddress;
Table.Rows.Add(Row);
}
string FilePath = FileName + ".xlsx";
XLWorkbook wb = new XLWorkbook();
wb.Worksheets.Add(Table, "Subnet Data");
wb.SaveAs(FilePath);
return(FilePath);
}
public SubnettingOutput(FullNetwork Network)
{
InitializeComponent();
_Network = Network;
AddressClassTextBox.Text = Network.Class.ToString();
SubnetMaskTextBox.Text = Network.NetMask.ToString();
AddressSpaceTextBox.Text = Network.AddressSpace.ToString();
BitsBorrowedTextBox.Text = Network.BitsBorrowed.ToString();
NumberOfSubnetsTextBox.Text = Network.NumberOfSubnets.ToString();
UsableHostsPerSubnetTextBox.Text = Network.UsableHosts.ToString();
if (Network.Class.ToString() != "C")
{
ExportToExcelButton.Visibility = Visibility.Hidden;
}
}
/// <summary>
/// Writes out subnet data to a specified file name
/// </summary>
/// <param name="Network"></param>
/// <param name="Name"></param>
public void WriteSubnetData(FullNetwork Network, string Name)
{
StreamWriter SubnetFile = new StreamWriter(Name);
SubnetFile.Write("Network ID First Usable Last Usable Broadcast Address \n");
foreach (var subnet in Network.Subnets)
{
StringBuilder Builder = new StringBuilder();
Builder.Append(subnet.NetworkId + " ");
Builder.Append(subnet.FirstUsable + " ");
Builder.Append(subnet.LastUsable + " ");
Builder.Append(subnet.BroadcastAddress + " \n");
string line = Builder.ToString();
SubnetFile.Write(line);
}
SubnetFile.Close();
}
static void Main(string[] args)
{
FullNetwork Network = new FullNetwork();
NetworkInfo Info;
NetworkBuilder Builder;
Info = new NetworkInfo();
Info.NumberOfHosts = 2046;
Info.RequiredSubnets = 32;
Info.SampleAddress = "172.16.2.5";
Builder = new NetworkBuilder(Info);
SubnetDataWriter Writer = new SubnetDataWriter();
Writer.WriteOutExcelDocument(Builder.BuiltNetwork, "Test");
//// Deprecated
//Info.Class = AddressClass.B; // Deprecated
//Info.NumberOfHosts = 14;
//Info.RequiredSubnets = 2;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//SubnetDataWriter Datawriter = new SubnetDataWriter();
//Datawriter.WriteSubnetData(Builder.BuiltNetwork);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "14-2");
//Info = new NetworkInfo();
//// Deprecated
//Info.Class = AddressClass.B; // Deprecated
//Info.NumberOfHosts = 14;
//Info.RequiredSubnets = 16;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "14-16");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 126;
//Info.RequiredSubnets = 2;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "126-2");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 62;
//Info.RequiredSubnets = 4;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "62-2");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 30;
//Info.RequiredSubnets = 8;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "30-8");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 6;
//Info.RequiredSubnets = 32;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "6-32");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 2;
//Info.RequiredSubnets = 64;
//Info.SampleAddress = "192.168.5.23";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "2-64");
//Info = new NetworkInfo();
//Info.NumberOfHosts = 15;
//Info.RequiredSubnets = 12;
//Info.SampleAddress = "192.168.3.2";
//Builder = new NetworkBuilder(Info);
//Datawriter.WriteOutExcelDocument(Builder.BuiltNetwork, "Test");
}
