示例#1
0
        private static IList <User> GetUsersFromDataBase()
        {
            IRepositorySettings repositorySettingss = new RepositorySettings();
            DbUserRepository    userRepository      = new DbUserRepository(repositorySettingss);

            return(userRepository.GetAll());
        }
示例#2
0
        public static void Main(string[] args)
        {
            XmlDocument doc = new XmlDocument();

            doc.Load("../../conf.xml");

            string dbname = "";

            try
            {
                foreach (XmlNode node in doc.DocumentElement.ChildNodes)
                {
                    string text = node.InnerText;
                    if (node.Name.Equals("database"))
                    {
                        dbname = text;
                    }
                }
            }
            catch (NullReferenceException e)
            {
                Console.WriteLine(e.Message);
                return;
            }

            AbstractDbRepository <User, int> db = new DbUserRepository(dbname, "user");

            var lst = db.GetAll();

            foreach (var keyValuePair in lst.ToArray())
            {
                Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username);
            }
            Console.WriteLine("------------");

            db.Save(new User(19, "qwe", 3));

            lst = db.GetAll();
            foreach (var keyValuePair in lst.ToArray())
            {
                Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username);
            }
            Console.WriteLine("------------");

            db.Delete(18);

            lst = db.GetAll();
            foreach (var keyValuePair in lst.ToArray())
            {
                Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username);
            }
            Console.WriteLine("------------");

            db.Update(new User(19, "asd", 5));

            lst = db.GetAll();
            foreach (var keyValuePair in lst.ToArray())
            {
                Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username);
            }
            Console.WriteLine("------------");
        }