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)); }
public int GetLoginSequence() { string sql = "select top 1 Tid from User_Tracking order by Tid desc"; int lastSequence = _db.ExecuteScalar <int>(sql); return(lastSequence); }
public int GetLoginSequence() { return(_db.ExecuteScalar <int>("select top 1 Tid from User_Tracking order by Tid desc")); }