Example #1
0
 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);
 }
Example #2
0
 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);
 }
Example #3
0
 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;
     }
 }
Example #4
0
 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;
     }
 }
Example #5
0
 public DataTable NW_Teamview_Getlist()
 {
     string procname = "NW_Teamview_Getlist";
     DbAccess db = new DbAccess();
     db.CreateNewSqlCommand();
     return db.ExecuteDataTable(procname);
 }