public DataTable NW_InterfaceControllerWarning_GetList_Low()
{
string procname = "NW_InterfaceControllerWarning_GetList_Low";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@IpAddress", IpAddress);
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@MacAddress_CMTS", MacAddress_CMTS);
db.AddParameter("@CustomerCode", CustomerCode);
db.AddParameter("@CustomerName", CustomerName);
db.AddParameter("@CustomerAddress", CustomerAddress);
db.AddParameter("@PoolIp", PoolIp);
db.AddParameter("@Bootfile", Bootfile);
db.AddParameter("@IpPublic", IpPublic);
db.AddParameter("@MacPc", MacPc);
db.AddParameter("@PoolPublic", PoolPublic);
db.AddParameter("@Location", Location);
db.AddParameter("@Note", Note);
db.ExecuteNonQueryWithTransaction("NW_Dhcp_Customer_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public DataTable NW_Device_Status_GetList()
{
string procname = "NW_Device_Status_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public string GetNewCode()
{
string procname = "NW_Node_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
DataTable dt = db.ExecuteDataTable(procname);
if (dt.Rows.Count > 0)
{
string _strCode = dt.Rows[dt.Rows.Count - 1][0].ToString();
_strCode = _strCode.Substring(2, _strCode.Length - 2);
int next_id = int.Parse(_strCode) + 1;
switch (next_id.ToString().Length)
{
case 1:
return "N00000" + next_id.ToString();
case 2:
return "N0000" + next_id.ToString();
case 3:
return "N000" + next_id.ToString();
case 4:
return "N00" + next_id.ToString();
case 5:
return "N0" + next_id.ToString();
case 6:
return "N" + next_id.ToString();
}
}
return "N000001";
}
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_Interface_Getlist()
{
string procname = "NW_Interface_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public bool Insert(DataTable dt)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
InterfaceController = dt.Rows[i]["InterfaceController"].ToString();
Signal = dt.Rows[i]["Signal"].ToString();
db.CreateNewSqlCommand();
db.AddParameter("@InterfaceController", InterfaceController);
db.AddParameter("@Signal", Signal);
db.AddParameter("@Datetime", DateTime.Now);
db.ExecuteNonQueryWithTransaction("NW_InterfaceControllerWarning_Insert");
}
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public DataTable NW_Device_Status_GetByInterface()
{
string procname = "NW_Device_Status_GetByInterface";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Interface", Interface);
return db.ExecuteDataTable(procname);
}
public bool Insert(DataTable dt)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
InterfaceName = dt.Rows[i]["InterfaceName"].ToString();
FullName = dt.Rows[i]["FullName"].ToString();
Inbps = (float)dt.Rows[i]["Inbps"];
Outbps = (float)dt.Rows[i]["Outbps"];
InBandwidth = (double)dt.Rows[i]["InBandwidth"];
OutBandwidth = (double)dt.Rows[i]["OutBandwidth"];
InPercentUtil = int.Parse(dt.Rows[i]["InPercentUtil"].ToString());
OutPercentUtil = int.Parse(dt.Rows[i]["OutPercentUtil"].ToString());
LastSync = (DateTime)dt.Rows[i]["LastSync"];
Status = dt.Rows[i]["Status"].ToString();
db.CreateNewSqlCommand();
db.AddParameter("@InterfaceName", InterfaceName);
db.AddParameter("@FullName", FullName);
db.AddParameter("@Inbps", Inbps);
db.AddParameter("@Outbps", Outbps);
db.AddParameter("@InBandwidth", InBandwidth);
db.AddParameter("@OutBandwidth", OutBandwidth);
db.AddParameter("@InPercentUtil", InPercentUtil);
db.AddParameter("@OutPercentUtil", OutPercentUtil);
db.AddParameter("@DateTime", DateTime);
db.AddParameter("@StrDate", StrDate);
db.AddParameter("@LastSync", LastSync);
db.AddParameter("@Status", Status);
db.ExecuteNonQueryWithTransaction("NW_InterfaceLog_Insert");
}
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
db.ExecuteNonQueryWithTransaction("NW_Teamview_Delete");
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
public bool DeleteAll()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.ExecuteNonQueryWithTransaction("NW_CurrentTrafic_DeleteAll");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@NodeCode", NodeCode);
db.ExecuteNonQueryWithTransaction("NW_Node_Delete");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@Name", Name);
db.AddParameter("@IpAddress", IpAddress);
db.ExecuteNonQueryWithTransaction("NW_OpticalSW_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@Interface", Interface);
db.AddParameter("@SignalGroup", SignalGroup);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("NW_Interface_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
db.AddParameter("@Pass", Pass);
db.AddParameter("@User", User);
db.AddParameter("@PC", PC);
db.AddParameter("@DateTime", DateTime);
db.ExecuteNonQueryWithTransaction("NW_Teamview_Insert");
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@Interface", Interface);
db.AddParameter("@Modems", Modems);
db.AddParameter("@Hosts", Hosts);
db.AddParameter("@DateTime", DateTime);
db.ExecuteNonQueryWithTransaction("NW_Device_Status_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@DS", DS);
db.AddParameter("@US", US);
db.AddParameter("@DateTime", DateTime);
db.AddParameter("@CurrentDS", CurrentDS);
db.AddParameter("@CurrentUS", CurrentUS);
db.ExecuteNonQueryWithTransaction("NW_CurrentTrafic_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public DataTable NW_SignalLog_5Day_GetSNRLow()
{
string procname = "NW_SignalLog_5Day_GetSNRLow";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Day", Day);
db.AddParameter("@Minute", Minute);
return db.ExecuteDataTable(procname);
}
public DataTable NW_CurrentTrafic_GetAll()
{
string procname = "NW_CurrentTrafic_GetAll";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Trafic_Get()
{
string procname = "NW_Trafic_Get";
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_SignalLog_GetByMac()
{
string procname = "NW_SignalLog_GetByMac";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return db.ExecuteDataTable(procname);
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@NodeCode", NodeCode);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("NW_Device_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public bool Update()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@Value1", Value1);
db.AddParameter("@Value2", Value2);
db.AddParameter("@Value3", Value3);
db.AddParameter("@DateTime", DateTime);
db.AddParameter("@Status", Status);
db.ExecuteNonQueryWithTransaction("NW_Device_Update");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public DataTable NW_Node_Get()
{
string procname = "NW_Node_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@NodeCode", NodeCode);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Dhcp_Customer_GetbyMacaddress()
{
string procname = "NW_Dhcp_Customer_GetbyMacaddress";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return db.ExecuteDataTable(procname);
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@IpPrivate", IpPrivate);
db.AddParameter("@IpPublic1", IpPublic1);
db.AddParameter("@IpPublic2", IpPublic2);
db.AddParameter("@Value1", Value1);
db.AddParameter("@Value2", Value2);
db.AddParameter("@Value3", Value3);
db.AddParameter("@Value4", Value4);
db.AddParameter("@Status", Status);
db.AddParameter("@Location", Location);
db.AddParameter("@DateTime", DateTime);
db.AddParameter("@Description", Description);
db.AddParameter("@CurrentDS", CurrentDS);
db.AddParameter("@CurrentUS", CurrentUS);
db.ExecuteNonQueryWithTransaction("NW_SignalLog_Insert");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
public DataTable NW_Dhcp_Customer_GetbyPoolPublic()
{
string procname = "NW_Dhcp_Customer_GetbyPoolPublic";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@PoolIp", PoolIp);
return db.ExecuteDataTable(procname);
}
public DataTable NW_OpticalSW_Get()
{
string procname = "NW_OpticalSW_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
return db.ExecuteDataTable(procname);
}
public bool NW_Dhcp_Customer_UpdateIPStatic()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@IpAddress", IpAddress);
db.AddParameter("@IpPublic", IpPublic);
db.AddParameter("@PoolPublic", PoolPublic);
db.AddParameter("@MacPc", MacPc);
db.AddParameter("@Note", Note);
db.ExecuteNonQueryWithTransaction("NW_Dhcp_Customer_UpdateIPStatic");
db.CommitTransaction();
return true;
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return false;
}
}
