C# (CSharp) WebCM DbAccess.CreateNewSqlCommand Examples

Example #1

File: NW_SignalLog.cs Project: tayeumi/HFC

 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

File: NW_Teamview.cs Project: tayeumi/HFC

        public DataTable NW_Teamview_Getlist()
        {
            string   procname = "NW_Teamview_Getlist";
            DbAccess db       = new DbAccess();

            db.CreateNewSqlCommand();
            return(db.ExecuteDataTable(procname));
        }

Example #3

File: NW_SignalLog.cs Project: tayeumi/HFC

        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 #4

File: NW_Traffic.cs Project: tayeumi/HFC

 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 #5

        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 #6

File: NW_Teamview.cs Project: tayeumi/HFC

 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 #7

File: NW_Teamview.cs Project: tayeumi/HFC

        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 #8

File: NW_Teamview.cs Project: tayeumi/HFC

 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 #9

File: NW_Teamview.cs Project: tayeumi/HFC

        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 #10

File: NW_Teamview.cs Project: tayeumi/HFC

 public DataTable NW_Teamview_Getlist()
 {
     string procname = "NW_Teamview_Getlist";
     DbAccess db = new DbAccess();
     db.CreateNewSqlCommand();
     return db.ExecuteDataTable(procname);
 }