Beispiel #1
0
        public int GetFreshUser(string Username)
        {
            string sql     = "Select COUNT(*) from Audit_Trail where UserName = @0";
            var    _actual = _db.ExecuteScalar <int>(sql, Username);

            return(Convert.ToInt32(_actual));
        }
Beispiel #2
0
        public int GetLoginSequence()
        {
            string sql          = "select top 1 Tid from User_Tracking order by Tid desc";
            int    lastSequence = _db.ExecuteScalar <int>(sql);

            return(lastSequence);
        }
Beispiel #3
0
 public int GetLoginSequence()
 {
     return(_db.ExecuteScalar <int>("select top 1 Tid from User_Tracking order by Tid desc"));
 }