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; }
/// <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; }