protected void btnImport_Click(Object Sender, EventArgs e)
{
if (oFile.PostedFile != null && oFile.FileName != "")
{
oVariables = new Variables(intEnvironment);
string strFile = DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + "_" + oFile.FileName;
oFile.PostedFile.SaveAs(oVariables.UploadsFolder() + strFile);
int intNetwork = Int32.Parse(Request.Form[hdnVLAN.UniqueID]);
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + oVariables.UploadsFolder() + strFile + ";Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "ExcelInfo");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr[0].ToString().Trim() == "")
{
break;
}
string strIP = dr[0].ToString().Trim();
string strServer = dr[1].ToString().Trim();
int intIP1 = Int32.Parse(strIP.Substring(0, strIP.IndexOf(".")));
strIP = strIP.Substring(strIP.IndexOf(".") + 1);
int intIP2 = Int32.Parse(strIP.Substring(0, strIP.IndexOf(".")));
strIP = strIP.Substring(strIP.IndexOf(".") + 1);
int intIP3 = Int32.Parse(strIP.Substring(0, strIP.IndexOf(".")));
strIP = strIP.Substring(strIP.IndexOf(".") + 1);
int intIP4 = Int32.Parse(strIP);
int intIP = oIPAddresses.Add(intNetwork, intIP1, intIP2, intIP3, intIP4, -100);
int intDetail = oIPAddresses.AddDetails("", 0, "", 0, "", strServer, 0, 0, 0, 0, "", "", "", "", 0, 0);
oIPAddresses.AddDetail(intIP, intDetail);
intCount++;
}
Response.Redirect(Request.Path + "?done=" + intCount.ToString());
}
}
