コード例 #1
0
        public List<LoginLogsTracker> GetAllLoginLogsDetails()
        {
            List<LoginLogsTracker> lstLoginLogsTracker = new List<LoginLogsTracker>();

            try
            {
                using (NHibernate.ISession session = SessionFactory.GetNewSession())
                {
                    using (NHibernate.ITransaction transaction = session.BeginTransaction())
                    {
                        try
                        {
                            var res = session.CreateQuery("select count(Id),UserId,UserName from LoginLogs group by UserId order by LoginTime desc");

                            foreach (Object[] item in res.Enumerable())
                            {
                                try
                                {
                                    LoginLogsTracker objLoginLogsTracker = new LoginLogsTracker();
                                    objLoginLogsTracker._count = Convert.ToInt32(item[item.Length - 3]);
                                    objLoginLogsTracker._UserId = Guid.Parse(item[item.Length - 2].ToString());
                                    objLoginLogsTracker._UserName = (item[item.Length - 1].ToString());

                                    lstLoginLogsTracker.Add(objLoginLogsTracker);

                                }
                                catch (Exception ex)
                                {
                                    Console.WriteLine("Error : " + ex.StackTrace);
                                }
                            }

                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.StackTrace);
                            //return null;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                //return null;
            }

            return lstLoginLogsTracker;
        }
コード例 #2
0
        /// <GetAllLoginLogsDetails>
        /// Get All Login Logs Details
        /// </GetAllLoginLogsDetails>
        /// <returns>Return objects of LoginLogsTracker Class with value of each member in the form of list.(List<LoginLogsTracker>)</returns>
        public List<LoginLogsTracker> GetAllLoginLogsDetails()
        {
            //Create a list to store all object in list.
            List<LoginLogsTracker> lstLoginLogsTracker = new List<LoginLogsTracker>();

            try
            {
                //Creates a database connection and opens up a session
                using (NHibernate.ISession session = SessionFactory.GetNewSession())
                {
                    //After Session creation, start Transaction.
                    using (NHibernate.ITransaction transaction = session.BeginTransaction())
                    {
                        try
                        {
                            //Proceed action, to get all log record for an account
                            var res = session.CreateQuery("select count(Id),UserId,UserName from LoginLogs group by UserId order by LoginTime desc");

                            //Get the all return value from res
                            foreach (Object[] item in res.Enumerable())
                            {
                                try
                                {
                                    // Make new individual LoginLogsTracker object to set records
                                    LoginLogsTracker objLoginLogsTracker = new LoginLogsTracker();
                                    objLoginLogsTracker._count = Convert.ToInt32(item[item.Length - 3]);
                                    objLoginLogsTracker._UserId = Guid.Parse(item[item.Length - 2].ToString());
                                    objLoginLogsTracker._UserName = (item[item.Length - 1].ToString());
                                    //Add these records in the list.
                                    lstLoginLogsTracker.Add(objLoginLogsTracker);

                                }
                                catch (Exception ex)
                                {
                                    Console.WriteLine("Error : " + ex.StackTrace);
                                }
                            }

                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.StackTrace);
                            //return null;
                        }
                    }//End Transaction
                }//End Session
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                //return null;
            }

            return lstLoginLogsTracker;
        }