public bool Update()
{
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("@Bootfile", Bootfile);
db.AddParameter("@Location", Location);
db.AddParameter("@Note", Note);
db.ExecuteNonQueryWithTransaction("NW_Dhcp_Customer_Update");
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 bool UpdateSignal()
{
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("@Location", Location);
db.AddParameter("@Status", Status);
db.AddParameter("@DateTime", DateTime);
db.ExecuteNonQueryWithTransaction("NW_Device_UpdateSignal");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
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 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 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("@ID", ID);
db.ExecuteNonQueryWithTransaction("NW_Teamview_Delete");
db.CommitTransaction();
return(true);
}
catch
{
db.RollbackTransaction();
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 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 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 Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.ExecuteNonQueryWithTransaction("NW_Device_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 UpdateByPath()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@NodeCode", NodeCode);
db.AddParameter("@Path", Path);
db.ExecuteNonQueryWithTransaction("NW_Node_UpdateByPath");
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("@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("@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("@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 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);
}
}
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 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 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 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 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 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;
}
}
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;
}
}