public DataTable NW_Dhcp_Ip_GetbyCPEStatic()
{
string procname = "NW_Dhcp_Ip_GetbyCPEStatic";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Teamview_Getlist()
{
string procname = "NW_Teamview_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Trafic_Getlike()
{
string procname = "NW_Trafic_Getlike";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@Month", Month);
db.AddParameter("@Year", Year);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Trafic_GetByDay()
{
string procname = "NW_Trafic_GetByDay";
DbAccess db = new DbAccess();
if (MacAddress == null)
{
procname = "NW_Trafic_GetByDay";
}
else
{
procname = "NW_Trafic_GetByDayMac";
}
db.CreateNewSqlCommand();
if (MacAddress != null)
{
db.AddParameter("@MacAddress", MacAddress);
}
db.AddParameter("@Day", Day);
db.AddParameter("@Month", Month);
db.AddParameter("@Year", Year);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Dhcp_Ip_GetIPbyPool()
{
string procname = "NW_Dhcp_Ip_GetIPbyPool";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@PoolIp", PoolIp);
return db.ExecuteDataTable(procname);
}