public DataTable NW_SignalLog_5Day_GetByMacLike()
{
string procname = "NW_SignalLog_5Day_GetByMacLike";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
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 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 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.AddParameter("@Location", Location);
db.ExecuteNonQueryWithTransaction("NW_Teamview_Insert");
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
public DataTable NW_Teamview_Getlist()
{
string procname = "NW_Teamview_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}