Exemple #1
0
        public bool Register(RegisterPackage package)
        {
            if (null != package.Phone && "" != package.Phone)
            {
                string sql_checkphone = "select * from " +
                                        DBStaticData.DataBaseUserTableName +
                                        " where " +
                                        DBStaticData.DataBaseUserTablePhoneField + " = '" + package.Phone + "'";
                if (ExecuteNonDataSet(sql_checkphone, out DataSet set))
                {
                    if (0 != set.Tables.Count)
                    {
                        if (0 != set.Tables[0].Rows.Count)
                        {
                            return(false);
                        }
                    }
                    else
                    {
                        return(false);
                    }
                }
                else
                {
                    return(false);
                }
            }
            string token = DBStaticMethod.GetToken();
            string sql   = string.Format
                           (
                "insert into {0} values ('{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', {8})",
                DBStaticData.DataBaseUserTableName,
                package.ID,
                DBStaticMethod.SHA256(package.Password, token),
                token,
                package.Name,
                package.Email,
                package.Phone,
                package.Describe,
                package.Photo.ToString()
                           );

            if (!ExecuteNonQuery(sql))
            {
                return(false);
            }
            return(true);
        }
Exemple #2
0
        public bool UpdatePassword(string email, string npw)
        {
            string token = DBStaticMethod.GetToken();
            string sql   = string.Format
                           (
                "update {0} set {1} = '{2}', {3} = '{4}' where {5} = '{6}'",
                DBStaticData.DataBaseUserTableName,
                DBStaticData.DataBaseUserTableTokenField,
                token,
                DBStaticData.DataBaseUserTablePasswordField,
                DBStaticMethod.SHA256(npw, token),
                DBStaticData.DataBaseUserTableEmailField,
                email
                           );

            return(ExecuteNonQuery(sql));
        }
Exemple #3
0
        public LoginResult Login(string user, string pw, LoginType type, out string userid)
        {
            string sql = string.Format
                         (
                "select {0}, {1}, {2} from {3} where ",
                DBStaticData.DataBaseUserTablePasswordField,
                DBStaticData.DataBaseUserTableTokenField,
                DBStaticData.DataBaseUserTableIDField,
                DBStaticData.DataBaseUserTableName
                         );

            userid = "";
            switch (type)
            {
            case LoginType.Email:
                sql += DBStaticData.DataBaseUserTableEmailField + " = '" + user + "'";
                break;

            case LoginType.Phone:
                sql += DBStaticData.DataBaseUserTablePhoneField + " = '" + user + "'";
                break;

            case LoginType.Identification:
                sql += DBStaticData.DataBaseUserTableIDField + " = '" + user + "'";
                break;

            default:
                return(LoginResult.Error_Server);
            }
            if (ExecuteNonDataSet(sql, out DataSet set))
            {
                if (
                    0 < set.Tables.Count &&
                    0 < set.Tables[0].Rows.Count
                    )
                {
                    string password = set.Tables[0].Rows[0].ItemArray[0] as string;
                    string token    = set.Tables[0].Rows[0].ItemArray[1] as string;
                    if (DBStaticMethod.SHA256(pw, token).Equals(password))
                    {
                        userid = set.Tables[0].Rows[0].ItemArray[2] as string;
                        return(LoginResult.Success);
                    }
                    else
                    {
                        return(LoginResult.Error_Password);
                    }
                }
                else
                {
                    switch (type)
                    {
                    case LoginType.Email:
                        return(LoginResult.Error_Email);

                    case LoginType.Phone:
                        return(LoginResult.Error_Phone);

                    case LoginType.Identification:
                        return(LoginResult.Error_User);
                    }
                }
            }
            return(LoginResult.Error_Server);
        }