Пример #1
0
        public bool CreateUser(string name, string email, string password)
        {
            DateTime createdAt = new DateTime();

            createdAt = DateTime.Now;

            var userQuery = (from users in db.userinfo_db
                             where users.email == email
                             select users);

            if (userQuery.SingleOrDefault() == null)
            {
                var user = new userinfo_db
                {
                    name       = name,
                    email      = email,
                    password   = password,
                    created_at = createdAt
                };

                db.userinfo_db.Add(user);
                db.SaveChanges();
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #2
0
        public bool CreateUserFromTxtFile(string path)
        {
            DateTime createdAt = new DateTime();

            createdAt = DateTime.Now;
            string readText;

            try
            {
                readText = File.ReadAllText(path);
            }
            catch (Exception)
            {
                return(false);
            }


            List <string> textfileSplitted = new List <string>();

            textfileSplitted = readText.Split(new string[] { Environment.NewLine }, StringSplitOptions.None).ToList();
            List <string>      txtUserList = textfileSplitted.SelectMany(s => s.Split('\t')).ToList();
            List <userinfo_db> userList    = new List <userinfo_db>();


            for (int i = 0; i < txtUserList.Count;)
            {
                for (int j = 1; j < txtUserList.Count;)
                {
                    for (int k = 2; k < txtUserList.Count;)
                    {
                        var user = new userinfo_db
                        {
                            name       = txtUserList[i],
                            email      = txtUserList[j],
                            password   = txtUserList[k],
                            created_at = createdAt
                        };

                        var userTxtQuery = (from users in db.userinfo_db
                                            where users.email == user.email
                                            select users);

                        if (userTxtQuery.SingleOrDefault() == null)
                        {
                            userList.Add(user);
                        }

                        i += 3;
                        j += 3;
                        k += 3;
                    }
                }
            }

            if (userList.Count != 0)
            {
                foreach (var listedUser in userList)
                {
                    db.userinfo_db.Add(listedUser);
                    db.SaveChanges();
                }

                return(true);
            }

            else
            {
                return(false);
            }
        }