コード例 #1
0
        public static bool ValidateUserLogin(string username, string password)
        {
            SqlConnection sqlConnection = (SqlConnection)DBConfigDAL.GetConnection();

            try
            {
                string SQLprocedure = "dbo.CheckPassword";

                SqlCommand sqlCommand = new SqlCommand(SQLprocedure, (SqlConnection)sqlConnection);
                sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;

                sqlCommand.Parameters.AddWithValue("@username", username);
                sqlCommand.Parameters.AddWithValue("@password", password);

                sqlConnection.Open();
                string validate = sqlCommand.ExecuteScalar().ToString();
                if (validate == "true")
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return(false);
            }
            finally
            {
                DBConfigDAL.CloseConnection((SqlConnection)sqlConnection);
            }
        }
コード例 #2
0
        public static bool Create(UserBO user)
        {
            IDbConnection conn = DBConfigDAL.GetConnection();

            try
            {
                string sqlProcedure = "dbo.CreateUser";

                SqlCommand sqlCommand = new SqlCommand(sqlProcedure, (SqlConnection)conn);
                sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;


                SqlParameter sqlPrm = sqlCommand.Parameters.Add("@name", SqlDbType.NVarChar);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.name;

                sqlPrm           = sqlCommand.Parameters.Add("@lastName", SqlDbType.NVarChar);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.lastName;

                sqlPrm           = sqlCommand.Parameters.Add("@email", SqlDbType.NVarChar);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.email;

                sqlPrm           = sqlCommand.Parameters.Add("@registerDate", SqlDbType.Date);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.RegisterDate;

                sqlPrm           = sqlCommand.Parameters.Add("@username", SqlDbType.NVarChar);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.userName;

                sqlPrm           = sqlCommand.Parameters.Add("@password", SqlDbType.NVarChar);
                sqlPrm.Direction = ParameterDirection.Input;
                sqlPrm.Value     = user.password;

                conn.Open();
                sqlCommand.ExecuteScalar();

                return(true);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                DBConfigDAL.CloseConnection((SqlConnection)conn);
            }
        }